Forum Replies Created

Viewing 8 posts - 16 through 24 (of 24 total)

  • RE: Different Execution Plan on different servers

    Oh wow I didn't notice I think I was looking at your last login date as the time it was posted. I'm pretty sure that isn't my issue I'm...

    I don't always test my SQL scripts, but when I do, I test in Production.

    September 4, 2013 at 6:58 am

    #1647279

  • RE: Different Execution Plan on different servers

    I am having a very similar issue as I prepare to migrate to a new server. Trying to do some testing I do basically a select top 10000 *...

    I don't always test my SQL scripts, but when I do, I test in Production.

    September 3, 2013 at 11:55 am

    #1647119

  • RE: How much data have you replicated with Transactional Replication?

    I would like to thank everyone for their replies. The purpose is for reporting and on many tables I tried to filter by date to limit size. Of course...

    I don't always test my SQL scripts, but when I do, I test in Production.

    February 12, 2013 at 7:03 am

    #1586992

  • RE: Partitioning in SQL Server 2008

    I have been looking for some info on A.) Putting my most recent data and indexes in the partitioned table on SSD drives. B.) You touched on using Partitioned...

    I don't always test my SQL scripts, but when I do, I test in Production.

    September 25, 2012 at 1:22 pm

    #1542049

  • RE: Msg 0, Level 11, State 0, Line 0 when I reog indexes

    Hi again. I was wondering if you know of a way of predicting the space needed to run DBCC checks?

    DBCC list the estimate only but this doesn't...

    I don't always test my SQL scripts, but when I do, I test in Production.

    August 29, 2011 at 3:51 pm

    #1374757

  • RE: Msg 0, Level 11, State 0, Line 0 when I reog indexes

    I don't currently have anywhere with that much space to restore to. (Were a pretty small company. ) Our development version of the DB isn't as large....

    I don't always test my SQL scripts, but when I do, I test in Production.

    August 23, 2011 at 7:52 am

    #1372007

  • RE: Msg 0, Level 11, State 0, Line 0 when I reog indexes

    Ok thanks for your response I do very much appreciate it. I do realize I need to do this but I cannot do it at this time and the...

    I don't always test my SQL scripts, but when I do, I test in Production.

    August 23, 2011 at 6:07 am

    #1371914

  • RE: Msg 0, Level 11, State 0, Line 0 when I reog indexes

    This is the full message

    Msg 0, Level 11, State 0, Line 0

    A severe error occurred on the current command. The results, if any, should be discarded.

    Thanks for your response.

    I don't always test my SQL scripts, but when I do, I test in Production.

    August 23, 2011 at 5:56 am

    #1371901

Viewing 8 posts - 16 through 24 (of 24 total)