One of the biggest downsides of using SQL Server Management Studio as an interactive query tool is the limit on text/grid output. SSMS 18.2 fixes that!
Category: SQL Server
In this tip, you'll see the metadata queries that will make it possible to discover which integer-based columns could be made smaller (without any loss of data).
Aaron Bertrand explains four conventions he always follows when writing T-SQL queries.
See how you can use new functions like DATEFROMPARTS to simplify otherwise really cryptic methods to obtain key dates (like the first day of the current month).
Get a first-hand look at some of the ways NOLOCK can produce incorrect data.
Learning Pathways are a new, innovative way to take advantage of the sessions offered at PASS Summit.
Aaron Bertrand shares his slides and demos from his presentations at SQLDay in Wrocław, Poland.
Aaron Bertrand talks about a few of the things that he wished he had learned earlier on.
This tip shows how powerful the CASE expression is, and some of the nuances in its behavior.
Aaron Bertrand shares his slide decks and demos from two recent presentations at CodeStock in Knoxville, TN.
See one approach to collecting extended properties information across all of the databases on a server.
Break free from the limitations of history retention and take control at the job or even step level.
See what improvements were made in SentryOne Plan Explorer 19.0.2.
In part 2 of this series, we add another way to further isolate multiple threads of a bulk import process.
In the first of a 2-part series, see how you can easily reduce contention between multiple bulk import threads.
This tip shows a neat trick with CROSS APPLY that lets older versions of SQL Server ignore columns in your metadata queries that don't exist yet.
If you use scalar user-defined functions, and can't take advantage of new handling in SQL Server 2019, see some other ways to reduce the impact on performance.
Microsoft has released Cumulative Update #8 for SQL Server 2012 Service Pack 2. KB Article: KB #3082561 24 fixes total (23 fixes listed publicly at time of publication) Build number is 11.0.5634 Relevant for...
Microsoft has released Cumulative Update #9 for SQL Server 2014. See this blog post for more information. KB Article: KB #3075949 30 fixes listed publicly at time of publication (31 total) Build number is...
Microsoft has released Cumulative Update #2 for SQL Server 2014 Service Pack 1. See this blog post for more information. KB Article: KB #3075950 46 fixes listed publicly at time of publication (51 total)...
Microsoft has released Cumulative Update #7 for SQL Server 2012 Service Pack 2. This update has 38 fixes, including the QFE security fix from MS15-058. If you've installed MS15-058 (either the QFE – 11.0.5613...