Forum Replies Created

Viewing 15 posts - 42,676 through 42,690 (of 49,552 total)

  • RE: Ambiguous field name error

    The query I posted runs fine on 2005 SP2 and 2008 RTM.

    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 2, 2008 at 10:02 am

    #906341

  • RE: varchar versus nvarchar

    Carla Wilson (12/2/2008)

    So I was wondering what the general consensus is on using varchar versus nvarchar, especially for longer strings. Is it considered best practice to always use nvarchar,...

    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 2, 2008 at 9:58 am

    #906335

  • RE: Data File Spilit accross various Drives. One is running out of space.

    Are the data files all in the same filegroup or are they in different filegroups?

    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 2, 2008 at 9:52 am

    #906330

  • RE: SQL stored procedure that calls multiple stored procedures in one dataset

    Basically, yes. So your proc that calls other procs would be something like

    CREATE Procedure blah (@blah)

    AS

    EXEC MyPRoc1

    EXEC MyPRoc2

    EXEC MyPRoc3

    EXEC MyPRoc4

    ...

    If the procs can fail and throw errors, you need 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 2, 2008 at 9:51 am

    #906327

  • RE: Parallelism

    Mark Kinnear (12/2/2008)

    My confusion is this..

    1.) Are the remaining 8 Cpu's being used in query executions run in series or are they idle?

    Setting the degree of parallelism to 8...

    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 2, 2008 at 9:50 am

    #906325

  • RE: The Fear of Change

    mhaskins (12/2/2008)

    The question may be more: will one future DBA now be able to handle the job of more than one current DBA?

    Probably. But the number and size of servers...

    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 2, 2008 at 9:39 am

    #906310

  • RE: Ambiguous field name error

    Grant Fritchey (12/2/2008)

    The old parser would also let you refer to columns by the table alias and the new one does not.

    You mean like this, or something else?

    select title, FirstName...

    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 2, 2008 at 9:22 am

    #906294

  • RE: Basic Optimum Performance setup

    Shark Energy (12/2/2008)

    I have a 10 disk RAID 5 setup. Would performance be better splitting to 2 arrays of 5 and logs and data split between the 2?

    Honestly, it would...

    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 2, 2008 at 9:21 am

    #906293

  • RE: disable shutdown button

    leonvr (12/2/2008)

    For BI I want read-only permissions on all sqlserver databases on a server. We will get this done. The problem is however that I have right to (accidentelly) shut...

    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 2, 2008 at 7:54 am

    #906238

  • RE: MCTS and next step

    Up to you. There's only a difference of 1 exam (and, of course, all the studying needed).

    2 exams to get ITP (2005) and then 1 to get both TS...

    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 2, 2008 at 7:51 am

    #906237

  • RE: MCTS and next step

    You've got two options to get the 2008 exams.

    Finish your 2005 ITP (2 exams) and then write an upgrade exam to get both the MCTS (Implementing and Maintaining) and 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

    December 2, 2008 at 7:28 am

    #906218

  • RE: RAID configurations

    I don't think I'd use 50. It'll have the same problem as 5 - poor write performance due to the parity stripe. Each write may incur up to ((no 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

    December 2, 2008 at 6:50 am

    #906195

  • RE: Basic Optimum Performance setup

    You say partitioned. How many physical drives are we talking here? Raid? SAN?

    If you want perfect...

    Log file on RAID 10 dedicated array

    Data file on RAID 10 (preferably) RAID 5 (acceptable)...

    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 2, 2008 at 6:44 am

    #906189

  • RE: Translactional log growing prediction

    Tran log growth is hard to predict. As well as the data, there are log headers, internal allocation pages that need logging, etc. Plus, if there was other stuff also...

    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 2, 2008 at 6:38 am

    #906185

  • RE: High Performance System Active/Active Clustering

    Linked servers and remote queries are an excellent way to slow things down.

    Why do you want to split the DB up? If the hardware is correct, the design is good...

    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 2, 2008 at 6:36 am

    #906183

Viewing 15 posts - 42,676 through 42,690 (of 49,552 total)