Tuning Tip: Identifying Overlapping Statistics
Statistics are used by SQL Server's query optimizer to help determine the most efficient execution plan for a query. When...
2010-09-08
2,130 reads
SQL Saturday Glory
Have you taken the time to plan a fall get-away for some free SQL Server training? You can do this...
2010-09-08
776 reads
Schedule the backup job in Express Edition
Schedule the backup job in Express Edition: Everyone knows that, you cannot schedule a job in Express edition, as Express...
2010-09-08
467 reads
MDX - Calculating the Percent of a Named Set
Getting the percent of something in MDX seems like a pretty easy task but can be complicated when extra logic...
2010-09-08
1,142 reads
A week far away...24 HOP!
I just have an email with notice that 24 Hours Of PASS, is a week far away! Once again great...
2010-09-08
655 reads
Common SQL Server Mistakes – GUID as a Clustered PK
I haven’t been thrilled with GUIDs as primary keys, mainly because I think that it’s hard for humans to work...
2010-09-08
1,477 reads
Speaking at SQLSaturday #48 in Columbia, SC
SQLSaturday #48 is October 2nd, 2010, at Midlands Technical College in West Columbia, SC. I’ll be doing two presentations, one...
2010-09-08
289 reads
New Ideas for SQLSaturday
Jack Corbett and I are trying a few new things at SQLSaturday #49 in Orlando this year (Oct 16, 2010)...
2010-09-08
272 reads
Tip: RESTORE FILELISTONLY / WITH MOVE
As we’ve seen in recent DBARant-able tales, not everyone is completely familiar with methods of restoring SQL backup files to...
2010-09-08
1,746 reads
What is Normalization in SQL ?
=> What is normalization ?
Defination :Normalization is the process of efficiently organizing data in a database. There are two goals of...
2010-09-07
303,395 reads
Blogs
Speeding Up Patching – Beyond Patch Delivery
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
Monday Monitor Tips: Query Recommendations
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Forums
Azure SQL Hyperscale Unveiled
Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
MiniMax m3 and SQL Server
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers