Jeffrey Williams-493691 (3/21/2011)

---

Are you running Standard or Enterprise Edition?

Do you have lock pages in memory right set for the service account?

Do you have perform volume maintenance right set for the...

Yes, we do. I forgot to mention that.

Thanks for the quick responses, folks.....

@getoffmyfoot - I thought our recovery time was going to be around 12 hours, since that's about how long this thing had been...

SPOT ON!!!!

So nice there is...

wiseguy (8/13/2010)

---

It may not matter, but keep in mind in the current SQL architecture you only get 1000 partitions per object.

You mention you've got 100 clients. How good is...

456789psw (8/11/2010)

---

Peter,

Maybe a better way to handle this would be to normalize the design a little further?

If you think this could be a hot spot then maybe BCNF if...

Sounds similar to the sliding window scenario Microsoft draws up:

http://msdn.microsoft.com/en-us/library/aa964122%28SQL.90%29.aspx

Take a peek. This might be helpful...

AndrewSQLDBA (6/25/2010)

---

Sounds like you spend a very large part of your job "putting out fires" instead of making sure that a fire cannot be started. What a waste of time...

Because that would be the easy thing to do......

Seriously, there are 2 things at play here....

Never mind, I was able to figure this out, after looking at as many possible examples I could:

SELECT *

FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0',

'Text;Database=C:\;HDR=NO;','SELECT * FROM [test.csv]')

I wasn't able to locate it yet,...

Thanks, Wayne. That's sound advice. You're right, there is always more than one way to get a job done, especially in the DBA world. Maybe I can...

PaulB-TheOneAndOnly (6/1/2010)

---

If possible I would go with a three tier development model: Dev, Test, Prod.

Let developers play in Dev but only DBA has the power to promote code and apply...

Ah, upper management....we're in the process of a reorganization. The person I and my co-workers report to is not someone who is technical, nor someone who I think really...

I did this at my last job. Since I'm no longer there, I don't have complete details, but here are some general steps. And I'm a SQL Server...

Pam Brisjar (10/10/2007)

---

There's a prior thread here somewhere about running in compatibility mode. In a nutshell, there are some issues with it.

Run the Upgrade Advisor against the database and...