Index Operations Showdown: Drop & Create vs. Create With Drop_Existing vs. Rebuild
Every now and then you may have had to move nonclustered indexes between filegroups. There are two ways it can...
2010-09-29
5,135 reads
The Lone Ranger And Data Integrity
Many IT Pros can relate to the the Lone Ranger. With the aid of but one trusty side kick, the...
2010-09-29
2,225 reads
A Small Selection of SQL Azure System Queries
I had a question come up during my “Getting Started with SQL Azure” presentation at SQLSaturday #52 in Denver last...
2010-09-29
1,615 reads
Grabbing SWAG
It’s getting close to the time for the SQLServerCentral party events this fall, and time to start gathering up SWAG...
2010-09-29
1,825 reads
Don’t Take me (too) Literally
Years ago I was part of a heated discussion about the ability/inclination of a team I was on to build...
2010-09-29
1,543 reads
Common SQL Server Mistakes – Indexing Every Column
If one index helps speed up queries, than more indexes should help more, right? They do, but they also come...
2010-09-29
4,796 reads
Performance Tuning Analysis Services (SSAS) Webinar Today
Thanks for coming to today's webinar. We had a great turnout and hope to see you again soon. I have...
2010-09-28
453 reads
Windows Power Plans and CPU Performance
Back in February, 2010, I did some preliminary testing on the effects of various BIOS settings and Windows Power Plans...
2010-09-28
2,377 reads
Find the largest tables in a database
From time to time, I need to find the largest tables in terms of rows / used space / total space etc....
2010-09-28
33,435 reads
Open-Source Databases are Not Free, MySQL has a High Cost, According to MySQL.com Itself
After having a few heated discussions on Facebook in reference to Open-Source Relational Databases, I would like to refer those...
2010-09-28
1,206 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
My PASS Summit West 2026
Comments posted to this topic are about the item My PASS Summit West 2026
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers