Forum Replies Created

Viewing 15 posts - 40,081 through 40,095 (of 49,552 total)

  • RE: Order By Clause Different in SQL2000 vs. SQL2005

    Mark Douglass (3/31/2009)

    He claims that SQL2000 would output correctly with the "ss." specifier and in fact would not allow an order by of the named output field without the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 31, 2009 at 3:10 pm

    #969502

  • RE: with nolock in sql server please advice

    Santa Ana (3/31/2009)

    Does the WITH (NOLOCK) option work with sql server 2005 ?

    Yes

    I do not understand why and how can this happen? ( a select with nolock is not...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 31, 2009 at 3:00 pm

    #969493

  • RE: CRUD & stored procs

    That kind of query is all too often a performance nightmare.

    http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 31, 2009 at 10:05 am

    #969247

  • RE: DB snapshot has failed an i/o operation

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic686966-146-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 31, 2009 at 9:45 am

    #969228

  • RE: query execution order

    pedro.ribeiro (3/30/2009)

    ok.

    Why does the GO (bacth breaker) brings more perfomance to que execution of the querys?

    It shouldn't. Have you tested and times it?

    If the first query fails and the second...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 31, 2009 at 2:09 am

    #968890

  • RE: query execution order

    GO is a batch breaker. It indicates where the querying tool must break up batches to send to SQL Server. It is not a T-SQL command

    DECLARE @i int

    Set @i =...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 30, 2009 at 3:17 pm

    #968723

  • RE: query execution order

    pedro.ribeiro (3/30/2009)

    In this case, will the second query starts executing only, when the first one have already finished to execute?

    yes

    Or first it’s executed the first query and...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 30, 2009 at 2:09 pm

    #968659

  • RE: Getting index table names

    You can check in sys.indexes, though note that index names don't have to be unique across the database, just unique on a table, so there may be two or more...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 30, 2009 at 2:07 pm

    #968656

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/30/2009)

    Just what do the users expect us to do???

    Read their minds, pull out a magic wand and make the nasty error go away, of course.

    😉

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 30, 2009 at 2:02 pm

    #968650

  • RE: Have no access and unable to administer

    Yup, that's SQL 2000, not 2005 at all.

    I just need to check and see of the 'backdoor' admin access worked on SQL 2000.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 30, 2009 at 9:54 am

    #968474

  • RE: Trigger question

    Jeff Moden (3/28/2009)

    Disabling a trigger from within a trigger probably shouldn't be done either. What if someone does an update to that table while the trigger is disabled? ...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 30, 2009 at 9:36 am

    #968463

  • RE: Have no access and unable to administer

    john (3/30/2009)

    C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL\BINN\SQLSERVER.EXE -sMSSQLSERVER

    I have an odd feeling that is a SQL 2000 instance. The directory is wrong for SQL 2005 (which uses the MSSQL.1, MSSQL2. format)

    Can you...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 30, 2009 at 9:33 am

    #968460

  • RE: 2005 certification

    http://www.microsoft.com/learning/mcp/certifications.mspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 30, 2009 at 9:08 am

    #968433

  • RE: Code Formatting

    Steve Jones - Editor (3/30/2009)

    I think the "code" tag is for T-SQL and the "code2" is for XML.

    Testing XML

    [code2]

    [/code2]

    Edit: Nope.

    I notice that the ADDADD is still...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 30, 2009 at 9:03 am

    #968425

  • RE: Have no access and unable to administer

    Ok. What does the services dialog give as the path to the executable?

    Is the other one something like MSSQL$BACKUPEXEC ?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 30, 2009 at 8:49 am

    #968410

Viewing 15 posts - 40,081 through 40,095 (of 49,552 total)