I have frequently seen Commvault to be the source of backups as you describe them.

You might want to check with the sysadmins to see if anybody has a tool such...

Steve Jones - SSC Editor (3/5/2014)

---

There isn't necessarily a list of daily/monthly/weekly tasks for all environments. The list you have is a fine place to keep track of your systems....

+1

dwain.c (3/4/2014)

---

Pardon my aging eyes. The link is there...

dwain.c (3/4/2014)

---

Great article Jason! An enjoyable and informative read.

One question. In the section where you're describing left-deep/right-deep, is it safe to assume you're saying that the context only...

Grant Fritchey (3/4/2014)

---

You need to check all the hardware and configurations. If you've never done that, I strongly recommend getting an expert in the door. Hardware configs, especially I/O, can...

cure

Lowell (3/4/2014)

---

in a similar post a couple of years ago, i did a TSQL example that looked at the first x bytes and compared them to known values to find...

Keith Tate (3/4/2014)

---

You might also want to account for getting the execution plan from cache too. You can use this to clear the proc cache dbcc freeproccache.

It is...

Is it a file stored by a client or is he perchance looking at ssis or ssrs binary stored in the database?

Cost can help you determine if the query has been tuned.

In addition, you could use statistics time and statistics IO.

Examining the execution plan can really help to determine if the...

That query would work well.

I have seldom seen this kind of requirement. When I have, it is something we throw in the presentation layer. A common place for...

Here is a possible option

USE tempdb;

GO

DECLARE @reccount INT = 0

CREATE TABLE #sometab (someid INT IDENTITY(1,1),someval VARCHAR(500),Category VARCHAR(20))

INSERT INTO #sometab (someval,Category)

VALUES (

...

Well, since you asked...:-D

Thanks Troy. Much appreciated.