sql server 2008 related queries in DbaXchanger | QueryXchanger

How to get SUM of Column With Different Category As Another Column

sql-server
Updated December 13, 2018 08:06 AM

Running Stored Procedures in Parallel in SSMS

sql-server sql-server-2016 stored-procedures
Updated December 13, 2018 08:06 AM

How to join a table with a table valued function?

sql-server sql-server-2012 join syntax functions
Updated December 12, 2018 21:06 PM

How do you use pvkconverter.exe - not working for me?

sql-server transparent-data-encryption
Updated December 12, 2018 20:06 PM

How to update one column in table from select statement?

sql-server update
Updated December 12, 2018 19:06 PM

how to integrate ola hallengren solution with log shipping?

sql-server backup sql-server-2017 log-shipping ola-hallengren
Updated December 12, 2018 19:06 PM

Creating/restoring mdf/ldf to non-default file location giving access denied

sql-server permissions restore datafile
Updated December 12, 2018 19:06 PM

Multi-statement Table Valued Function causing massive PAGELATCH_EX waits

sql-server-2017 set-returning-functions waits
Updated December 12, 2018 19:06 PM

Does @@FETCH_STATUS have (or need) an equivalent to SCOPE_IDENTITY?

sql-server sql-server-2008-r2 cursors
Updated December 12, 2018 18:06 PM

Does the Always Encrypted certificates get copied over in availability groups?

sql-server-2016 availability-groups always-encrypted
Updated December 12, 2018 18:06 PM

SSMS generated script failing to execute

sql-server sql-server-2014 sql-server-2016 ssms sqlcmd
Updated December 12, 2018 17:06 PM

Why would a Clustered Index Seek return a higher "Actual Number of Rows" than there are rows in the underlying table?

sql-server optimization execution-plan azure-sql-database
Updated December 12, 2018 17:06 PM

Is NEWSEQUENTIALID unique within a database for Many tables?

sql-server database-design sql-server-2016 performance-tuning
Updated December 12, 2018 16:06 PM

How to insert Error_Message using EXECUTE sp_executesql

sql-server
Updated December 12, 2018 16:06 PM

Is it possible to tell if an incoming connection is using an SQL Server Alias?

sql-server alias
Updated December 12, 2018 15:06 PM

SQL Server 2017 on Linux: SSMS connection attempt throws error 10054

sql-server linux sql-server-2017
Updated December 12, 2018 15:06 PM

How to get Feature Wise Count Per User?

sql-server sql-server-2017
Updated December 12, 2018 15:06 PM

Find related names in the table

sql-server
Updated December 12, 2018 13:06 PM

Good way to call multiple SQL Server Agent jobs sequentially from one main job?

sql-server sql-server-2008-r2 t-sql sql-server-agent
Updated December 12, 2018 13:06 PM

Shared locks taken under Read Committed Snapshot Isolation (RCSI)

sql-server sql-server-2008 locking snapshot-isolation
Updated December 12, 2018 12:06 PM

Find all occurrence of value from column b in column a

sql-server-2008
Updated December 12, 2018 11:06 AM

SQL Server 2016 AlwaysON

sql-server availability-groups
Updated December 12, 2018 11:06 AM

What are the causes of InnoDB Index Corruption?

mysql index innodb mysql-5.5 percona-server
Updated December 12, 2018 08:06 AM

Can a non-clustered index be transformed to a covering index in SQL Server?

sql-server nonclustered-index covering-index
Updated December 12, 2018 08:06 AM

Dead lock trace for sql server

sql-server-2014
Updated December 12, 2018 08:06 AM

How to access objects created by a different user

sql-server sql-server-2012
Updated December 12, 2018 07:06 AM

Import multi EXCEL files with relationship between them( Vlookup ) into MS SQL Server

sql-server-2016 import export excel
Updated December 12, 2018 06:06 AM

Does MSSQL Log shipping truncate the transaction log?

sql-server backup transaction-log log-shipping truncation
Updated December 12, 2018 04:06 AM

How to connect Microsoft SQL Database with Active Directory Password Authentication (AD Login)

sql-server
Updated December 12, 2018 04:06 AM

SQL Server - How to copy database daily

sql-server
Updated December 12, 2018 02:06 AM

SQL Server Allways On Availability Groups - HA & DR

sql-server
Updated December 12, 2018 01:06 AM

Can I control which algorithm SQL Server uses to hash symmetric key passphrases

sql-server encryption sql-server-2017 symmetric-key
Updated December 12, 2018 00:06 AM

How do I delete rows from a table on a linked server

sql-server t-sql linked-server
Updated December 11, 2018 23:06 PM

is this time to remove the databases from the availability group? which ones?

sql-server-2016 availability-groups transaction-log transactional-replication high-availability
Updated December 11, 2018 22:06 PM

database_xml_deadlock_report or xml_deadlock_report

sql-server sql-server-2016 extended-events
Updated December 11, 2018 22:06 PM

How do I merge two different queries in sql?

sql-server
Updated December 11, 2018 21:06 PM

How to aggregate the number of indexes on a table and columns per index

sql-server sql-server-2016
Updated December 11, 2018 20:06 PM

Whats the therm in Oracle, when I'm speaking about SCHEMAS on SQL Server

sql-server-2008-r2 oracle-11g-r2
Updated December 11, 2018 20:06 PM

What does "_localserver_view" mean after an MSDB Database table

sql-server stored-procedures msdb
Updated December 11, 2018 19:06 PM

Unable to Watch Live Data on Extended Events Session

sql-server sql-server-2014 extended-events
Updated December 11, 2018 19:06 PM

Investigating Failures of a Subreport in SSRS 2016

sql-server ssrs ssrs-2016
Updated December 11, 2018 18:06 PM

SQL Server 2012 Enforce Password Policy

sql-server sql-server-2012
Updated December 11, 2018 16:06 PM

CPU and Hard Drive Spike for 20-30 Minutes

sql-server sql-server-2008 performance monitoring
Updated December 11, 2018 16:06 PM

Correct way to group by month and year?

sql-server sql-server-2012 query-performance
Updated December 11, 2018 15:06 PM

SQL Server 2012 setup fails immediately (Error result: -2067529723)

sql-server-2012 installation
Updated December 11, 2018 14:06 PM

Read Excel Files wich are matching to the given template Through SSIS

sql-server ssis integration
Updated December 11, 2018 14:06 PM

Stored Procedure infinite looping after index updates

sql-server-2008-r2 index trigger
Updated December 11, 2018 14:06 PM

How can I stop a long running query in SQL Azure Database

sql-server azure-sql-database
Updated December 11, 2018 13:06 PM

Unique filtered index and surprising estimation

sql-server execution-plan
Updated December 11, 2018 11:06 AM

Get Headers from SQL Table

sql-server-2012 table export bcp
Updated December 11, 2018 11:06 AM

sql server 2008 related issues & queries in DbaXchanger