One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or ...

Given a fairly simple table which holds only 2 columns I care about.Taco_Sales (Taco_Type varchar(20), Taco_Date datetime)I want to find the min and max Taco_date for a given taco type. Both Taco ...

The only way to get extended support for 2008 versions of Windows and SQL Server is in the cloud. Here's why you should be thinking about 2012 migrations now as well.

SQL Advisor Query SQL Server with PowerShell Get the right information on your SQL Servers via the Get-Service cmdlet. By Joshua Jones 03/10/2011 Last time, I discussed how to get PowerShell and SQLPS ...

Hello,I need to compute a running total in a sql query for a report. Presently, I calculate my running total by means of a cursor. As my data being reported on is ever expanding and my cursor ...

Denny's SQL Secrets Troubleshoot Slow-Running Queries In SQL Server Denny breaks down how to identify and fix speed issues in multiple versions of SQL Server. By Denny Cherry 12/11/2013 ...

Now, what about actually executing some T-SQL? Most DBAs are already familiar with SQLCMD, introduced with SQL Server 2005 to replace the old OSQL command-line query interface.