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
532 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
532 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
12,887 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,375 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,425 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,621 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
6,866 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,569 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,419 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Dipping my toes into the waters of Azure and of course before I get...
Comments posted to this topic are about the item Announcing SQL Server 2025
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers