Viewing 15 posts - 46,786 through 46,800 (of 59,062 total)
Luke L (12/3/2008)
Another Great article Jeff. Very informative and useful.-Luke.
Thanks, Luke. I appreciate the feedback! 🙂
December 3, 2008 at 8:09 pm
Holy moly... good thing we're not doing deletes or it would also be deleting from a bazillion indexes (some with duplicate functionality). My recommendation would be to simply drop...
December 3, 2008 at 8:06 pm
madhu.arda (12/2/2008)
This script is giving the mdf and ndf file. But I would like to get the actual space allocated for datafile and the available space inorder to monitor...
December 3, 2008 at 7:29 pm
RichardB (12/3/2008)
Jeff Moden (11/29/2008)
Heh... not trying to be a smart guy here... FEDEX overnight. Works great.Thats actually the solution I have recommended.... 😎
Heh... Simple, effective, and fast... no chance...
December 3, 2008 at 7:25 pm
Mad-Dog (5/26/2008)
ok i found script that use the DAC connection to decrypt SP and it's works great.THX
Heh... two way street here, MD... share your solution. Where did you find...
December 3, 2008 at 7:22 pm
philcart (12/3/2008)
December 3, 2008 at 7:20 pm
John Barry (12/3/2008)
So are you saying that instead of creating a row at a time in the live table, stamping each one with a sequence number as you insert it,...
December 3, 2008 at 7:13 pm
Yes... everything is possible... but what are you going to do if there are 40 rooms on the same floor?
December 3, 2008 at 6:57 pm
umanpowered (12/3/2008)
rbarryyoung (11/3/2008)
As Jonathan said: "getdate()" needs to be the definition of the column's default value, and not the definition of the column itself.
Hi,
As a side question, do you know...
December 3, 2008 at 6:52 pm
David Leaver (12/3/2008)
Here's the scenario - I'm taking an existing procedure that historically...
December 3, 2008 at 6:41 pm
Trebuchet... the ultimate pork chop launcher... can launch the whole pig and makes statements followed by "When pigs fly" come absolutely true. 😛
December 3, 2008 at 6:37 pm
I see a bunch of stuff in that code snippet that I think is working against you. Please post the real table creationtion statement for the table you're deleting...
December 3, 2008 at 6:20 pm
I solved a post, last night, using the SIGN function instead of CASE for a pretty good performance gain. It reminded me of what my original programming mentor taught...
December 3, 2008 at 3:59 pm
ishaan99 (12/3/2008)
Thanks Guys i used the charindex without sign function to resolve this. Thanks for everybody;s input.
You bet... thanks for the feedback.
December 3, 2008 at 3:50 pm
Bob Hovious (12/3/2008)
December 3, 2008 at 3:49 pm
Viewing 15 posts - 46,786 through 46,800 (of 59,062 total)