Couple things I've done.

1. Back up locally. SQL Server does not tolerate network delays and it's not worth having a backup fail.

2. Do not use the same set of disks...

I almost shudder to post this, but you all might like this:

http://lmgtfy.com/

as a sample, let me Google clustered index for you: http://lmgtfy.com/?q=clustered+index

#1 - You restore Sun full, Thur Diff (00:00 Thur) and logs from 00:00 Thur to failure.

#2 - You restore Sun full, Wed diff, all logs you have after that.

What do you know. I'm surprised it was there back then. Wonder if it was in 60

I think you'll need NT 4 for this. It installed in W2K, but there were warnings, might be issues.

Where's the reference for it? I don't think it existed.

PK != clustered, and they don't have anything to do with each other. It's like saying a tall, red building. Tall and red don't necessarily relate in any way.

PK -...

You cannot give users access in SQL Server and force them to only use your application. That's not how SQL Server works.

So if you want to limit them to just...

sp_who2 didn't exist in SQL 6.5

😉

It was sp_who. When they went to 7 or 2000, they kept sp_who and added sp_who2

I think the only way to do this is David's suggestion, which is essentially a data warehouse. Move the data over periodically, every hour or so, and build reports off...

Some people get significant savings, some don't. You'd have to test. There are some scripts here you could use to test (http://blogs.msdn.com/sqlserverstorageengine/archive/2007/11/13/estimating-the-space-savings-with-data-compression.aspx), and you could use Developer edition to...

They talk to your manager. He/she should know something about you and be...

I know we've had some article issues, and probably always will. However in an article there typically is at least one other set of eyes to try and correct issues,...

MIN/OAK on top, Moneyball!!!

Actually it's quiet here in CO with the NFL draft, Nuggets and Avs in the playoffs. Haven't been to a game yet, but I think there's a...

It's easy to get money, but it does go quickly. And I've often seen it go to bills or regular expenses. That's OK, but it doesn't bring a lasting memory....

The Thread a joke??!?! Heck, I get all my moderator news from this place when I get past the bad jokes and movie discussions.