Put the query in a new query window in SQL Server Management Studio. Looking at the AdventureWords2012 database (available for download from CodePlex), review the uspGetEmployeeManagers stored ...

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 ...

However, with the introduction of the query store, you could upgrade your SQL Server to a newer version and capture query performance while running under the old CE and an older compatibility level.

When your SQL query is ready, you can run the query immediately or you can add a title, change its options, limit its output, and so on, to make the report look better. See Viewing the SQL Code, ...

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 ...

As I discussed in an earlier column, SQL Server keeps a plan cached for each query it sees (assuming the query requires planning in the first place, of course). That's great for speeding up processing ...

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 ...

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.