By Omri Bahat, 08/22/2007
By gathering information from sysprocesses and running KickUserOut.sql, you can terminate processes that are impeding a server's performance.
By Readers, 08/22/2007
If you often need to display the current date in different formats, you know that it can take a lot of code and effort. The FormatDate function changes that. By providing just two ...
By Itzik Ben-Gan, 08/22/2007
Get the solution to August's puzzle "Prisoners and Switches," and prepare your mind for September's puzzle, which involves the numbers of hairs on Chinese heads.
By Douglas McDowell, 08/22/2007
Your SAN engineer might not know the finer points of BI database storage. To stave off trouble, you need to be involved in the SAN configuration process.
By Jeff James, 08/22/2007
Enhancements in SQL Server 2008 will make every action auditable and provide transparent data encryption.
By Kevin Kline, 08/22/2007
Microsoft makes available a variety of scripts that its own Database Operations team uses for automating maintenance jobs—and they're free.
By Andrew Sisson, 08/22/2007
Do you want to move to SQL Server from Oracle, but aren't sure how difficult the data conversion and migration will be? Find out how SSMA for Oracle can help you more easily move ...
By Michael Otey, 08/22/2007
Here's a preview of SQL Server 2008 features that just might add a smile to your face: enhanced Microsoft Office integration, the ability to hot-add CPUs, and more goodies DBAs ...
By Anne Grubb, 08/22/2007
Rodney Landrum reaches out to readers who needed help following the steps in his article.
By Blake Eno, 08/22/2007
Check out new and improved SQL Server–related products.
By Kalen Delaney, 08/22/2007
By using both TEMPLATE plan guides, which enable autoparameterization, and SQL plan guides, which let you specify many query-processing hints, you can optimize query performance.
By Michael Otey, 08/22/2007
Language-Integrated Query (LINQ) is the long-awaited wave of the future, and its benefits definitely outweigh its drawbacks.
By Jeff James, 08/22/2007
An emerging selection of software- and appliance-based products augment SQL Server 2005’s basic auditing capabilities, to help you keep data secure and in compliance with ...
By Readers, 08/22/2007
The procedure cspBackupListing can list your databases’ most current backups, back up databases with previous backups older than 24 hours, or list all the backups for a database.
By John Green, 08/22/2007
Need some help with SQL Server database recovery and log auditing? Our review of ApexSQL Log will help you decide whether this app fits your needs.
By Andrew Kelly, 08/22/2007
This built-in SQL Server 2005 DMV lets you see exactly what type of physical I/O your SQL Server system is experiencing when you're reading from or writing to the files on disk. ...
By Itzik Ben-Gan, 08/22/2007
Last month's discussion was pretty theoretical. Now, we dig deeper by offering concrete examples to clarify the topic of temporary objects.
By Michelle A. Poolet, 06/18/2007
With dimensional modeling, you can build a user-friendly data structure that makes data access intuitive. Start by learning the components of the dimensional model and why they're ...