Promised Links from SQL Saturday 119 Presentations
If you attended one of the sessions I promised to post the links we discussed here. I have done my...
2012-05-19
1,126 reads
If you attended one of the sessions I promised to post the links we discussed here. I have done my...
2012-05-19
1,126 reads
Today’s SQL University post will highlight the need to have a methodology to address issues that we as IT professionals...
2011-05-27
719 reads
Office politics during a major event can be dangerous. It pays to be seen as contributing to solving the problem...
2011-05-26
757 reads
It should come as no surprise that the first topic I am covering this week is communication because the first...
2011-05-24
1,427 reads
Welcome to SQL University Troubleshooting Week. For anyone unfamiliar with SQL University, it is a project created by Jorge Segarra...
2011-05-23
693 reads
Welcome to SQL University Troubleshooting Week. For anyone unfamiliar with SQL University, it is a project created by Jorge Segarra...
2011-05-23
867 reads
I recently debuted a new presentation, “What To Do When It All Goes So Wrong”. The presentation is designed to...
2011-04-20
717 reads
A week or so ago Aaron Nelson (Blog|Twitter) put out a call for help on Twitter looking for anyone that...
2011-01-20
13,612 reads
Last week Jonathan Kehayias (Blog|Twitter) used his blog to publicly call out Thomas LaRock (Blog|Twitter). I am not going to...
2011-01-11
655 reads
Do you have a favorite line from a holiday movie? Can you change it around slightly to make it SQL...
2010-12-20
765 reads
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...
By Rohit Garg
Columnstore Indexes in SQL Server – A Practical Guide with Real-World Examples
...
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