Viewing 15 posts - 38,851 through 38,865 (of 49,552 total)
Yes, nonclustered indexes slow down data operations because those changes (whether it's insert, update or delete) has to be done to the table and all the NC indexes.
Test it...
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
May 28, 2009 at 7:14 am
The garbage collector runs every time a checkpoint runs, however in full, the old doc can't be removed until a log backup has run (not a full DB backup)
See -...
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
May 28, 2009 at 7:13 am
Odd. Those normally aren't caused by IO problems but usually by people directly editing the system tables on SQL 2000. Disk issues usually cause more damage than a single missing...
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
May 28, 2009 at 3:41 am
GilaMonster (5/23/2009)
If a database is detached while in the recovering or standby state, it cannot be reattached (baring some odd hacks that may or may not work)
Pradyothana Shastry (5/27/2009)
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
May 27, 2009 at 3:42 pm
Is there an echo in here ...echo in here... ...echo in here... ?
http://www.sqlservercentral.com/Forums/FindPost724259.aspx
http://www.sqlservercentral.com/Forums/FindPost723631.aspx
http://www.sqlservercentral.com/Forums/FindPost724592.aspx
http://www.sqlservercentral.com/Forums/FindPost724263.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
May 27, 2009 at 3:38 pm
And, seeing as it is a performance problem, execution plan (saved as a .sqlplan file, zipped and attached) and index definitions (if there are any indexes)
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
May 27, 2009 at 1:49 pm
Roy Ernest (5/27/2009)
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
May 27, 2009 at 1:43 pm
Please read through this - Managing Transaction Logs[/url]
If you have any questions afterwards, do ask.
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
May 27, 2009 at 1:32 pm
Ok, from that I'm going to guess that the starting size for tempDB is the default. 2MB. Not good when it's getting large.
Use the Alter Database command, or viw 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
May 27, 2009 at 1:29 pm
You're still second, and top looks like someone going through and answering multiple QotD
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
May 27, 2009 at 10:23 am
Lynn Pettis (5/27/2009)
Florian Reischl (5/27/2009)
@Lynn:Congratulation for 7k points! 🙂
Thanks! 😉
Yeah, congrats. Noticed that you were top of the 'most frequent posters' list yesterday.
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
May 27, 2009 at 10:13 am
Steve Jones - Editor (5/27/2009)
If you (ya'll) want to write a book together or separately, Tony Davis of Simple-Talk is always looking for some to use in promotions.
I'd love...
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
May 27, 2009 at 9:59 am
Aaack!
Truncating the log breaks the log chain. If that is run, no log backups may be made afterwards and hence no point in time restores are possible until a full...
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
May 27, 2009 at 9:58 am
Max (5/27/2009)
3. Gail, I think RECOMPILE was available in 2005 and it would have been possible in 2k to use:CREATE PROC dbo.sp_TestProc @intPara1WITH RECOMPILE
AS...
Yes it was and yes...
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
May 27, 2009 at 9:14 am
Roy Ernest (5/27/2009)
Gail, that was what my teacher used to do. Are you sure you have never been to India and taughtDB2??
Never been to India, never even used DB2.
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
May 27, 2009 at 8:54 am
Viewing 15 posts - 38,851 through 38,865 (of 49,552 total)