Viewing 15 posts - 11,506 through 11,520 (of 49,562 total)
Jeff Moden (9/29/2013)
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...
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...
September 29, 2013 at 3:27 pm
DROP STATISTICS <table name>.<statistics name>
Why do you want to do this?
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?
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...
September 29, 2013 at 3:02 pm
Could you be a little more specific?
September 29, 2013 at 1:35 pm
Jeff Moden (9/27/2013)
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.
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.
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...
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'?
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
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...
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...
September 28, 2013 at 4:53 am
Viewing 15 posts - 11,506 through 11,520 (of 49,562 total)