Thanks - message sent

you are too popular

Sorry you cannot send this private message.

• The...

no problem - glad it helped!

lol - just realized I'm registeed with 2 different email addresses here. Wonder if there is a merge function

I assume we are excluding system databases. I have included " copies" ... So prod, dr, test, dev = 4 databases ( or as in some cases

, 15 because...

Some great "what if'" already listed. A few more:

Olympics 2012 ++ hugely high volume for very short period whith huge impact if there is down-time. I know that the English...

Agree with a lot of what has been said.

As #DB's/DBA increase, the service "offering" the DBA provide decreases. I moved from a team of 7 "DBA's" (4 DBa's, 3 people...

Interesting stuff. we have something similar using SQL agent jobs, and SSRS.

Unless I missed it, the prediciton doesn't seem to have methods for predicting impact of reindexing and check database...

Wouldn't a "SQL OS" add many of those things that Windows Admins do, to the SQL DBA job - like drivers upgrades, etc.

And then there is all the other software...

GilaMonster (8/10/2009)

---

Wanderer (8/10/2009)

---

anyways: 1 useful piece of information I got from a Kalen Delaney course. sp_ is NOT Microsoft's "stored procedures". It actually means special, and works for tables as...

Wesley Brown (8/10/2009)

---

in 7.0 and 2000 if you named a proc sp_ you got a trip to master to try and resolve the name. In 2005 that has changed a...

sharon.bender (2/18/2009)

---

Hi all.

I must admit I haven't read the whole 5 pages of this thread, so apologies if I'm repeating something someone else already said, but I'd be curious to...

Have there been some changes to the package?

Have you tried:

INSERT INTO Filter (CID, FilterId, UserName, Description, AppId, Definition) SELECT ?, FilterId, UserName, Description, AppId, Definition FROM Filter WHERE (CID =...

Robert Hermsen (10/27/2008)

---

a benefit to storing the data is that in lieu of alerting on 80-90 % drive utilization you can alert on % changed. It allows you to...

tjaybelt (10/27/2008)

---

Steve Jones - Editor (10/27/2008)

---

To me these are things that are daily checks, things you need to make sure are available if you get called when you're on-call. Issues...

Guru Nagabhushan (9/22/2008)

---

Table variables are indeed very slow when processing even moderately sized result sets. I have a proc that produces, in one use case, about 2200 rows. This table...