Brandie Tarvin (6/4/2013)

---

My Recovery Plan

1) SCREAM really loudly so everyone knows there is a problem.

2) Run out of the building as fast as possible.

3) Update my resume.

4) Job hunt.

5) Repeat...

rodjkidd (6/4/2013)

---

Just got off a conference call, and the subject of DR came up.

The reply?

"well it would be nice, but we've never had any problems so far"...

I'm sure we've all...

Loundy (5/23/2013)

---

unfortunately downgrade isn't possible.

you could install standard next to enterprise and copy the dbs to it before uninstalling to minimize any downtime, but as mentioned, back your dbs up...

david.holley (4/24/2013)

---

Woah! My brain just exploded (a la Mars Attacks!). That'll take some time to digest. It didn't occur to me until just now that most major US holidays observed...

Regional settings on her machine?

To paraphrase ...

Data is big. Really big. You just won't believe how vastly hugely mind-bogglingly big it is.

henrik staun poulsen (3/14/2013)

---

Hi Steve,

We also almost never run CHECKDB.

This is because it takes tooooooo long.

I'm taking something above 50 hours.

When we restore a backup onto our test system, the...

No log backup means

"My data is of no value to the business, it doesn't matter if I lose all changes since the last full backup". If this is...

GilaMonster (2/13/2013)

---

Personally I find LMGTFY to be incredibly condescending, I'd feel quite insulted if someone gave me that kind of reply. I'll do the search for people if I don't...

Why would you ever want to force pages out of cache in order...

As a screening question? If you have someone wanting to work with SQL Server,...

anthony.green (1/30/2013)

---

andrew gothard (1/30/2013)

---

s it's a DEV box, try running this then retrying

DECLARE @DBName NVARCHAR(200);

SET @DBName = '<Enter your db name here>';

DECLARE @spid INT;

DECLARE IHateCursors CURSOR FOR

SELECT

spid

FROM

master.dbo.sysprocesses...

s it's a DEV box, try running this then retrying

DECLARE @DBName NVARCHAR(200);

SET @DBName = '<Enter your db name here>';

DECLARE @spid INT;

DECLARE IHateCursors CURSOR FOR

SELECT

spid

FROM

master.dbo.sysprocesses

WHERE

dbid =...

I know this is not an answer to the question you've actually asked, but if your report is required to be accurate, remove the NOLOCK hints.

They're not a magic 'go...

If you're looking for 'self-service' reporting, have you consifered using SSAS and SSIS for this, rather than building your own solution?

It's a lot more intuitive for most end-users