Forum Replies Created

Viewing 15 posts - 18,556 through 18,570 (of 49,552 total)

  • RE: drive space issues trying to index 2.4TB table

    To create a clustered index on a 2.4 TB table, you need 2.4TB for the old structure (the heap), the same amount of space for the new index, around 20%...

    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

    May 11, 2012 at 9:23 am

    #1486388

  • RE: How to resolved 100% Cpu usage in sqlserver

    Chapter 3: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    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

    May 11, 2012 at 5:24 am

    #1486205

  • RE: Cannot specify partition number in the alter index statement as the index is not partitioned

    Confirm what? The error told you clearly the table is not partitioned, you can also check that yourself by looking at whether there are any partition schemes and whether 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

    May 11, 2012 at 5:22 am

    #1486203

  • RE: SQL 2008 Certifications worth it with SQL 2012 Exams going live soon?

    The 2008 exams are only writable until that date, they don't expire if you've written it.

    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

    May 11, 2012 at 4:22 am

    #1486188

  • RE: query

    sachince61 (5/11/2012)

    Sorry i havent any logic ....

    Really? So any two customerIDs on the same line, like this?

    mnemonicId customerID xyz

    1402 140201 140202

    1402 140203 140201

    1402 140202 140201

    ?

    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

    May 11, 2012 at 1:06 am

    #1486117

  • RE: password issue

    pnpsql (5/10/2012)

    now there is some module enhancement where we need that when user does not login for 3 dayus then its account is locked

    One concern there... What about 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

    May 11, 2012 at 12:36 am

    #1486110

  • RE: query

    What is the logic 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

    May 11, 2012 at 12:30 am

    #1486108

  • RE: microsoft support - http://support.microsoft.com/lifecycle/search/?sort=PN&alpha=SQL

    chewychewy (5/9/2012)

    Does it means to get extended support till 2016, we will need to have the latest service pack applied?

    Latest service pack, a premier contract and an extended support...

    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

    May 11, 2012 at 12:24 am

    #1486107

  • RE: Are the posted questions getting worse?

    Barry!!!!!!

    Welcome back. How ya been?

    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

    May 10, 2012 at 1:02 pm

    #1485919

  • RE: Need T-SQL for this requirment

    Then the best I can do is guess and give you code that probably won't work as desired.

    Select ServerName, DatabaseName, Size

    FROM (

    Select ServerName, DatabaseName, Size, RowNumber() Over (Partition by...

    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

    May 10, 2012 at 11:25 am

    #1485857

  • RE: Need T-SQL for this requirment

    Can you post the table definition please?

    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

    May 10, 2012 at 11:13 am

    #1485852

  • RE: Avg Disk Queue Length

    Ignore queue length. It's hard to interpret on anything more complex than a direct attached disk and SQL can and will intentionally drive the disk queue length high during normal...

    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

    May 10, 2012 at 10:41 am

    #1485840

  • RE: Cannot specify partition number in the alter index statement as the index is not partitioned

    There are 70 pages in that table. That's not going to defrag and it's not worth worrying about. The point that you should probably be worrying about fragmentation is 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

    May 10, 2012 at 10:19 am

    #1485830

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (5/9/2012)

    Is this an Oracle thing?

    No, don't touch that myself.

    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

    May 9, 2012 at 11:37 pm

    #1485466

  • RE: CLR TYPES AND SQL TYPES

    Please note: 3 and a half year old thread.

    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

    May 9, 2012 at 11:34 pm

    #1485465

Viewing 15 posts - 18,556 through 18,570 (of 49,552 total)