Viewing 15 posts - 12,556 through 12,570 (of 22,214 total)
One option to consider, SQL Server Central Management System[/url] from CodePlex. But better still, read through this section in Books Online. It should get you where you need to go.
May 16, 2011 at 8:33 am
First off, if it is a reporting only system that gets a refresh at night or something, make it read only. That will radically improve your performance for the queries.
As...
May 16, 2011 at 8:24 am
Are you using a custom script or is that a 3rd party backup routine?
Another thing that comes up are locked files on the server. These can be caused when a...
May 16, 2011 at 7:31 am
Functions are a notorious TSQL bottleneck. Most of the time they are used incorrectly or written badly and the combination causes poor performance. This is especially true if you're working...
May 16, 2011 at 7:29 am
Another thing you can do is pull the execution plans from the cache on the production systems you're working on. That way you can see what's happening in the production...
May 16, 2011 at 7:11 am
Jim Murphy (5/13/2011)
WayneS (5/13/2011)
My only regret was in not having more time to just sit around with all of them to chat and get to know them better.
I agree. I...
May 14, 2011 at 5:07 am
WayneS (5/13/2011)
Brandie Tarvin (5/13/2011)
Alvin Ramard (5/13/2011)
Had to laugh when Grant mentioned DBCC TimeWarp in a presentation. 😀Oh, you have to share. In what context did he mention it?
Oh, just in...
May 13, 2011 at 7:02 am
That's a lot of questions at once.
My first suggestion, look at setting up a Central Management Server. This will allow you to take control of the other servers from a...
May 9, 2011 at 5:43 pm
It really depends on the size of the database and the rate of growth. I wouldn't get hung on specific numbers. If a database is growing very slowly, it can...
May 9, 2011 at 5:36 pm
GSquared (5/9/2011)
May 9, 2011 at 5:22 pm
ejavier.r.dk (5/9/2011)
Now, I want to use the info from the trace in SCOM, and I know SCOM...
May 9, 2011 at 10:40 am
Not sure what article you're talking about, but I'd check the connection settings between the two. Probabably one has different ANSI settings than the other which leads to a different...
May 9, 2011 at 8:24 am
If you really do want to learn the internals, Gail is right (something you can just say about most things, most of the time), Benjamin's book is a great place...
May 9, 2011 at 7:23 am
Pretty much use Michelle's scripts. They're solid as can be. We had reasonably wide maintenance windows and the databases weren't terribly large (100gb each) so we did full maintenance of...
May 9, 2011 at 6:31 am
Viewing 15 posts - 12,556 through 12,570 (of 22,214 total)