Viewing 15 posts - 45,391 through 45,405 (of 49,552 total)
Please don't cross post. It just fragments replies and wastes people's time. Many of us read all the forums.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic541789-5-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 28, 2008 at 2:53 pm
The one case where I've seen a select take an X lock is inside a trigger if selecting from the table the trigger is on.
At this point, I'd suggest haul...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 28, 2008 at 2:52 pm
Post reported.
Handing out brain dumps is a violation of the NDA that you take when writing an exam. It is illegal.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 28, 2008 at 2:48 pm
There are two resources that I know of for learning to read exec plans.
Firstly there's Grant Fritchey's e-book. Last I saw it was available if you download any redgate product...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 28, 2008 at 2:44 pm
Grant Fritchey (7/28/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 28, 2008 at 2:40 pm
Strange. The locks are IX or SIX (intent exclusive or select with intent exclusive). A simple select should just be taking an S lock.
Are these queries part of a stored...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 28, 2008 at 2:38 pm
Post code?
Could it be blocking? If you query sysprocesses, what does it show for the 'hung' query? (specifically last wait type and blocked by)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 28, 2008 at 2:34 pm
Please don't cross post. It just waste people's time and fragments replies. Many of us read all the forums.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic542198-148-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 28, 2008 at 2:30 pm
Please don't cross post. It just waste people's time and fragments replies. Many of us read all the forums.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic542198-148-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 28, 2008 at 2:27 pm
What do the following perfmon counters look like?
Physical disk Avg sec/read (break down for each disk)
Physical disk Avg sec/write (break down for each disk)
Physical disk reads/sec (break down for...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 28, 2008 at 1:58 pm
That's far too long.
How big's the DB, how active and what is your storage system?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 28, 2008 at 10:43 am
torpkev (7/28/2008)
Does anyone know the exact release date yet? -- I believe its Q3, but any idea when?
I don't think anyone knows. The guys over at MS are being...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 28, 2008 at 10:37 am
There are three different ways that the query processor can implement joins, loop, merge, hash. They're each good in specific conditions. If you use a hint, you are forcing the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 28, 2008 at 10:30 am
If you're running SQL 2005 SP2 or higher, you should be able to do this with a logon trigger. Within the trigger you can check the user name and the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 28, 2008 at 10:26 am
I thought Vue had discontinued the MS exams a long time ago. Was that just outside of the US? Down here it's only prometric now.
Farhad: http://www.prometric.com You can find a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 28, 2008 at 10:10 am
Viewing 15 posts - 45,391 through 45,405 (of 49,552 total)