Viewing 15 posts - 19,066 through 19,080 (of 22,214 total)
I'm pretty similar in approach, Profiler is my bestest buddy.
After that, since you're in 2005, you can look at sys.dm_exec_query_stats for an immediate picture into which queries are running...
December 15, 2008 at 8:49 am
It sounds like you can do this with a trigger or with a stored procedure. While I'm not a fan of triggers, if you need one, you need one. It...
December 15, 2008 at 6:50 am
Krishna_DBA (12/13/2008)
Why dont use DTA tool and apply the recommendations from there? I am just wondering.....
Primarily because it's unreliable. Your time is better spent learning how to do indexing yourself...
December 15, 2008 at 6:29 am
Are the inserts & deletes done all the time or in discrete batches? If the latter, you can leave indexes off until you need them and then add them. If...
December 15, 2008 at 6:25 am
And you use this to reduce the number of calls back and forth between the stored procedure and the application calling it.
December 15, 2008 at 6:20 am
Also, by default, every proc exits with either a 0 for success or a 1 for failure as a return code on the proc. You can check for this in...
December 15, 2008 at 6:10 am
So, if you run the TSQl to create your function, you can't see it? Are you looking through the GUI? If so, make sure you're hitting refresh. If you can...
December 15, 2008 at 6:07 am
And here, the thread died, a horrible, messy death.
December 15, 2008 at 6:05 am
IT isn't going away any time soon. If it does, we'll be far to busy eating each other to worry about where a pay check is going to come from.
December 15, 2008 at 5:51 am
I guess I'm a bit in the middle. While, as an employee, I really don't want to see my job go away (really, seriously, I like my job, I need...
December 15, 2008 at 5:49 am
To really answer the question, you've got to post the execution plans.
When updated statistics, did you use the FULL SCAN option?
December 14, 2008 at 8:08 am
It's a pretty standard lookup table design:
LookupTable
LookupID Year Desc
1 1999 'Some important value'
2 ...
December 14, 2008 at 8:02 am
Jeff Moden (12/13/2008)
I'm old... for me it's "may the farts be with you". Gives new meaning to the phrase, "It Depends". :hehe:
Oh no!
Mr. Bill!
December 14, 2008 at 7:44 am
jcrawf02 (12/12/2008)
December 14, 2008 at 7:41 am
Viewing 15 posts - 19,066 through 19,080 (of 22,214 total)