Viewing 15 posts - 5,401 through 5,415 (of 8,416 total)
Actually, there is a way to to reliably get a particular ordering without an ORDER BY.
Records inserted into a HEAP will come back in insertion order, as long as no...
March 14, 2010 at 2:03 am
Two main experiences with HP Blades: at one place, they had tremendous problems with heat dissipation - leading to a crazy arrangement of huge fans in addition to massive A/C....
March 14, 2010 at 1:22 am
GTR (3/14/2010)
I meant Backup\Restore is preferred over Attach and Detach, sorry for the ambiguity.
At last! Do try to be more clear in future, it saves the sort of discussion...
March 14, 2010 at 1:13 am
CirquedeSQLeil (3/13/2010)
I really think you are wasting your time using those options.Perform the shrinkfile without those options that you are specifying.
Nice.
March 14, 2010 at 12:08 am
GTR
Yes, I think when someone writing an article they tend to write preferred method first, then the alternate method, correct me if i am wrong.
Consider yourself corrected, then. Many...
March 14, 2010 at 12:06 am
To embed a single quote mark (') in a string, it needs to be doubled-up.
You can use PRINT @scmd to see how the string looks before it gets executed.
The following...
March 13, 2010 at 11:30 pm
GTR (3/13/2010)
Here is the reference http://support.microsoft.com/kb/314546
From the KB article:
To move user databases, use one of the following three methods.
That article describes three methods, backup/restore, attach/detatch, and Import/Export Data Wizard.
It expresses...
March 13, 2010 at 10:57 pm
CirquedeSQLeil
Yeah - I noticed. Nobody has been able to keep pace with you. Takes a lot of time to post at that rate.;-)
It won't last - don't worry...
March 13, 2010 at 9:48 pm
Lynn Pettis
I'm not sure and would do more investigating before commiting one way or the other.
I find it hard to credit that any reasonably competent person could believe that summing...
March 13, 2010 at 9:19 pm
CirquedeSQLeil (3/13/2010)
lmu92 (3/13/2010)
@paul-2: CONGRATULATION to be one of the top 25!Congrats indeed. He's been making a mad push lately.
Top 25 overall? I will have to go look at...
March 13, 2010 at 8:59 pm
Lynn Pettis
First, read what I wrote, I would have to do some testing to know if the in-line TVF would scale well or not.
:laugh: I did read what you wrote!
You...
March 13, 2010 at 8:54 pm
Jeff Moden (3/13/2010)
Nicely done but...without exceeding 25 records for all.
Well that is just embarrassing. :blush:
Your solution has some nice features, particularly in the calculation of counts.
It does raise a question,...
March 13, 2010 at 8:33 pm
GTR (3/13/2010)
Yes, you are correct both methods will work, but i have seen issues like files corrupt while attaching\detaching method.
And I have seen backup/restore fail too. Either will work,...
March 13, 2010 at 7:57 pm
Steve Jones - Editor (3/13/2010)
I don't know that a table driven approach is being dismissed
Not by me it wasn't - either approach will work.
I see no compelling difference between centralizing...
March 13, 2010 at 7:53 pm
Yes, if you want them to all succeed or fail as a unit.
March 13, 2010 at 7:48 pm
Viewing 15 posts - 5,401 through 5,415 (of 8,416 total)