Forum Replies Created

Viewing 15 posts - 13,411 through 13,425 (of 49,552 total)

  • RE: Moving data from one mdf to multiple ndf files

    smitty-1088185 (4/19/2013)

    I have a database with one 110g mdf file. I would like to stripe the I/O across five 25g files and purge the data out of the 110g file...

    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

    April 19, 2013 at 7:40 am

    #1608215

  • RE: How to get these details in sqlserver

    1 and 7 - google "performance monitor"

    2 and 3, google "query plan cache stats" or "SQL profiler"

    4 google "catalog views"

    5 google "index fragmentation DMV"

    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

    April 19, 2013 at 7:38 am

    #1608213

  • RE: working with sql server 2008 R2

    What's New (SQL Server 2008 R2) - http://msdn.microsoft.com/en-us/library/bb500435%28v=sql.105%29.aspx

    As for how you install it, buy a licence, get the DVD or iso, run the installer. Same way you'd install SQL 2008.

    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

    April 19, 2013 at 7:36 am

    #1608210

  • RE: can we give a copy of a database to someone and it be packaged in such a way so that they cannot see the table structure / design?

    No.

    Give someone a database and you're giving them full and complete control over the schema and data.

    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

    April 19, 2013 at 3:48 am

    #1608128

  • RE: CXPACKET

    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

    April 19, 2013 at 2:56 am

    #1608119

  • RE: Short Circuit in sql Server!!!

    Same answer. Those queries do the same number of reads because they're doing table scans, there's no useful indexes. SQL has to read every single row of every page 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

    April 19, 2013 at 2:14 am

    #1608109

  • RE: CXPACKET

    Firstly, are those waits a problem? Do you have excessively high CPU usage that is hindering performance.

    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

    April 19, 2013 at 2:10 am

    #1608107

  • RE: Deadlock

    Lock request timeout will not be caused by a deadlock.

    You can look in the system health extended events session to see if you have had any deadlocks, but I suspect...

    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

    April 19, 2013 at 2:09 am

    #1608106

  • RE: CXPACKET wait type

    Please post new questions in a new thread. Thanks

    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

    April 19, 2013 at 1:29 am

    #1608098

  • RE: Short Circuit in sql Server!!!

    No, SQL Server does not do reliable position-based short circuiting of expressions. The order things will be evaluated in depends on indexes, data distribution, estimated row counts and whatever 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

    April 19, 2013 at 1:28 am

    #1608097

  • RE: Restoring file group error

    Developer edition is exactly the same as Enterprise, just with restricted licensing.

    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

    April 19, 2013 at 1:23 am

    #1608094

  • RE: No performance gain on queries on different servers with considerable hardware change

    wolfkillj (4/18/2013)

    GilaMonster (4/15/2013)

    To expand on that, I've seen a database's performance dramatically decrease after an upgrade from a single processor server to an 8-core with lots more memory. The code...

    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

    April 18, 2013 at 3:05 pm

    #1608018

  • RE: Asking for Interview Questions

    Eric M Russell (4/18/2013)

    GilaMonster (4/18/2013)

    Where I live, even asking a candidate to sign an at-will contract can get the company hauled up before the labour board and fined heavily, severance...

    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

    April 18, 2013 at 1:38 pm

    #1607986

  • RE: index scan

    http://www.sqlservercentral.com/articles/Indexing/68439/

    http://www.sqlservercentral.com/articles/Indexing/68563/

    http://www.sqlservercentral.com/articles/Indexing/68636/

    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

    April 18, 2013 at 1:25 pm

    #1607983

  • RE: Asking for Interview Questions

    Where I live, even asking a candidate to sign an at-will contract can get the company hauled up before the labour board and fined heavily, severance pay or no severance...

    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

    April 18, 2013 at 12:05 pm

    #1607937

Viewing 15 posts - 13,411 through 13,425 (of 49,552 total)