Viewing 15 posts - 15,451 through 15,465 (of 22,211 total)
A view, unless you're talking about a materialized view, will not help performance in the situation you describe. You need to focus on the queries and what they're doing and...
April 20, 2010 at 6:27 am
The way to tell which parts of the procedure are taking more time is to look at the execution plan. You can run the query yourself through a SQL window...
April 20, 2010 at 6:24 am
arup_kc (4/20/2010)
Gianluca Sartori (4/20/2010)
Some things that come to my mind:1) Badly coded triggers
2) Too many indexes
3) ... any possible reason. The question is too generic to give a good answer.
Hi,...
April 20, 2010 at 6:20 am
Paul White NZ (4/20/2010)
Grant Fritchey (4/20/2010)
But, you don't simply have an ID column and apply a cluster and a noncluster to it, right?
That is exactly what I do 😉
Heh. ...
April 20, 2010 at 6:10 am
Roust_m (4/19/2010)
Grant Fritchey (4/19/2010)
It's going to vary from situation to situation, but the potential for it to have very large impact and take tempdb offline for a considerable length of...
April 20, 2010 at 5:54 am
Paul White NZ (4/20/2010)
Roy Ernest (4/15/2010)
I have never heard of anyone recommending to have both clustered and non clustered on the same column. This is the first time.
It's not all...
April 20, 2010 at 5:51 am
anthony_merriwether (4/19/2010)
April 20, 2010 at 5:46 am
Roust_m (4/19/2010)
April 19, 2010 at 7:30 pm
Jeff Moden (4/19/2010)
only4mithunc (4/19/2010)
Unfortunately I didn't check these two things... And as I mentioned, when I dropped and recreated the SP it was fine, so no chance...
April 19, 2010 at 7:25 pm
RBarryYoung (4/19/2010)
Kit G (4/19/2010)
anthony_merriwether (4/19/2010)
April 19, 2010 at 7:18 pm
Lynn Pettis (4/19/2010)
Grant Fritchey (4/19/2010)
April 19, 2010 at 7:13 pm
The default trace doesn't capture DML. I learned that one the hard way.
April 19, 2010 at 1:20 pm
I owned two different Pacers. One worked great unless it rained. Then, if you splashed through a puddle more than 1/2 deep, it would immediately stall. Great fun, especially on...
April 19, 2010 at 1:07 pm
You would need to pick up a third party log explorer tool. There's no way to do this with native SQL Server tools.
April 19, 2010 at 12:44 pm
jvanderberg (4/19/2010)
Grant Fritchey (4/19/2010)
Another option would be to use a minimally-logged operation such as bcp or BULK INSERT.
I'm confused as to how BCP or BULK INSERT would help, considering the...
April 19, 2010 at 12:41 pm
Viewing 15 posts - 15,451 through 15,465 (of 22,211 total)