Physical File Defragmentation
A guest editorial by Brad McGehee talks about physical fragmentation and asks if you are concerned about it on your servers.
2009-05-01
544 reads
A guest editorial by Brad McGehee talks about physical fragmentation and asks if you are concerned about it on your servers.
2009-05-01
544 reads
This is the introductory module for the SSC Online Video Training course, Becoming a Profiler Master. In it, MVP Brad McGeHee will discuss some of the critical factors that might persuade you of the need to master this powerful SQL Server profiling tool.
2009-04-30
13,028 reads
SQLTeach (a part of the larger DevTeach event) will be held in Vancouver, BC this June 8-12, 2009. It will...
2009-04-30
1,380 reads
If you are a current, or aspiring Microsoft MVP, you can keep up with what other MVPs are doing by...
2009-04-30
1,431 reads
The 2009 European PASS Conference, which was held April 22-24, 2009, had 254 attendees from 22 different countries. In spite...
2009-04-28
1,623 reads
In theory, the SQL Server Maintenance Plan Wizard is supposed to make it easier for non-DBAs or novice DBAs to create database maintenance plans that help to optimize the performance of their SQL Server databases. The problem is ...
2009-04-27
8,030 reads
In this 6-module course, Brad McGehee provides an in-depth, step-by-step guide to mastering the basics of SQL Server Profiler, a powerful performance monitoring and analysis tool.
2009-04-21
7,212 reads
Just today, I was reviewing the indexing of a database used by a third-party application. As part of my review, I ran a script against it that is used to identify duplicate indexes. The script I used was written Paul Nielsen, the author of the SQL Server...
2009-04-20
3,400 reads
In theory, the SQL Server Maintenance Plan Wizard is supposed to make it easier for non-DBAs or novice DBAs to...
2009-04-16
5,580 reads
Just today, I was reviewing the indexing of a database used by a third-party application. As part of my review,...
2009-04-15
2,424 reads
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
hi, in an ssis for each loop over an object variable called MyListVariable, i...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers