Viewing 15 posts - 61 through 75 (of 98 total)
Martin Bell (8/2/2009)
the sqlist (7/31/2009)
Mmm... the delete option doesn't seem to work!
What delete option?
I tested that code right before I posted it and everything worked fine.
Don't just give the hungry man a fish, teach him how to catch it as well.
the sqlist
August 3, 2009 at 10:33 am
I agree with the ideea that the sql script files should be kept in separate files but for the output file is better to have only one as is far...
Don't just give the hungry man a fish, teach him how to catch it as well.
the sqlist
July 31, 2009 at 10:51 am
I am doing this for a long time now and personally I don't see the need of that complicated T-SQL code. The bacth file is the best and by far...
Don't just give the hungry man a fish, teach him how to catch it as well.
the sqlist
July 30, 2009 at 3:10 pm
And in regards to the backup-restore promotion method, would work only if the database is in within reasonable size limits, if is few hundred of gigs then becomes a problem.
Don't just give the hungry man a fish, teach him how to catch it as well.
the sqlist
May 17, 2009 at 8:47 am
Actually you are the one with no structure in place because there is no reason for code in development to be executed in production. When everything is structured and...
Don't just give the hungry man a fish, teach him how to catch it as well.
the sqlist
May 17, 2009 at 8:42 am
Gift Peddie (5/17/2009)
Don't just give the hungry man a fish, teach him how to catch it as well.
the sqlist
May 17, 2009 at 8:21 am
Gift Peddie (5/17/2009)
...When you have .bak in VSS that is the only thing given to QA, Staging and production so there is tight control of the database build.
So you say...
Don't just give the hungry man a fish, teach him how to catch it as well.
the sqlist
May 17, 2009 at 7:58 am
Thanks, Gift Peddie for your reply.
When you say add .bak to VSS do you mean the database backup? Sounds a bit too much, why the need of backup in...
Don't just give the hungry man a fish, teach him how to catch it as well.
the sqlist
May 17, 2009 at 7:43 am
Gift Peddie (5/16/2009)
Don't just give the hungry man a fish, teach him how to catch it as well.
the sqlist
May 17, 2009 at 4:46 am
Gift Peddie (5/16/2009)
Don't just give the hungry man a fish, teach him how to catch it as well.
the sqlist
May 16, 2009 at 9:45 am
JeremyG (5/9/2009)
Don't just give the hungry man a fish, teach him how to catch it as well.
the sqlist
May 9, 2009 at 4:22 pm
jeremygiaco (4/14/2009)
Don't just give the hungry man a fish, teach him how to catch it as well.
the sqlist
May 9, 2009 at 8:57 am
You need to use the OSQL utility for 2K server or OSQL or SQLCMD utility for 2K5 server and up. For 2K5 both utility are available. These command line utilities...
Don't just give the hungry man a fish, teach him how to catch it as well.
the sqlist
April 25, 2009 at 4:10 am
SQL Frenzy (2/25/2008)
Hi,Can we have two identity columns on a single table?
If not then how can one insert an identity column in a table having an identity column?
Regards,
Ahmad
The answer...
Don't just give the hungry man a fish, teach him how to catch it as well.
the sqlist
April 10, 2009 at 8:07 am
Eric Inman (1/6/2009)
one flaw would be ORDER BY and TOP. Check this out:Check this out
http://blogs.msdn.com/queryoptteam/archive/2006/03/24/560396.aspx
The title is "TOP 100 Percent ORDER BY Considered Harmful". My query doesn't use TOP 100(N)Percent....
Don't just give the hungry man a fish, teach him how to catch it as well.
the sqlist
January 6, 2009 at 3:02 pm
Viewing 15 posts - 61 through 75 (of 98 total)