Viewing 15 posts - 151 through 165 (of 429 total)
skrilla99 (4/9/2008)
How soon is pretty soon?
measured in days, it's same as the length of a piece of string in cubits.
April 9, 2008 at 6:25 pm
I wrote an app called sqlspec that may be of use to you. It shows dependency diagrams and pk-fk diagrams for all objects in any database on every major...
April 9, 2008 at 6:19 pm
you don't need to drop the table - why not just drop and recreate the index? you could do so with ALTER TABLE for example
April 9, 2008 at 6:15 pm
I say sequel.
A friend of mine says "squeal"
๐
April 9, 2008 at 6:06 pm
if you care about ANSI compliance, better to use INFORMATION_SCHEMA views. but who cares about that... ๐
April 9, 2008 at 5:59 pm
if you are loading the table again with 200m rows, it's faster to drop the index, load the table, then recreate the index.
also, I hope you are using BCP or...
April 9, 2008 at 5:50 pm
yes, drop is fast too.
delete is slow because the whole mess is logged to the transaction logs.
I'm afraid you'll just have to wait this time because the server is busy...
April 9, 2008 at 5:16 pm
next time try TRUNCATE if you are wiping out the whole table.
if you save and close the query window in SSMS, it will usually respond to that.
April 9, 2008 at 5:13 pm
maybe you misunderstood me. SqlSpec DOES document jobs. You just need to specify that you want it to document jobs.
March 28, 2008 at 12:11 pm
salvadorscardua (3/28/2008)
Hi all,Your Tool is very atractive, but not document Jobs, or iยดm wrong?
wait,
SqlSpec does document jobs, but not by default. To do it, you need to check the...
March 28, 2008 at 9:56 am
glad to hear you are a fan of documentation tools. here's a shameless plug for one I wrote. ๐
It supports 11 different DBMS in addition to SQL Server....
March 8, 2008 at 9:47 am
I wrote an app called SqlSpec that does this. It supports 11 different DBMS platforms, including SQL Server. See the link in my sig below for details.
March 8, 2008 at 9:39 am
onlo (12/12/2007)
Dear all,Thanks for your replies.
I wrote a simple program with SMO, but why the result was different to the script which was generated manually :
there are many options...
December 13, 2007 at 9:56 am
onlo (12/13/2007)
Microsoft said :
SQL Server 2005 Books Online (September 2007)
Script Method
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new...
December 13, 2007 at 9:22 am
Viewing 15 posts - 151 through 165 (of 429 total)