Viewing 15 posts - 23,266 through 23,280 (of 39,819 total)
I think we'll be more database centric, and less instance centric in terms of how we deploy and manage the th databases. Beyond that, I'm not sure.
July 1, 2009 at 7:19 am
Did you use the Configuration Manager to change accounts? You need to so SQL Server assigns the correct privileges and ensures the service can do things like set the SPN.
July 1, 2009 at 7:18 am
John is correct, the clustered index is the data (non-LOB, image, text, etc) and it moves when you rebuild the clustered index. There should be a better tool, but there...
July 1, 2009 at 7:17 am
We don't do it now, but that's how we've done it before. You can also get a router that will limit the bandwidth used, so you can control the flow.
June 30, 2009 at 5:06 pm
By default SQL Server does not allow databases on mapped drives. You can get around this, but it is not recommended. The reason is that network IO can have latencies...
June 30, 2009 at 5:06 pm
As Gail mentioned, each link has a Source that shows where the link is from. We link one or two of our articles each day and then a couple external...
June 30, 2009 at 5:04 pm
I'm not sure I agree they're basic recovery. To me basic recovery is just restoring a database. The "why" gets into when it's a disaster.
Your point is well taken, that...
June 30, 2009 at 7:29 am
Blandry, I miss that. Too many places I've worked in the last decade didn't require code reviews. It seemed once Y2K passed without a big issue, lots of companies just...
June 30, 2009 at 7:05 am
There shouldn't be. I was puzzling over how someone could do this. We should not allow blank emails.
June 30, 2009 at 6:54 am
Sorry, Gail. Rebuilt laptop on the road, no VPN, but I shall look into it.
Perhaps it is a secret admirer? Or Phil has started some new contest to see who...
June 30, 2009 at 6:36 am
I second Gail's recommendations on those books. They're worth reading.
June 30, 2009 at 5:51 am
I've always struggled with this. Red Gate's Dependency Tracker (grown out of a conversation that Andy and I had with Red Gate) really helps if you depend on these things.
I...
June 30, 2009 at 5:50 am
A disaster encompasses many things, not just losing a data center. A disaster can be someone deleting a single table (or even row), coffee spilled on a server, all the...
June 30, 2009 at 5:47 am
I don't know what a snap server does, but I can think of two things. The bad block you've mentioned, and you'd need vendor tools to check this at a...
June 29, 2009 at 7:52 pm
What was it set to before, and why? I'd be wary of altering this unless you know why it is not 0. Or that you make sure that you're not...
June 29, 2009 at 7:41 pm
Viewing 15 posts - 23,266 through 23,280 (of 39,819 total)