(Greg Larsen) There are times when you want to return a set of records that are based on the results of another set of records. When you have this requirement how do you accomplish this with TSQL? One method is to write a correlated subquery. In this article I will be explaining what a correlated su

(Pinal Dave) Writing some typical interview questions have been on my list always. I look for new ways of tricking the person and most importantly, some of the interview questions are designed to make sure the person has strong fundamentals. This blog is one such attempt to understand the basics.

(Derek Dieter) The news is out. The consensus on using hints is “Do not use them”. They will ruin you. But much like the 1950’s people keep their dirty laundry to themselves and outwardly show their best “non hint” selves, this applies as well.

(Kenneth Fisher) The other day Richie Rump (b/t) mentioned something called a clipboard manager on twitter. I’ll admit I had to ask what exactly they meant, but once it was described to me I realized it was something I’d wanted off and on for years.

(Greg Larsen) There are times when you want to return a set of records that are based on the results of another set of records. When you have this requirement how do you accomplish this with TSQL? One method is to write a correlated subquery. In this article I will be explaining what a correlated su

(Pinal Dave) Writing some typical interview questions have been on my list always. I look for new ways of tricking the person and most importantly, some of the interview questions are designed to make sure the person has strong fundamentals. This blog is one such attempt to understand the basics.

(Manoj Pandey) In my [previous post] about Temporal Data I showed how to setup Temporal on an existing table. That was a simple scenario where the tables does not have historical data, and we added the 2 Period columns on that table, and we didn’t face any issues.

(Tim Radney) Beginning with SQL Server 2016 you will have the ability to store portions of a database in the cloud. This new ability is known as Stretch Database and the feature will be beneficial to those needing to keep transactional data for long periods of time and those looking to save money on

(Jeremy Kadlec) My team needs to quickly pinpoint the performance issues in my SQL Server environment. With all of the demands at work, our team needs to find and understand the issues, then review the code and take corrective actions. We need to ensure our production SQL Server environment is runni

(Denzil Ribeiro) A Columnstore index contains row groups that can that have a maximum of 1,048,576 rows. A row group can be closed and compressed due to multiple reasons before that maximum of 1,048,576 rows is reached.