Viewing 15 posts - 23,356 through 23,370 (of 39,917 total)
Perhaps not a great attitude, but that's not how I read it. Seems more like a cultural "terseness" that I see from many newbies in non-English speaking cultures.
July 1, 2009 at 8:36 pm
The DAC times out?
On a local connection, that is surprising. I think you might want to reboot the server, and if this happens again, perhaps hold a DAC connection permanently...
July 1, 2009 at 8:29 pm
Is the issue just maintainability? Are you worried that customers will alter the script and then call for support? A surcharge for support might solve that.
The other thing you could...
July 1, 2009 at 8:28 pm
I'd tend to agree with Gus. I think lots of DBAs don't know .NET very well.
Blandry, I think you're in a place where you are looking for more well rounded...
July 1, 2009 at 8:14 am
Dave, I would tend to agree with you that it should be zero. Sorry, out and about with no instance to test on right now.
July 1, 2009 at 7:23 am
It shouldn't need to reconnect to get performance up. We'd need more information, but I'd suspect a leak in your utility somewhere, not SQL Server.
July 1, 2009 at 7:21 am
Is it possible your client tools are at a different rev from the server? Meaning are they both SP2, SP3, etc.?
July 1, 2009 at 7:20 am
We tend to only for service packs, which means we reboot about once or twice a year for this site. Rarely unless there are isses, and it seems in IT,...
July 1, 2009 at 7:19 am
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
Viewing 15 posts - 23,356 through 23,370 (of 39,917 total)