Forum Replies Created

Viewing 15 posts - 151 through 165 (of 429 total)

  • RE: SQL Server 2005 SP3

    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.

  • RE: Table Dependencies and a list of Stored Procedures

    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...

  • RE: Command Line

    bcp operates on flat text files, not mdb.

  • RE: Clustered index

    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

  • RE: What kind of DBA are you?

    I say sequel.

    A friend of mine says "squeal"

    ๐Ÿ™‚

  • RE: List all Stored Procedures and Views

    if you care about ANSI compliance, better to use INFORMATION_SCHEMA views. but who cares about that... ๐Ÿ™‚

  • RE: Cancelling query

    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...

  • RE: Cancelling query

    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...

  • RE: Cancelling query

    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.

  • RE: How to write a database documentation

    maybe you misunderstood me. SqlSpec DOES document jobs. You just need to specify that you want it to document jobs.

  • RE: How to write a database documentation

    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...

  • RE: Accidently Agile

    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....

  • RE: How to write a database documentation

    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.

  • RE: Automatically to generate a db objects' scripts ?

    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...

  • RE: Automatically to generate a db objects' scripts ?

    onlo (12/13/2007)


    Dear all,

    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...

Viewing 15 posts - 151 through 165 (of 429 total)