Viewing 15 posts - 37,276 through 37,290 (of 49,552 total)
What do you mean by resume?
Can you explain clearly what you've done, what the problem is and what help you need?
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
August 6, 2009 at 5:42 am
Did you read the article that I references?
I don't see table definitions, I don't see index definitions and there's no execution plan.
Also, have you checked to see if 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
August 6, 2009 at 5:42 am
Not with the native backup tools. Some 3rd party backup tools do have that feature.
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
August 6, 2009 at 5:31 am
Paul White (8/6/2009)
I wonder if it is the same guy? He certainly seems spookily similar in posting style...?
Don't think it is. The PhD candidate has complained in the past...
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
August 6, 2009 at 5:27 am
Why backup several tables to file? Are you not taking database backups? If you are, why also backup the tables to file?
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
August 6, 2009 at 4:38 am
Can you post at least the query? Almost impossible to give useful advice on performance without seeing code. Also the exec plan, table definitions and index definitions. Please take 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
August 6, 2009 at 4:36 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please, direct replies to: http://www.sqlservercentral.com/Forums/Topic766034-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
August 6, 2009 at 4:35 am
What do you mean by 'impact on the size of the column'? A column size isn't affected by creating indexes.
Why on earth are you storing a guid 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
August 6, 2009 at 4:28 am
Jeff Moden (8/2/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
August 6, 2009 at 2:49 am
If you disable an index SQL drops the index tree completely, leaving just the metadata bahind. When you re-enable the index, the index is completely rebuilt from scratch, just as...
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
August 6, 2009 at 2:45 am
Jeff Moden (8/5/2009)
He's mine, please... all mine... pork chops in progress. I don't want to start a dog pile on him, but he's mine.
You have noticed that the OP...
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
August 6, 2009 at 2:38 am
If you want singing.....
http://12seconds.tv/channel/CraigN/218481
On the left, Nicholas, an Exchange MVP. On the right, Zlatan, a Sharepoint MVP.
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
August 5, 2009 at 4:48 pm
Bob Hovious (8/5/2009)
I know... otherwise I would never have dared to say that 😉
I more meant in general. That wasn't the only session that I played, just the only one...
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
August 5, 2009 at 4:31 pm
I was playing guitar, not singing
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
August 5, 2009 at 12:23 pm
If you include all the table columns as include in every index then you're incuring major overhead in two places.
1) Space. Each index will be the same size as 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
August 5, 2009 at 12:19 pm
Viewing 15 posts - 37,276 through 37,290 (of 49,552 total)