Viewing 15 posts - 43,711 through 43,725 (of 49,571 total)
arbarnhart (10/17/2008)
October 17, 2008 at 9:46 am
Get profiler to script the trace. (File - Export). Put the script in a SQL job, make the couple of required changes (specifying a filename and the end time) and...
October 17, 2008 at 9:13 am
And please don't post in all caps. It's the online equivalent of shouting at someone. It's also hard to read.
October 17, 2008 at 9:09 am
Do you have speed problems with the queries from your application, or do you just have speed problems with browsing the metadata in management studio?
October 17, 2008 at 9:07 am
Vishal Singh (10/17/2008)
What can be the best stratgey to deal with 10 Millns of user on one SQL database.
Well written, efficient queries and indexes that support those queries.
October 17, 2008 at 9:02 am
It's not a particularly comfortable time to be without a steady income (consulting), but things aren't as bad down here (South Africa) as in some other parts of the world....
October 17, 2008 at 8:18 am
Leo (10/16/2008)
October 16, 2008 at 3:46 pm
Do you know how I can go about deliberately corrupting a database. I'd like to test some different things, but I'm not sure how to go about it.
Sure....
October 16, 2008 at 3:42 pm
Can you post the trigger?
Is the insert fast when done on the server, but slow when done across a linked server?
October 16, 2008 at 2:07 pm
Yes, you can replace the two indexes. With the include columns, the order they appear doesn't matter.
October 16, 2008 at 1:02 pm
Yes. In fact I've just finished tearing my hear out over exactly that scenario (though I had 315 tables to do).
You can't do it with SQL 2000 though. It...
October 16, 2008 at 1:01 pm
Your strategy sounds good, though I might suggest running the tran logs more often. If the log drive fails, is the loss of 3 hours data acceptable?
I'd also suggest...
October 16, 2008 at 12:49 pm
As far as I'm aware, execution contexts are cached per user and per procedure, not for each statement in the procedure.
October 16, 2008 at 12:44 pm
Not really. The revised version (especially with more than 1 parameter) is likely to table scan all the time. That query has no single optimal plan
The usual recommendations (and often...
October 16, 2008 at 12:41 pm
Don't use locking hints, at least not as the first thing you try
Frequent blocking and deadlocks are usually caused by bad code, bad indexes or both. See if you can...
October 16, 2008 at 12:33 pm
Viewing 15 posts - 43,711 through 43,725 (of 49,571 total)