Implicit Conversions warning
After adding an index, ensuring that an index is actually used is probably the biggest win you will get in...
2011-10-17
1,203 reads
After adding an index, ensuring that an index is actually used is probably the biggest win you will get in...
2011-10-17
1,203 reads
With the release of Denali CTP3 came an extension of the over clause to allow for a sliding window of...
2011-09-22
2,301 reads
In case you didn't know SQLBits 9 ,”Query across the Mersey”, is taking place in Liverpool from September 21st to...
2011-08-31
1,555 reads
Over the past few weeks, I’ve been training developers in what they really need to know about SQL Server to...
2011-08-01
1,331 reads
In Denali CTP3, we have a new of new functions to play with. For this post, im going to focus...
2011-07-19
790 reads
In the second part of his optimization series, Dave Ballantyne shows us how to add conditional logic to set based, more efficient T-SQL code.
2011-06-28
5,250 reads
Learn how you can remove a cursor and optimize a routine that loops through a series of data and performs various calculations in this short article from Dave Ballantyne.
2011-06-27
7,765 reads
In my last blog I showed how persisted data may not be used if you have used the base data...
2011-06-20
530 reads
Not that you would know it from the page below, but Itzik Ben-Gan is back in London to do a...
2011-06-17
1,276 reads
Working at a client site, that in itself is good to say, I ran into a set of circumstances that...
2011-06-13
621 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers