Viewing 15 posts - 14,206 through 14,220 (of 22,211 total)
I sure don't have any, but you might search through Brent Ozar's blog[/url]. He's talked about them pretty frequently.
October 1, 2010 at 1:29 pm
Tim Parker (10/1/2010)
In case I completely misunderstood your question, here is a link to BOL that discusses the HOLDLOCK table hint.ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/8bf1316f-c0ef-49d0-90a7-3946bc8e7a89.htm
See if this is what you're looking for.
I think you...
October 1, 2010 at 12:05 pm
Tim Parker (10/1/2010)
SQL Server by default should be in pessimistic mode, which should give you the behavior you're looking for without table hints.
True but, they've got snapshot isolation going, which...
October 1, 2010 at 12:04 pm
If they can access row versions through snapshot isolation, you're kind of in trouble. In fact, that's the whole idea of setting up snapshot isolation, allowing access to data while...
October 1, 2010 at 9:07 am
What do the execution plans look like? Just because you put an index on the tables doesn't mean it's being used.
Also, pulling 35000+ rows out of the db in...
October 1, 2010 at 9:02 am
Tim Parker (10/1/2010)
We were fortunate that our Senior DBA was monitoring this server during the time frame of that exception. He was not seeing any CPU pressure during...
October 1, 2010 at 8:48 am
Steve Jones - Editor (10/1/2010)
Grant Fritchey (9/30/2010)
Come on over to my house. I need wood split.
Isn't that your "white oak therapy" time?
Ha! No man, not while swinging a maul or...
October 1, 2010 at 8:46 am
Ronnie_Doggart (10/1/2010)
CREATE TABLE [dbo].[IMPORTINSTVERSION](
[INSTANCEID] [numeric](18, 0) NOT NULL,
[IMPORTNAME] [varchar](50) NOT NULL,
[IMPORTBUNDLEID] [numeric](18, 0) NOT NULL
)
The procedure does not generate the exceptions on other customer databases, just with...
October 1, 2010 at 8:29 am
You're right. Is IMPORTINSTVERSION a UDF possibly?
It's odd that such a simple, straight-forward proc is getting cache misses. Unless I'm missing something, that should be sitting in cache waiting for...
October 1, 2010 at 8:21 am
That's basically a hardware issue and means that your processors are maxed out. In terms of waits to monitor for a situation like this? CXPACKET & SOS_SCHEDULER_YIELD are indications of...
October 1, 2010 at 8:18 am
16954 is related to cursors. Do you have one within the procedure? If so, something is going south with it.
October 1, 2010 at 8:07 am
The Dixie Flatline (10/1/2010)
Is anyone else having trouble posting this morning?Steve, I have an answer for the OP in this thread and it won't post my reply.
Not that I've noticed,...
October 1, 2010 at 8:02 am
Yeah, use the shrink file function, not shrink database.
October 1, 2010 at 7:43 am
The number of rows being returned is different, so the second plan is getting a seek and a key lookup instead of a scan. Personally, I wouldn't be happy with...
October 1, 2010 at 6:04 am
Yeah, it is a setting within SSMS that allows you to display varying amounts of large data fields (text, VARCHAR(MAX), etc.) but only up to a limit. Past, I think,...
October 1, 2010 at 6:01 am
Viewing 15 posts - 14,206 through 14,220 (of 22,211 total)