Viewing 15 posts - 29,071 through 29,085 (of 49,552 total)
So from what I understand, if I want a covering index for this query it either has to include all of the columns in SomeTable to avoid a lookup, or...
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
December 2, 2010 at 9:30 am
Switching to simple does not remove logging. It just means that SQL will automatically mark the log space as reusable and you won't need log backups.
Simple recovery means:
Restore only...
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
December 2, 2010 at 2:27 am
Try rebuilding the clustered index.
By dropping the column you've created some free space on each page. Shrink only deallocates completely free pages.
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
December 2, 2010 at 2:20 am
2008 and 2008 SP1 are the same version, just a service pack.
2008 R2 is a new version with a significant number of BI changes, minimal database engine changes. There are...
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
December 2, 2010 at 2:14 am
Tom.Thomson (12/1/2010)
Greg Edwards-268690 (12/1/2010)
GilaMonster (12/1/2010)
In the last 2 weeks there have been three resignations at current client:
The senior developer (leaving only 2 permanent developers)
...
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
December 2, 2010 at 2:11 am
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC TRACEON(1222,-1)
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
December 2, 2010 at 2:04 am
Paul Randal (12/1/2010)
Maybe mention you're talking to me and I'll be discussing the case with Bob Ward. 🙂
😀 You're evil sometimes....
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
December 2, 2010 at 2:03 am
In the XML plan. I believe (no 2005 any longer) that you can right-click the plan and there's an option for the XML.
Don't take these missing indexes as correct. They're...
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
December 1, 2010 at 2:06 pm
Once more with feeling...
ALL corruption is either a faulty IO subsystem or a SQL bug. 99% - IO subsystem problems. Repeated corruption is a good indication that something is wrong...
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
December 1, 2010 at 2:04 pm
Robert Biddle (12/1/2010)
I will play around with a piecemeal restore with files/filegroups sometime.
You need full recovery or all-but-primary filegroups to be readonly to do that
In my current environment, we're backing...
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
December 1, 2010 at 1:59 pm
An application cannot cause corruption (of any form) unless it encounters a bug in SQL.
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
December 1, 2010 at 12:29 pm
What you're proposing won't work because of your recovery model requirement. You'll be able to backup files/filegroups, but you won't be able to restore them.
In simple recovery, the first backup...
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
December 1, 2010 at 11:08 am
mikesigsworth (12/1/2010)
Should I just put all of the columns in the included columns?
No, absolutely not. By doing that you will be duplicating the table. Think of the impact...
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
December 1, 2010 at 11:03 am
Are you using DBCC ShowStatistics to see what's in the table, or are you querying the table?
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
December 1, 2010 at 10:44 am
I checked with a couple of people. Mirroring 2008 -> 2008 R2 is possible, the reverse is not. The mirroring of different versions is only for rolling updates, not 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
December 1, 2010 at 8:39 am
Viewing 15 posts - 29,071 through 29,085 (of 49,552 total)