I wonder if some of the site problems are due to the influx of soccer (OK, OK, futball... OK, OK, football) spam?

Yesterday I had the "site-in-the-site" thing (yes, IE9)...

Gotta love...

So, according to the customer, the application usage is right on-line with their historical rates, so it's not had a lot of churn, comparitively. The full backups have been...

Koen - You mean 'DBCC TimeWarp(SlowTime)' doesn't speed up response by slowing time for the end-user? Drat...:-D

I don't think Prod has slowed down, as none of the...

Come now, there is at...

Ed Wagner (6/13/2014)

---

Jack Corbett (6/13/2014)

---

GilaMonster (6/13/2014)

---

Thought process of last 10 minutes.

- Tune a proc quick, then go home

- Wait, it's got user defined functions

- Wait,...

Awful quiet in here over the last couple days...

Should we turn out the lights on this thread?

:hehe:

The log file is going to be as big as it needs to be. Lots of small transactions, a couple long-running transactions could keep it at the size you're...

dax.latchford (6/10/2014)

---

Also as mentioned my colleague has created a domain account with the rights to backup to a UNC location. Is it safe for me to do the following to...

OK, if you folks don't knock it off with the divide by 0 discussion, I'm going to execute DBCC TIMEWARP (GETDATE()/0)!!!

Then we'll see what happens when you divide by 0!

:hehe:

I run into something...

You know, I'd not really thought about this until now, but...

How do people find all these "undocumented" options for various SQL commands?

dbcc autopilot???

create index... WITH STATISTICS_ONLY = ???

What do these...

It's not entirely true that an online index rebuild takes *no* locks. It takes (generally) very short locks at the beginning and the end of the process.

Here's an article...

Shredder

Ninja