Creating the clustered index might take way too long and use a lot of space (you'll need at the very least the size of your table in extra free space),...

GSquared (10/20/2010)

---

Why?

Maybe I'm the exception, but I don't spend a significant portion of my time running restore scripts on a day-to-day basis, hence I haven't bothered to even begin to...

paul.knibbs (10/20/2010)

---

Steve Jones - SSC Editor (10/19/2010)

---

I think there's a little elitist mentality, but someone ought to know how to do this in scripting. It's much more efficient, especially when...

17 Bytes is not that bad as long as you don't have many other indexes.

If most of the queries return the same columns you can also give a shot at...

I didn't read it online, it's something we've noticed here while testing sas disk (so i don't have a link).

Later it came up in a High perf IO subsystem presentation...

No need to cast so many things, just do it like this:

Select CAST('2010-01-08' + ' ' + '03:25:25' as DATETIME)

Usualy a DBA does not work in "Project" mode, so once they start somewhere they usualy work there for some time (years).

So in the end finding a SQL DBA is...

Easy way:

start all your scripts with the word "return" (will save you from time to time)

never open Prod and non-prod server in the same SSMS

Good way:

as said above,use 1 prod...

To find out if a DB is not used anymore set it offline and wait for someone to complain 🙂

If noone complains, then you have one less DB to worry...

Actually most sas disk will have the same throughput for IO size of 8K and above, so you really just need to test for 8K.

Yes,

TDE is not meant to secure data from regular select, it's meant to secure data at rest (files and backup) to avoid someone stealing your backups or active datafiles.

15K rpm sas disk can reach 150-180 8k random IO/s per spindle in full stroke and about 90 - 125 MB/s for sequential access.

So if you have 14 disks you...

I work in a company with 100's of sql server and no comercial application solves all the problem, we always end up making our own procedures (repository, monitoring, alerting).

Even the...

Check how large your differential backups would be.

Send them a full backup once and and then differential backup every day or so (probably more data sent overall but in smaller...

In sys.all_objects there is a field is_ms_shipped.

The management studio (2005 and 2008) put all the procedures (and extended procedures) in the system folder if this field is set to 1.

The...