Forum Replies Created

Viewing 15 posts - 46,441 through 46,455 (of 49,552 total)

  • RE: Terabyte database backup/restore

    Gordon (5/21/2008)

    Gila Monster, do you use multiple backup files, and if so how many?

    Not at the moment, though we are considering it. Right now we only have a single...

    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 21, 2008 at 1:46 pm

    #818848

  • RE: TOP vs ROW_NUMBER

    Grant Fritchey (5/21/2008)

    Yeah. I'm actually working on comparing MAX, TOP and ROW_NUMBER. I was hoping to outline which might be better when.

    A worthy investigation. I look forward to your results.

    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 21, 2008 at 1:30 pm

    #818835

  • RE: The query processor could not produce a query plan because a worktable is required, and its minimum row size exceeds the maximum allowable of 8060 bytes. A typical reason why a worktable is required is a GROUP BY or ORDER BY clause in the query. If the query has a GROUP BY or ORDER BY clause, co

    If you can post the query and the definitions of the tables involved, we may be able to help.

    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 21, 2008 at 1:28 pm

    #818833

  • RE: Cursors and Indexes

    From the sound of things, the inner cursor may be removable. Can you post just that bit 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 21, 2008 at 1:27 pm

    #818832

  • RE: Avoid Trigger!! If you are a good DB developer!!

    Jack Corbett (5/21/2008)

    The only reason I put things in a trigger instead of a proc is to protect me from me. Most triggers I use are "audit" or change...

    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 21, 2008 at 11:34 am

    #818764

  • RE: Terabyte database backup/restore

    Grab one of the 3rd party backup solutions that offer compression. Most of the time of the backup is writing the backup out to disk/tape. I use LiteSpeed. There are...

    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 21, 2008 at 11:27 am

    #818762

  • RE: Clustered Indexes

    Just on account should be fine. The clustering key is always present in all nonclustered indexes as the rows 'address'. Queries that filter on both, or just on country 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

    May 21, 2008 at 10:36 am

    #818725

  • RE: WITH (NOLOCK)

    Steve Jones - Editor (5/21/2008)

    The page split thing is an interesting one and it makes sense. You're allowing read of dirty data and page splits, and re indexing, would have...

    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 21, 2008 at 10:24 am

    #818714

  • RE: Clustered Indexes

    knowlton (5/21/2008)

    If I say, SELECT * FROM DATA WHERE COUNTRY = 'Mexico' and ACCOUNT = 1000, #1 would hit COUNTRY first (which could be hundreds), get everything for Mexico (which...

    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 21, 2008 at 10:09 am

    #818701

  • RE: maximum sql connection reached '1'

    Could the server be in single user mode? Check the SQL error log.

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

    #818572

  • RE: Data not comitting ?

    I look forward to the explaination. :hehe:

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

    #818566

  • RE: WITH (NOLOCK)

    WITH (NOLOCK) = WITH (Occationally_Inconsistant_Data) 🙂

    Nolock is something you use if you don't mind seeing dirty data, potantially missing rows and possibly reading rows twice. It's probably fine for long-running...

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

    #818564

  • RE: Office backend db and Online db Synchronization

    Duplicate post. Please do not reply to this.

    http://www.sqlservercentral.com/Forums/Topic504304-291-1.aspx

    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 21, 2008 at 6:07 am

    #818497

  • RE: Sparse files in SQL 2005

    SQL data and log files are not sparse. Snapshot data files are. Make sure you give your snapshot files a distinctive name (not .mdf) so you can easily distinguish them...

    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 21, 2008 at 5:59 am

    #818492

  • RE: Avoid Trigger!! If you are a good DB developer!!

    They extend the length of transactions, the increase the chance of deadlocks, and most people don't know how to write one. 😉

    Do whatever you need to in the proc before...

    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 21, 2008 at 5:52 am

    #818490

Viewing 15 posts - 46,441 through 46,455 (of 49,552 total)