Viewing 15 posts - 13,546 through 13,560 (of 22,213 total)
You basically can do two things, sample the waiting processes regularly during the day to see if you can catch a query waiting because of cxpacket or set up a...
January 20, 2011 at 7:29 am
Multi-statement user defined functions & table variables are estimated based on 1 row, so their "cost" estimates are extremely low when compared to regular & temp tables that have actual...
January 20, 2011 at 7:27 am
Really hard to be sure without seeing the execution plan.
January 20, 2011 at 7:21 am
It's pretty much whatever comes in front of you from day to day that you are either fascinated with, excited by or knowledgeable about. Preferably all three. You can't worry...
January 20, 2011 at 7:15 am
It's just like running SQL Server on a virtual. Do you have enough resources? If so, yeah, it's fine. If not, no it's not. Actually, same thing as a physical...
January 20, 2011 at 7:11 am
Yes, it's possible. It's actually the right way to go. If you remove all the objects from the filegroup you can drop the file and filegroup without affecting your database.
January 20, 2011 at 7:02 am
I agree with Gail. Targeting functionality for a proc is better than trying to create a catch-all for any number of reasons.
January 20, 2011 at 6:46 am
The problem is there aren't any hard & fast rules for data types & performance. Smaller is better, but if you have a number that won't fit in a tinyint...
January 20, 2011 at 6:41 am
That's definitely odd behavior. Another thing to check, are there differences in the ANSI settings between the two procs? Other than that... I'm not sure.
January 20, 2011 at 6:36 am
Ronnie Jones (1/20/2011)
So basically, it sounds like this process is manual meaning that I will have to look at each table to determine if I...
January 20, 2011 at 5:49 am
SQL08Kid (1/18/2011)
Grant Fritchey (1/18/2011)
Has to be triggers or something going on behind the scenes.
Grant, what's the best way to see if anything is happening behind the scenes? This happens every...
January 18, 2011 at 11:38 am
Has to be triggers or something going on behind the scenes.
January 18, 2011 at 11:20 am
You'll get a plan for each query in the branch. I wouldn't think that would be the cause, but it might be related in some way.
January 18, 2011 at 9:01 am
Steve Jones - SSC Editor (1/18/2011)
January 18, 2011 at 8:22 am
That doesn't sound like an error. That sounds like a statement put the database in an offline condition.
January 18, 2011 at 8:13 am
Viewing 15 posts - 13,546 through 13,560 (of 22,213 total)