Forum Replies Created

Viewing 15 posts - 151 through 165 (of 470 total)

  • RE: High Availability Upgrades

    Markus (3/2/2012)

    The one big difference is the cost will go up based on cores.

    That depends on the number of cores. They priced it so that if each proc has...

    March 2, 2012 at 7:41 am

    #1454173

  • RE: xp_sendmail not sending @message text

    That's probably what did it for us. I found out that they did some mailbox moves this week and the account is currently on the new server. The...

    March 2, 2012 at 7:35 am

    #1454170

  • RE: xp_sendmail not sending @message text

    I'm running into this too. In my case it's an existing process on a SQL 2000 SP4 box that started erroring sending mail (no error messages that appear useful)....

    February 29, 2012 at 11:56 am

    #1453326

  • RE: Model Database

    mtassin (2/22/2012)

    tilew-948340 (2/22/2012)

    Question: if you restart an engine SQL server 2008 R2 with its model set to read-only, would the model stays read-only or it return automatically to its default?

    I...

    February 22, 2012 at 9:00 am

    #1450385

  • RE: Model Database

    Hugo Kornelis (2/22/2012)

    bitbucket-25253 (2/22/2012)

    Seems like a lot of people are learning something new.

    Correct answers: 30% (98)

    Incorrect answers: 70% (234)

    Total attempts: 332

    I'd rather say that almost half the...

    February 22, 2012 at 7:43 am

    #1450295

  • RE: The Success Trap

    My last job was a DBA Developer job in which I didn't get to do much administration work. Between DB escalations from clients and reading and researching things I...

    February 21, 2012 at 7:14 am

    #1449688

  • RE: Indexed Views

    Hugo Kornelis (2/10/2012)

    If you use an index hint without NOEXPAND, I'm not sure what would happen. It might depend on the edition, but I have no time to test this...

    February 10, 2012 at 11:38 am

    #1445711

  • RE: Encryption in Production

    Jack Corbett (2/10/2012)

    I haven't used TDE or really any encryption in SQL Server. I prefer to have column level encryption done at the application level. I...

    February 10, 2012 at 9:47 am

    #1445670

  • RE: Indexed Views

    sknox (2/10/2012)

    Hugo Kornelis (2/10/2012)

    I hate questions where I have to second-guess the author. Did the author mean that the optimizer would choose to use the indexed view automatically? Or did...

    February 10, 2012 at 9:38 am

    #1445664

  • RE: TRUNCATE TABLE and ROLLBACK TRAN

    GilaMonster (2/6/2012)

    Is it bad form, if you create a QotD, to list your own article as a reference?

    It's probably better to find another one just so there's input from two...

    February 6, 2012 at 9:00 am

    #1443230

  • RE: SET option hierarchy

    zerko (2/1/2012)

    OK now I'm really confused

    I'm guessing you didn't read the thread. Any time there's something wrong in the question it gets discussed thoroughly. If you read through...

    February 2, 2012 at 4:16 am

    #1441657

  • RE: SET option hierarchy

    KWymore (2/1/2012)

    Hopefully this experience has not dissuaded the QoTD author from submitting further questions.

    I hope not. It was a question on something I hadn't really thought about much. ...

    February 1, 2012 at 10:45 am

    #1441335

  • RE: SET option hierarchy

    KWymore (2/1/2012)

    I was going to choose All of the Above but then re-read the answers and thought that "All" could not be right since there were 2 answers that were...

    February 1, 2012 at 10:27 am

    #1441324

  • RE: Fun with sp_executeSQL

    pbarbin (1/31/2012)

    ...what might be worth researching is index usage. When the parameter datatype given doesn't match the datatype of the column that it's being compared to, I am pretty...

    January 31, 2012 at 1:14 pm

    #1440941

  • RE: Fun with sp_executeSQL

    David.Poole (1/31/2012)

    Christoph Muthmann (1/31/2012)

    Nice article, but I'm missing a hint to adhoc queries and their influence on the proc cache. You can save a lot of memory by using the...

    January 31, 2012 at 9:48 am

    #1440767

Viewing 15 posts - 151 through 165 (of 470 total)