COMPUTE is depreciated. You can use ROLLUP or GROUP BY

COMPUTE is depreciated. You can use ROLLUP or GROUP BY

Have you looked into sp_whoisActive .. it is much more powerful...

Have you looked into sp_whoisActive .. it is much more powerful...

Martyn Hughes (10/19/2010)

---

Steve, I've been a great fan of SSC for many years, I've used a number of redgate tools and Litespeed to compress some rather large DBs especially when...

scott mcnitt (3/14/2013)

---

I guess if I am learning about a new database that I have been given to support and am searching like this in a development environment, I can...

Below one is more efficient and gives more info as well ... I have used it many times and its a life saver

Credit goes to -- Luis Chiriff

/*

- Search through...

sqlpanther (2/19/2013)

---

hello All,

I have a little question about DBA job future in near time, as there is a gradual shift fto cloud computing, I get a doubt sometime will cloud...

eyespi20 (2/18/2013)

---

We moved our production databases from an SQL2008R2 Standard Edition to SQL2012 Enterprise edition this past weekend. I have a DBMailUserRole defined in MSDB that has the execute rights...

margo.taylor (2/21/2013)

---

I have been trying to restore a backup to my test server and keep getting the following error. I am using Microsoft SQL Server Management Studio.

Restore failed for...

Kumar-386306 (2/21/2013)

---

Hi Guru,

if any have a power shell script to track the IIS log file size and send a email alert if the log file size exceeds certain limit.

Please...

parminder.parmindersingh (2/6/2013)

---

Hello,

Please any one can help me, how to recover databases or change status from in recovery to normal. i had go through all the articals which is suggested by...

sqlfriends (1/22/2013)

---

It sounds to exclude it from full backup is a good idea, and do a full backup whenever there is a change.

One thing I need to change though, when...

sqlfriends (1/22/2013)

---

Anyone knows a third party SQL sever monitor tool that has functionality that can track database file size growth?

Whoops, the topic should be track database growth, I don't have...

How about using the blackbox trace that is already running ?

This might help you.

http://technet.microsoft.com/en-us/library/cc293615.aspx