Tags » SQL Server

Is This Database Being Used?

— By Ginger Keys

During the migration of a client’s SQL environment to a new hosting provider it was questioned whether all of the databases needed to be migrated. 1,092 more words

SQL Server

SQL Profiler vs XEvents: Quick Start


As mainstream support for SQL Server 2012 comes to an end this summer (2017), somewhere between 60% and 80% of us are still on SQL Server 2008 R2.  598 more words

Extended Events

MSSQLSERVER Service Failed To Start, TDSSNIClient initialization failed with error 0x34, SQL Server could not spawn FRunCM thread

A recent client had this error on their MS SQL Server out of the blue. After much investigation and trial/error to correct. The following solution saved the day: 69 more words

SQL Server

How to import your Azure db to local Sql Server

In order to take a copy of an Azure database and to deploy it on the local workstation, I did the following: 135 more words


All Databases without geo-replica on Azure Server

Query to find all Azure database without geo-replica configured.


select d.* from sys.geo_replication_links r
right join sys.databases  d on d.database_id = r.database_id
where r.database_id is NULL 


WHERE Clauses Without Column References

Generally speaking, most T-SQL queries contain WHERE clauses to filter out data and WHERE clauses almost always contain a reference to a column…after all, that’s why the WHERE clause exists (to filter out the data).  879 more words

T-SQL Coding

Filtered Index can't use like or functions in the where

Today I needed to create a filtered index to help a large update go faster. I wanted to use a like statement, but found out I could not use like in the where clause. 164 more words

SQL Server