Tags » T-SQL

SQL Server - 2016 - T-SQL Enhancement “Drop if Exists” clause

I was reading through some of the enhancements introduced with SQL Server 2016 and I stumbled upon an interesting addition. The T-SQL construct introduced has been something very common and on the pending request for years I suppose. 306 more words

SQL Authority

For one good, naughty little girl found a diamond...Object Explorer Details

It’s Christmas time again and time to listen to my FAVORITE Christmas song called Joel The Lump of Coal.
Just before Thanksgiving we had our SQLSaturday\Big Mountain Data event and I spoke! 140 more words

Awesome T-SQL

SQL SERVER - Practical Tips to Reduce SQL Server Database Table Size - Experts Opinion

I am one of those fortunate people who has friends everywhere in the world. Syrovatchenko Sergey (LinkedIn) is one of my good friends who is an expert on SQL Server and works at… 2,239 more words

SQL Authority

Interview Question of the Week #047 - Logic To Find Weekdays Between Two Dates

I often enjoy seeing interview questions where the contestant has to write SQL Scripts. Here is another such example.

Question: How to find weekdays between two dates? 76 more words

SQL Authority

How to find index usage from cached plan in SQL Server

Today, I would like to share a script to identify the usage of index from cached plan in SQL Server. This would help us to identify the places (procs/functions etc) where the index is being used. 233 more words


SQL SERVER 2016 - Comparing Execution Plans

New tools bring new capabilities and sometimes these are ingrained deep into the product that we can easily miss them out. And SQL Server 2016 is no different. 387 more words

SQL Authority