SQL Server 2005's Management Studio offers lots of new functionality, but you can't always use a GUI. Sometimes you need to run a script from the command line, especially for an upgrade or install ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database. In part one of this article, I described a ...

I've been working with SQL Server for over 20 years now, Generally, I limit my tools to the things I might expect to find in a given client environment. My toolbox typically includes the tools that ...

This has been one of the worst companies I’ve had to deal with. Their customer service is extremely poor, and representatives often seem unsure of what they’re doing. I was required to switch to this ...

Here is a script that looks at the created index and the missing index details, making a overview of usage stats, columns, index type etc. use Index_analysis.sql for the analasys This script can use ...

This document provides a comprehensive guide to the scripts housed within the scripts directory of the Data Warehouse Analytics project. These scripts form the backbone of the project's data ...