How to filter non-existing records in SQL
Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might s …
Make SQL Server monitoring part of your deployment process for 2020
The post Make SQL Server monitoring part of your deployment process for 2020 appeared first on SQLServerCentral.
How to Use GOTO command in SQL Server? – Interview Question of the Week #249
Question: How to Use GOTO command in SQL Server?Answer: While I am not a great fan of this command let us see a simple example of how GOTO works in SQL Server. Basically, this statement changes the flow of the execution. While running the SQL code wher …
SQL SERVER – Stored Procedure and RETURN Keyword
Earlier today while working on Comprehensive Database Performance Health Check, we landed up a very interesting situation where we had to debug a stored procedure. The stored procedure was very long and we had to debug that one step at a time. Let us l …
My Annual Black Friday Sale is On Now! Save 50-82%.
The time is finally here, the moment you’ve been waiting for all year: your chance to save 50-82% on my training classes and online services. Everything on the site is 50% off during November, but you can save even more with these 3 bundles: Leve …
Some Thoughts About the Intel Core i9-9900KS Processor
IntroductionIntel has released the Intel Core i9-9900KS Special Edition mainstream desktop processor that was originally announced back on May 26, 2019 at the Computex trade show. This was the same day that AMD revealed the details about the 7nm AMD Ry …
13th Anniversary of SQL Authority – 4918th Blog Post
Today is Anniversary of SQLAuthority and it completes 13 years and this is a 4918th blog post. That means on average every year I have published around 378.3 blog posts a year. Let us read the blog about 13th anniversary.13 years ag …
What you need to consider for your monitoring strategy in 2020
The post What you need to consider for your monitoring strategy in 2020 appeared first on SQLServerCentral.
Create a New SQL Server Maintenance Plan with the Maintenance Plan Designer
The post Create a New SQL Server Maintenance Plan with the Maintenance Plan Designer appeared first on SQLServerCentral.
My annual Black Friday sale starts tomorrow. Here’s what you wanna know.
The time is almost here – the moment you’ve been waiting for all year. I’ve sharpened my pencils to take the prices as low as I can possibly take ’em: Level 1: Fundamentals$295Recorded Class Season PassSQL ConstantCare®The C …
SQL SERVER – Creating a Nonclustered Columnstore Index on Temp Table
Recently I was delivering training on SQL Server Performance Tuning and during the session, I received a very simple question about the nonclustered columnstore index on a temp table.The question was is it possible to create columnstore index on a temp …
Accelerating Database Recovery with SQL Server 2019
The post Accelerating Database Recovery with SQL Server 2019 appeared first on SQLServerCentral.
Using OFFSET for Paging
Paging is a common query that developers will use when retrieving results from a table. Often an application may want to display 10 or 20 results, knowing there might be 100 or more. The first request could be using just the top 10, with subsequent req …
SQL Productivity with SQL Prompt
The post SQL Productivity with SQL Prompt appeared first on SQLServerCentral.
Updated sys.dm_os_waiting_tasks script to correctly parse nodeId
I realized that I’d fixed an issue with my sys.dm_os_waiting_tasks script to correctly parse out the parallelism nodeId from the resource_description column (as newer versions include more info after the nodeId=X info) but I never blogged th …