Forum Replies Created

Viewing 15 posts - 12,286 through 12,300 (of 39,804 total)

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (6/13/2013)


    Brandie Tarvin (6/13/2013)


    The Dixie Flatline (6/13/2013)


    Don't talk to me about time. Time is my business.

    Dixie, I could kiss you for this. @=)

    By the way, does...

  • RE: Verify multiple bak files via tsql

    The error is what it says, you are missing part of the media family. This is a striped backup, and you can do this natively in SQL Server.

    In Backup Pro,...

  • RE: Questions on resources and removing instances

    A few thoughts here.

    I have no idea on the uninstall and active v in active licenses. I would guess that it's installed licenses, so there is no concept of active/inactive...

  • RE: Transaction log size far exceeds database size when running delete

    Eric M Russell (6/12/2013)


    Deleting rows in chunks is the way to go, but you also need to perform a checkpoint and transaction log backup between each iteration. That will insure...

  • RE: sql service startup account

    I would suspect that the service account needs sysadmin rights in order to execute all the method/function calls inside SQL Server, but I can't find documentation on this page:

    http://msdn.microsoft.com/en-us/library/ms143504.aspx

    The only...

  • RE: 3 instances of SQL on 1 vm VS 3 separate vm's

    I like separate VMs. You can better control resource usage, and more importantly, if you are overloaded, move one or more to a new physical host.

  • RE: urgent help with stored procedure performance tuning

    We can help, but you need to do some work. Mock up tables. Give us CREATE TABLE statements for the columns needed in the query for all tables. Give us...

  • RE: Need a help in backup Encyption Certificate

    The server account needs full control.

    If you remove your path and do the backup, you should find the cert in your SQL Server's \data folder. However the cert (and private...

  • RE: No R2

    Eric M Russell (6/12/2013)


    TravisDBA (6/12/2013)


    Clouds eventually move on, like a lot of fads tend to do.:-D

    Cloud services are to SQL Server what web services are (or were) to application development....

  • RE: Are the posted questions getting worse?

    jasona.work (6/12/2013)


    I have to wonder how often Gail and the other pros here get frustrated with people asking questions where the answer is in the message SQL spit out?

    Speaking for...

  • RE: Data Vision

    lshanahan (6/12/2013)


    We all make mistakes, and may never catch all our errors in testing, but we damn sure better catch our stupidity. Not checking the input data before processing...

  • RE: No R2

    chrisn-585491 (6/11/2013)


    It takes IT several months to get and set up a server, even if the budget is approved.

    Really? Depending on the server it takes us days, at most, once...

  • RE: No R2

    chrisn-585491 (6/11/2013)


    I can see a scenario where organizations turn to cloud based services to host their e-commerce database or quickly spin up some one-off analytical solution requested by management.

    That's about...

  • RE: The Watson Service

    MiguelSQL (6/11/2013)


    I wonder how many will attempt a Turing test with your next representative. Considering my experiences with some customer service, it wouldn't be a bad idea

    I agree....

  • RE: Does a backup cause TempDB to grow

    The check backup integrity shouldn't matter, but I think Gail is thinking that if you have a DBCC check of some sort (verify database integrity), this could be using tempdb...

Viewing 15 posts - 12,286 through 12,300 (of 39,804 total)