Forum Replies Created

Viewing 15 posts - 22,471 through 22,485 (of 49,552 total)

  • RE: Query Performance

    My articles aren't going to tell you how to tune a query. They're a high-level coverage of how to find the problems and a bit on indexing.

    There's lots and lots...

    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

    November 7, 2011 at 7:30 am

    #1403949

  • RE: Query Performance

    -Syd- (11/7/2011)

    Yes we have of course, but the prices are extremely high.

    For example: 1 us dollar(u$s) = 4,30 Argentine Pesos ($)

    If a book on Amazon cost u$s40, you assume here...

    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

    November 7, 2011 at 7:20 am

    #1403941

  • RE: Query Performance

    -Syd- (11/7/2011)

    Yes, I was aware of that, but I'm from Argentina and our "dear president" (sarcasm) do not allow us to buy dollars or made transaction in dollars, so 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

    November 7, 2011 at 6:25 am

    #1403904

  • RE: Query Performance

    Ninja's_RGR'us (11/7/2011)

    Then free is the way to go => http://www.sqlservercentral.com/articles/books/65831/

    Not the same book.

    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

    November 7, 2011 at 6:25 am

    #1403903

  • RE: SQL 2005 PERFORMANCE

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    November 7, 2011 at 6:13 am

    #1403896

  • RE: Query Performance

    There are entire books written on that. Literally

    http://www.amazon.com/Server-Query-Performance-Tuning-Distilled/dp/1430219025/ref=sr_1_1?ie=UTF8&s=books&qid=1237206053&sr=8-1

    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

    November 7, 2011 at 6:12 am

    #1403894

  • RE: Restore Database

    There's no magic script.

    Use SSIS's tasks or do it manually - script all objects, bcp out all data, recreate the DB on the lower version.

    Or upgrade the instance you're...

    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

    November 7, 2011 at 6:12 am

    #1403892

  • RE: Question about stored procs, xp_cmdshell, and .NET applications

    Any sysadmin (or probably db_owner) can change the ownership of a database

    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

    November 7, 2011 at 6:10 am

    #1403889

  • RE: Clustored indexes and the direction of the sort

    xgcmcbain (11/4/2011)

    im tired of allways having to add order by recordid desc

    Changing the clustered index to be a DESC index instead of the default of...

    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

    November 7, 2011 at 5:54 am

    #1403871

  • RE: Error 9002: The Transaction Log for MSDB database is full.

    GilaMonster (11/7/2011)

    Log in with a local admin account

    And by that I mean a member of the local administrators group. If SQL is in single user mode, any local admin is...

    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

    November 7, 2011 at 5:47 am

    #1403868

  • RE: sql server doesnt come online

    We're going to need the exact error messages. Open up the SQL error log (or windows event viewer, check the errors, post them here)

    SQL won't fail to start because some...

    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

    November 7, 2011 at 5:46 am

    #1403864

  • RE: Error 9002: The Transaction Log for MSDB database is full.

    It's a bit late to add a log file now, that's what would have fixed the log full without rebuilding the system databases.

    Since master has been rebuilt, all logins are...

    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

    November 7, 2011 at 4:51 am

    #1403846

  • RE: Question on SQL Server Client Licences.

    Duran (11/7/2011)

    If you have 10 users that use an application that has a SQL backend database, and the users use a client module of the application (not accessing SQL directly,...

    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

    November 7, 2011 at 4:30 am

    #1403842

  • RE: Error 9002: The Transaction Log for MSDB database is full.

    Start SQL (from the command line) with traceflag 3608 and with -m

    p.s. Rebuilding the system DBs was a little extreme. Adding a second log file temporarily would have fixed this.

    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

    November 7, 2011 at 4:29 am

    #1403841

  • RE: PRIMARY Clustered vs NonClustered

    John Esraelo-498130 (11/6/2011)

    The notion is that the clustered index may contain the entire record physically stored and in order.. where a non-clustered is on one or more columns..

    Doesn't...

    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

    November 7, 2011 at 2:53 am

    #1403820

Viewing 15 posts - 22,471 through 22,485 (of 49,552 total)