Viewing 15 posts - 11,506 through 11,520 (of 49,552 total)
Jeff Moden (9/29/2013)
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
September 29, 2013 at 5:09 pm
That won't allow you to calculate the size of the database files. It will allow you to calculate the total size of the allocated extents in the database. If you...
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
September 29, 2013 at 4:32 pm
It's not going to get you better plans or better performance. If the stats you dropped weren't needed, they were never used. If they were needed, they'll be recreated. Stats...
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
September 29, 2013 at 3:27 pm
DROP STATISTICS <table name>.<statistics name>
Why do you want to do this?
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
September 29, 2013 at 3:05 pm
Oh dear....
If I may change the topic... For the purposes of a book chapter, what are your favourite statistics-related myths?
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
September 29, 2013 at 3:02 pm
May I suggest getting familiar with the UPDATE, INSERT and DELETE statements? That edit data window should not be used in most cases, because it's not how you're going to...
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
September 29, 2013 at 3:02 pm
Could you be a little more specific?
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
September 29, 2013 at 1:35 pm
Jeff Moden (9/27/2013)
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
September 28, 2013 at 11:58 am
Well, you can't do any operations at all to an offline database, so yes, you can switch with the database online (no other way)
No, the rows are not physically moved.
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
September 28, 2013 at 9:36 am
Look in books online for the format codes for CONVERT and use the one that matches the data that you have.
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
September 28, 2013 at 5:37 am
All of the posted code is vulnerable to SQL injection. Please, please, for the third or fourth time, read up on SQL injection and don't use dynamic SQL until you...
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
September 28, 2013 at 5:05 am
What do you mean exactly by 'online operation'? What do you categorise as a 'logical operation' and a 'physical operation'?
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
September 28, 2013 at 5:00 am
Duplicate post. No replies to this thread please. Replies to http://www.sqlservercentral.com/Forums/Topic1499649-392-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
September 28, 2013 at 5:00 am
Convert them to datetime with the correct format code and use the DATEDIFF function. Don't store dates as varchars, you end up with all sorts of problems if you 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
September 28, 2013 at 4:58 am
btw, it's polite to cite your references when you quote someone almost verbatim...
I will second the recommendation to simplify. Table spools occur when the optimiser decides it's easier and cheaper...
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
September 28, 2013 at 4:53 am
Viewing 15 posts - 11,506 through 11,520 (of 49,552 total)