Forum Replies Created

Viewing 15 posts - 316 through 330 (of 334 total)

  • RE: Recovering OS file space

    The growth is due to a miscalculation on the part of "Business" to the amount of transactions they were going to see and the space is being created by the...

  • RE: Recovering OS file space

    The data file (there's only one) is 490 gigs and has 250 gigs free inside the file.

    Don

  • RE: Recovering OS file space

    What if I shrink the individual data files? Is that better or worse than shrinking the database and will that give me back my free space?

    Don

  • RE: Recovering OS file space

    I was afraid that would be the answer. 🙁

    Don

  • RE: Faster way to do Top N Order By Desc?

    Thanks, Celko, I'll take a look at that structure as well.

    Don

  • RE: Faster way to do Top N Order By Desc?

    How can I take out the coalesce when it's possible to have a null value there?

    I'll look at the covering index though, that would be a good place to start.

  • RE: Faster way to do Top N Order By Desc?

    The table is 2.5 million rows.

    Following is the entire query. If you can suggest a better method I would appreciate it.

    SELECT TOP 1000

    OM.OutID,

    OM.MNumber,

    OM.SCode,

    OM.LDateTime,

    OM.Mess,

    OM.CID,

    OM.Cype,

    COALESCE(OM.Op,dbo.LookupCarrierFunc(OM.MNumber)) Operator,

    SCG.Gateway

    FROM OutMess OM

    INNER JOIN View_SCodeCarGate SCG ON...

  • RE: Extract T-SQL from transaction logs

    Sigh, sometimes I feel very far out of my depth.

    I'll look into querying the plan cache, thank you.

    Don

  • RE: Difficulty exporting table

    Thanks all. What I gather from the responses is that there really isn't a faster way to move/copy the table.

    For example, in MySQL I could just go into the operating...

  • RE: Difficulty exporting table

    Derrick,

    Unfortunately, we've grown out of control on the production database (happened before I came on board) and we can't replicate it due to storage issues.

    Alvin,

    How do you export in batches?...

  • RE: Backup/Detach/Restore

    Thank you so much for your help!

    I'm going to go with the detach, copy, and reattach. That'll leave a viable database on the first server while I'm working on the...

  • RE: Backup/Detach/Restore

    Ok, so the copy wizard is a bad idea due to the length of time it will take. Got it.

    What about the difference between backup/restore and detach/(move files to new...

  • RE: Backup/Detach/Restore

    In SQL Server 2008, could I not just use the Copy Database Wizard after setting the database to single user mode to recreate it on the new server? It's also...

  • RE: Backup/Detach/Restore

    Aha.. now I'm on the same page.

    BOL is the contextual help (F1) from MSSQL.. I just didn't make the connection between how it's commonly known and how I use it....

  • RE: Backup/Detach/Restore

    Thank you, I didn't know about the WITH MOVE option in restoring a database.

    Dumb question. Does BOL stand for Books Online? And is this the Books section of SQLServerCentral.com?

    Don

Viewing 15 posts - 316 through 330 (of 334 total)