RBarryYoung (5/7/2009)

---

As for how he keeps his job, there are two obvious possibilities: 1) Civil Service, and 2) Nepotism. These two work pretty much the same, to one degree or...

Long winded and...

Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

On SQL 2005, take a look at the...

Busy database? If you get a lot of transactions/sec, that's easily doable. I've had one that generated 500MB in half an hour, and that was a datawarehouse-type DB. If that's...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic712281-148-1.aspx

I wouldn't say never. There are times when it's needed, when you do really need distinct data...

No one's suggesting that you enter IP addresses manually. The Table variable that Lynn and Flo had in there code was a substitite for the real table. To implement their...

Dean Jones (5/7/2009)

---

I was just wondering where SQL 2005 could help here in terms of improvements and new features, I do notice that a lot of my stored procedures, pull...

Grant Fritchey (5/7/2009)

---

Whoa! I didn't notice that guy had 1200 posts. What the heck is up with that? You take that much time and you still don't get silly fundamentals?...

Yup. Undocumented command.

SELECT * FROM fn_dblog(null, null)

The two parameters are starting and ending LSNs. Good luck deciphering it. Tran log's not exactly 'readable'

For SQL...

Either there's a job that has a command in it to change the recovery model, or someone ran a command to do it directly. SQL won't automatically change recovery models.

There...

No formal process.

If I'm considering the indexes from missing indexes DMV, first I'll make sure there are no partial redundancies within the index recommendations. I'll also make sure that there...

Dunno if you noticed, but I asked the question almost a year and a half ago.

What I ended up doing was querying the tran log before each backup, looking for...

CheckDB uses a database snapshot anyway. Running it against a snapshot is not going to make any difference. It doesn't take any locks as it works (and never has), and...

http://www.sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-Consistency-Checking-Options-for-a-VLDB.aspx

How often are you running CheckDB at the moment?