Forum Replies Created

Viewing 15 posts - 1 through 15 (of 15 total)

  • RE: How to Connect to a SQL 2005 Server When You Are Completely Locked Out

    The real way is to use the Dedicated Administrator Connection. You need to be on the physical box and member of sysadmin, and you can use either sqlcmd or Management...

  • RE: Importance of UPSERT

    You conclude that you should do the UPDATE first. "The best strategy is to attempt the update."

    But with any SQL Server question, it depends :). In a heavy transaction...

  • RE: SQL Server Management Studio

    I agree, more on source control integration, thanks.

    We use Speed SQL IDE Pro from Imceda, which I think is the best database tool for integrating source control. Does anybody know...

  • RE: Question of the Day for 17 Dec 2004

    I only answered the question to see other peoples reactions. I was missing this answer NARCISSISM though.

  • RE: Question of the Day for 09 Dec 2004

    Quote: "sets oConfigValue to the value of this parameter... " this is not entirely true. You assign the ConfigValue object to oConfigValue, then you can set the CurrentValue property...

  • RE: Question of the Day for 04 Nov 2004

    Uh, that was a tricky question . Worth 2 points it couldn't be the obvious answer, so I had to scrutinize the code, but ended...

  • RE: exception handling in sqlserver

    You will have to check for errors after every statement (that migth break your code)

    Here is an example that works for most cases:

    Update SomeTable Where Key = @Param

    Select @Err = @@ERROR,...

  • RE: How to find the most frequently executed procs

    This should do the trick

    insert Results

    select name, Count(ObjectID) as Cnt from SP_COUNTS

    inner join sysobjects on ObjectID = ID

    group by ObjectID, name

    The Results table has two columns Name and Cnt

     

     

     

  • RE: Question of the Day for 21 Sep 2004

    A more clear explanation is that the result is the index it self. The data is retrieved from the index, not the table, since your a not requesting other data than...

  • RE: Question of the Day for 02 Sep 2004

    Are you short on new questions?

    The answer was given as part of yesterday's answer.

  • RE: Question of the Day for 25 Aug 2004

    I've previously tried it on my own body, so I know my answer HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft \MSSQLServer\MSSQLServer\LoginMode is correct.

    You must have made the question late at night, since you also...

  • RE: Security Issue

    What happens to the connection? Connection pooling takes place when the connection string is the same, which it will be when using windows authentication. I would guess the connection stays the...

  • RE: Cluster That Index! Part Two

    True, but that kind of defeats the purpose of the clustered index, as you are not likely to do searches on the ID, specially not range searches. You should cluster on...

  • RE: Client side execution plan is incorrect

    There is a bug when you use regional options than don't use . as decimal symbol.

    Chris

     

     

  • RE: How to get all databases name from server

    Why not use SQL-DMO? With this component you can create SQL Enterprise Manager like applications, with out going for the systemtables. Just add a reference to Microsoft SQLDMO Object Library.

    And...

Viewing 15 posts - 1 through 15 (of 15 total)