Viewing 15 posts - 12,706 through 12,720 (of 22,214 total)
This was a while ago, but I wrote two articles on how to do unit testing with TSQL using some open source tools[/url] and using Visual Studio tools[/url]. And one...
April 19, 2011 at 5:10 am
Just to pile and beat on your bruises a bit, you're spending too much time, especially in the second abstract defining the problem. You need to define the problem space...
April 18, 2011 at 5:40 pm
If all you're looking at is sys.dm_os_wait_stats then no, you can't narrow that down to a database. But if you start using some of the other DMOs like sys.dm_os_waiting_tasks, you...
April 18, 2011 at 5:34 pm
Uripedes Pants (4/18/2011)
April 18, 2011 at 2:21 pm
GilaMonster (4/18/2011)
CirquedeSQLeil (4/18/2011)
GilaMonster (4/18/2011)
London's calling....(and my bank account is crying)
That would be a nice trip.
Yup. Booked flights so that I get 4 and a bit days at leisure in the...
April 18, 2011 at 1:51 pm
Glad to hear it worked. Did you patch the server first?
April 18, 2011 at 1:49 pm
SQL Backup from Red Gate is very good about centralizing management of your backups. Plus it has other benefits, like backup compression for 2000 and 2005 databases and backup...
April 18, 2011 at 7:59 am
This is a classic "are you sure really need everything, every time" discussion that you should have with your application team. Also, I suspect, it's hard to know based just...
April 18, 2011 at 7:56 am
forsqlserver (4/18/2011)
Thanks...from Where I can start..Currently with close we just start installtion wiith very fw checks...:-D
You have to set up the monitors. Start now. For a general set of monitors...
April 18, 2011 at 5:35 am
You might see a speed up in the start up process if you have fewer databases, but overall performance wouldn't be affected at all.
April 18, 2011 at 5:30 am
Have you looked to see what queries are being run during these times? Sounds like they might be hitting parallelism. It's worth checking to see what they're doing and how...
April 18, 2011 at 5:29 am
You're posting in the 2005 forum, you might get answers that are not applicable for the version you're looking for. You'll probably get more help by posting in that forum.
April 18, 2011 at 5:27 am
Well, in order to project growth, you need at least two measurements. Let's assume a week apart. Then take the difference and project it in a straight line, multiply by...
April 18, 2011 at 5:17 am
As a general rule, yes, but you do need to account for your own individual circumstances, the load on your servers, the number and size of your databases, etc. There...
April 18, 2011 at 5:14 am
It has to be something along the lines of which one will the optimizer pick first, but that's so subject to a million different factors, it's still not really...
April 18, 2011 at 5:12 am
Viewing 15 posts - 12,706 through 12,720 (of 22,214 total)