Forum Replies Created

Viewing 15 posts - 44,086 through 44,100 (of 49,552 total)

  • RE: Clustering vs. Mirroring, and Maybe Load Balancing?

    Clustering's good when you need redundancy for the entire server, not just a single databases.

    Mirroring happens at the database level, so if the app depends on resources outside of 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

    October 1, 2008 at 8:55 am

    #879530

  • RE: Query Tuning in TSQL

    Sandy (10/1/2008)

    Yes Gail,

    I do agree with you for both the point you specified in above post.

    Yeah, but table variables are treated the same in terms of the TempDB system tables...

    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

    October 1, 2008 at 8:49 am

    #879524

  • RE: CHECKPOINT killing our production box

    Mark Kinnear (10/1/2008)

    So if the recovery interval is increased, would that have a bad effect on the Db?

    It would mean that recovery would take longer, in the case where 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

    October 1, 2008 at 8:43 am

    #879517

  • RE: Baffled by Indexes

    Depends on how the tables are been used. If many of the queries are of the form

    SELECT A, B, C, E, F, G, H, N FROM [TableName] WHERE A =...

    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

    October 1, 2008 at 2:15 am

    #879346

  • RE: SQL 2000 EM "features" missing in 2005 SSMS?

    WayneS (9/30/2008)

    I have SS 2005 (Dev) on my computer. I frequently need to connect to a SS 2000 server. I've noticed a couple of things that I could do in...

    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

    October 1, 2008 at 2:07 am

    #879343

  • RE: Query Tuning in TSQL

    Sandy (9/30/2008)

    Gail & Meely,

    I think Gail can better answer for this,

    I wanted to know your thoughts on why table variables were better than temp tables for 'highly transactional' workloads....

    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

    October 1, 2008 at 2:01 am

    #879342

  • RE: My first attempt at a simple AFTER INSERT TRIGGER fails on SELECT from INSERTED

    Jack Corbett (9/30/2008)

    I'm glad I don't have the experience necessary to have known that. Then it would mean I had had to deal with major problems and who wants...

    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

    October 1, 2008 at 1:55 am

    #879341

  • RE: SQL Server 64 bit

    Scott Ohar (9/30/2008)

    DTSRun isn't support on a 64 bit platform according to a few blogs, but if that's the case they can be wrapped around an ssis package to excute...

    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

    October 1, 2008 at 1:48 am

    #879339

  • RE: database physical design

    Only in terms of reducing blocking on the allocation pages of TempDB.

    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

    September 30, 2008 at 2:09 pm

    #879153

  • RE: SQL Server 64 bit

    That's a huge machine. The largest I've ever played with was a 16 proc box with 64 GB memory.

    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

    September 30, 2008 at 2:08 pm

    #879152

  • RE: Is this article correct? Temp Tables vs. Table Variables in SQL Server 2005

    Clay.Angelly (9/30/2008)

    I think we'll shelve SQL Server 2005 for now and see if SQL Server 2008 handles this any differently.

    Looking at the code you have, not likely. 2008, in...

    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

    September 30, 2008 at 2:07 pm

    #879151

  • RE: Is this article correct? Temp Tables vs. Table Variables in SQL Server 2005

    Clay.Angelly (9/30/2008)

    @GilaMonster: Yes, the particular example we're focusing on anyway...has gone from ~50ms execution times to ~1.5 minutes since the migration to SS2005.

    Ah. Could you post that example here, along...

    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

    September 30, 2008 at 1:40 pm

    #879136

  • RE: Developement Design

    Grant Fritchey (9/30/2008)

    Not really unless you get the Team System Database Edition.

    Which is now available to any software assurance customers who have Team System for developers (and vis versa)

    http://www.microsoft.com/presspass/press/2008/sep08/09-29VS10PR.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

    September 30, 2008 at 1:23 pm

    #879126

  • RE: Help With SQL Update Query

    Sorry. 🙁

    That's what I get for posting while I'm doing something else.

    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

    September 30, 2008 at 1:20 pm

    #879125

  • RE: Edit Signature Line - Questions & How-To

    YSLGuru (9/30/2008)

    Also, how do you add a solid line below where your name would appear and above a quote you're adding to your signature?

    [ hr ] Remove the spaces 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

    September 30, 2008 at 1:20 pm

    #879122

Viewing 15 posts - 44,086 through 44,100 (of 49,552 total)