Viewing 15 posts - 21,976 through 21,990 (of 49,552 total)
Yes it will lock the table. For a nonclustered index, should be a shared lock, so just blocks writers. Unless you have Enterprise edition and can build the index online.
Do...
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
November 25, 2011 at 2:46 am
What Redgate products do you have? SQLCompare sounds like what you want.
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
November 25, 2011 at 1:13 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1211482-360-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
November 25, 2011 at 12:16 am
SqlSpider... (11/24/2011)
This is not the way to give the answers for the post...
And that's not the way to reply to someone who's helping you in his spare time
just tell 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
November 25, 2011 at 12:14 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1211786-391-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
November 25, 2011 at 12:11 am
Most of the study materials are copyrighted books. Go buy them if you feel the need.
Much of the free stuff is of questionable quality and some is outright braindumps...
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
November 25, 2011 at 12:10 am
That's fine. Turn the tracelfag on (either with TRACEON or a startup option) and leave it. When the deadlock reoccurs, the deadlock graph will be automatically written into the error...
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
November 25, 2011 at 12:08 am
Welsh Corgi (11/24/2011)
So how is your day going so far?
It's 2:21 AM and I'm still working.
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
November 24, 2011 at 5:22 pm
First investigate and resolve whatever is preventing the log reuse in all of these. Once you've done that you can focus on shrinking them.
Thing is, nothing can ever move an...
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
November 24, 2011 at 5:21 pm
Lock type U? That means there's an update involved in this (or a select with UPDLOCK hint)
Can you post the deadlock graph?
Switch traceflag 1222 on. That will result in 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
November 24, 2011 at 4:56 pm
Welsh Corgi (11/24/2011)
You can Shrink the log using the following as was provided in the BOL Link:
Copy
USE AdventureWorks;
GO
-- Truncate...
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
November 24, 2011 at 4:41 pm
Welsh Corgi (11/24/2011)
GilaMonster (11/24/2011)
The NoTruncate and TruncateOnly options on a shrink are solely for data files. They are completely ignored when shrinking a log file.
It was my understanding that 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
November 24, 2011 at 2:05 pm
sysfiles is deprecated, included only for backward compatibility with SQL 2000 and should not be used any longer.
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
November 24, 2011 at 9:41 am
Jeff Moden (11/24/2011)
perhaps some experimentation with blocking needs to be done with utility tables, such as the Tally Table.
Those kind of tables should be read-only in use (I don't mean...
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
November 24, 2011 at 9:40 am
Ninja's_RGR'us (11/24/2011)
GS now works for RG so he's borderline on that one ;-).
I think you mean GF (Grant Fritchey), because last time I checked I didn't work for RedGate....
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
November 24, 2011 at 9:37 am
Viewing 15 posts - 21,976 through 21,990 (of 49,552 total)