Viewing 15 posts - 56,656 through 56,670 (of 59,072 total)
No such thing in SQL Server 2000. You can make one with a trigger on each table and a "LastModified" table... just be careful not to make any deadlocks...
April 4, 2007 at 8:12 pm
Some hard disk systems (SAN's, etc) come with clone and snapshot systems that will do this in scant minutes for a half-terabyte database.
April 4, 2007 at 8:09 pm
Um... not sure... but I think you may have missed the point...
What does the "executable" actually do? And for how many rows per call does it do it?
April 4, 2007 at 8:06 pm
Eamon,
Drop the target table (takes indexes with it) and do a SELECT collist INTO tgttable FROM srctable WITH (NOLOCK). Then, reapply your indexes. If it takes more than 10 minutes...
April 4, 2007 at 7:48 pm
I ran Jeff's code (because I want to understand it!!) and got what I expected which is: Shape,Length,Width,Color,Length... |
April 4, 2007 at 6:59 am
Heh... Thanks David...
I've been doing a lot of BCP work lately and ran into this ol' post of mine... Yeah, I know it's a forum and we shouldn't expect...
April 4, 2007 at 6:02 am
Ya know, Brenda... a little feed back on this extent of this type of help would have been appreciated. At least let me know how it worked out for you...
April 3, 2007 at 7:29 pm
sp_Help tablename is what most folks are looking for. Similar to "describe" in Oracle. Lemme know if that's not quite what you wanted.
April 2, 2007 at 11:11 pm
Madhuri,
There are several ways to do this... most of them are covered in the following URL...
http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/
April 2, 2007 at 9:50 pm
First, you might want to tell how you'd do that.
Second, the request was specifically for how to do it from a stored procedure.
April 2, 2007 at 9:48 pm
| Even if you say, "It's fifteenth normal form, Google it, Skippy" that will be a big help. |
It is...
April 2, 2007 at 8:11 pm
Try using ISDATE(expression) in a SELECT to find the bad data... See BOL for more detail on ISDATE.
April 2, 2007 at 7:18 pm
If you want better performance, use derived tables instead of WHERE IN or WHERE EXISTS.
April 2, 2007 at 7:15 pm
What's wrong with your NOLOCK is just what Serqiy said... because it's not in parenthesis, the word NOLOCK is being used as a table alias and not a table optimizer...
April 2, 2007 at 6:12 pm
Viewing 15 posts - 56,656 through 56,670 (of 59,072 total)