2010 PASS Summit Interviews
It’s entirely fair to say that the highlight of my professional year is the PASS Summit in Seattle, and the...
2010-12-30
1,791 reads
It’s entirely fair to say that the highlight of my professional year is the PASS Summit in Seattle, and the...
2010-12-30
1,791 reads
She can dig it!
D Sharon PruittWe’re up to the seventh post on the in the plan cache series. This time...
2010-12-30
1,965 reads
I’m writing this the day before Xmas, trying to finish up a bunch of odd tasks before the holiday weekend...
2010-12-30
1,444 reads
I had heard that you could have too many VLFs in your transaction log, and it could cause performance issues....
2010-12-30
1,930 reads
You can go over my goals here. I’ve really hesitated to do this post because, in my opinion, I did...
2010-12-30
1,424 reads
You can go over my goals here. I’ve really hesitated to do this post because, in my opinion, I did so poorly. Here’s what I did: Community ...
2010-12-30
1 reads
I published a post yesterday where I listed my top 5 bloggers from the worldwide SQL community for 2010. The...
2010-12-30
1,915 reads
I was just refactoring a server-side control and ran into some horrible code. Basicaly there was a big listbox that...
2010-12-30
3,099 reads
As some of you may have already heard, I spent much of December moving from Hawaii to Missouri. Generally, when...
2010-12-29
1,554 reads
Bury My Heart at Conference Room B: The Unbeatable Impact of Truly Committed Managers by Stan Slap ($15 @ Amazon) is...
2010-12-29
725 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