The 10 Basic Concepts of T-SQL
For the end of the latest Basic Querying and Programming in SQL Server course, I prepared a list of the...
2017-08-29
1,352 reads
For the end of the latest Basic Querying and Programming in SQL Server course, I prepared a list of the...
2017-08-29
1,352 reads
In this video, I show how to enable live query statistics in SQL Server 2016 in order to see execution...
2017-05-15 (first published: 2017-05-03)
1,256 reads
Last week I presented my session, SQL Server 2016 for Performance Tuning Lovers at the GroupBy conference. That was tons of...
2017-05-02
2,109 reads
Are you a software developer?
Did you ever get to develop a software that works with a Microsoft SQL Server database?
...
2017-03-13
798 reads
One of the most common mistakes people make when writing T-SQL is using a function in the where clause, and...
2017-01-23
2,219 reads
Last Thursday, I delivered my seminar, Performance-Oriented SQL Server Development at the Expert Days conference in Israel.
It was a great experience,...
2016-12-30
907 reads
On October 10, I will come back to present in one of my favorite SQL Server conferences – SQL Server Days...
2016-09-29
599 reads
A month ago, my wife and I were in Barcelona for a short vacation.
In one of the days, we entered...
2016-06-29
642 reads
I’m excited to say that I will be delivering a session in this year’s PASS Summit in Seattle later this...
2016-06-24
421 reads
One of my most favorite technologies is Columnstore. Thankfully, the guys at Microsoft seem to agree with me, because they...
2016-05-10 (first published: 2016-04-27)
5,861 reads
In today’s Software Development Life Cycle (SDLC), having a robust build pipeline is very...
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
By Kevin3NF
Things your cloud vendor may not tell you Here’s a common theme I...
I will have to test this next week, but will not have a chance...
I want to add a condition in the joining columns part of the merge...
Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow...
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers