Forum Replies Created

Viewing 15 posts - 12,421 through 12,435 (of 39,936 total)

  • 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...

    June 12, 2013 at 1:32 pm

    #1623486

  • 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...

    June 12, 2013 at 1:28 pm

    #1623485

  • 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.

    June 12, 2013 at 1:15 pm

    #1623480

  • 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...

    June 12, 2013 at 1:13 pm

    #1623479

  • 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...

    June 12, 2013 at 1:11 pm

    #1623478

  • 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....

    June 12, 2013 at 1:09 pm

    #1623476

  • 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...

    June 12, 2013 at 1:05 pm

    #1623473

  • 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...

    June 12, 2013 at 8:49 am

    #1623380

  • 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...

    June 11, 2013 at 1:47 pm

    #1623129

  • 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...

    June 11, 2013 at 11:42 am

    #1623080

  • 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....

    June 11, 2013 at 11:37 am

    #1623075

  • 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...

    June 10, 2013 at 4:50 pm

    #1622659

  • RE: No R2

    chrisn-585491 (6/10/2013)

    People reject public "clouds" for very good reasons.

    You forgot some. Some people reject this. Lots don't. I suspect a majority of companies/situations are not using cloud services, but...

    June 10, 2013 at 11:12 am

    #1622551

  • RE: No R2

    Eric M Russell (6/10/2013)

    My understanding that that the SQL Azure branch is being folded back into the SQL Server codebase, and going forward the same release of SQL Server /...

    June 10, 2013 at 8:40 am

    #1622470

  • RE: No R2

    Seed Vicious (6/10/2013)

    and SQL2008 RTM will be discontinued?:w00t:

    Support will wane next year. However given that in April 2014 this will be 5 years old, that's expected.

    June 10, 2013 at 8:38 am

    #1622469

Viewing 15 posts - 12,421 through 12,435 (of 39,936 total)