Forum Replies Created

Viewing 15 posts - 42,316 through 42,330 (of 49,552 total)

  • RE: Temp table usage in dynamic sql

    If you create the temp table in dynamic SQL, the temp table will go out of scope and be dropped as soon as the dynamic SQL ends. There's no way...

    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

    December 17, 2008 at 12:05 am

    #913629

  • RE: Profiler shut down database?????

    Fraggle (12/16/2008)

    Now, my questions:

    1) why is it the trace caused the timeout issues on both the 32 and 64 bit servers. I know that a profiler trace can cause...

    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

    December 16, 2008 at 11:54 pm

    #913623

  • RE: Are the posted questions getting worse?

    Jeff Moden (12/16/2008)

    Heh... yeah... and he posts at almost the close of business and expects an answer before 10 the next day... gotta love some of these folks.

    I don't pay...

    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

    December 16, 2008 at 11:49 pm

    #913621

  • RE: Union All

    SELECT SUM(SomeColumn) FROM (

    SELECT SomeColumn FROM TableA

    UNION ALL

    SELECT SomeColumn FROM TableB

    UNION ALL

    SELECT SomeColumn FROM TableC) sub

    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

    December 16, 2008 at 4:03 pm

    #913497

  • RE: SQL Server DB 2008 wont re-attach after deleting log file

    ifila (12/16/2008)

    detach the database

    rename the log file

    re-attach the database without the log file

    Don't do that. Logs are not optional components of the DB and that's a really fast way to...

    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

    December 16, 2008 at 4:00 pm

    #913495

  • RE: Learning Priorities

    Steve Jones - Editor (12/16/2008)

    Actually, you just need to know what they'll pay for 😀

    These days around here that mostly seems to be BI and ScarePoint. Did I mention I'm...

    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

    December 16, 2008 at 2:35 pm

    #913464

  • RE: Learning Priorities

    I'm a consultant these days, so I have to know whatever the client wants.

    Right now I'm trying to get by BI skills up to a level where I can...

    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

    December 16, 2008 at 1:13 pm

    #913427

  • RE: SQL Server 2008 Failover clustering on Windows Server 2008

    May I suggest you start by reading the section on clusters and clustering in SQL 2008's Books Online?

    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

    December 16, 2008 at 1:06 pm

    #913425

  • RE: Is Attach db the same as a Restore?

    extremenovice (12/16/2008)

    OK i understand you, but can you answer this for me please. If when you do a restore like in my situation are the mdf & ldf files overwritten...

    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

    December 16, 2008 at 1:04 pm

    #913423

  • RE: Is Attach db the same as a Restore?

    extremenovice (12/16/2008)

    The last backup of the server was last night so if the mdf & ldf files were backed up for that db, then i would want to use those....

    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

    December 16, 2008 at 11:45 am

    #913379

  • RE: Restore Error SQL 2000 to SQL 2005

    Lee Hart (12/16/2008)

    Anyways...let me expand a little bit. Lets say that either the server crashes...you loose a C:\ drive (OS) or just one Db goes suspect on you...

    Well, if...

    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

    December 16, 2008 at 11:34 am

    #913372

  • RE: View Vs T-SQL in QA

    And if you want advice for performance, as you well know by now, we need the table definitions, the index definitions and, if on 2005 or higher, the execution plan...

    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

    December 16, 2008 at 11:30 am

    #913367

  • RE: Is Attach db the same as a Restore?

    extremenovice (12/16/2008)

    So if this is the case then could the mdf and ldf files be attached as a new db?

    Of the current DB, or of one of the backed up...

    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

    December 16, 2008 at 11:25 am

    #913361

  • RE: Restore Error SQL 2000 to SQL 2005

    Lee Hart (12/16/2008)

    In the event of a failure, you can't "backup the log tail"

    Depends on the disaster. If the log drive is accessible and SQL is running, you can.

    HOW...

    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

    December 16, 2008 at 11:12 am

    #913348

  • RE: Is Attach db the same as a Restore?

    Did you restore over the existing database, or alongside?

    Did you make copies of the old mdf and ldf before the restore?

    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

    December 16, 2008 at 11:09 am

    #913346

Viewing 15 posts - 42,316 through 42,330 (of 49,552 total)