Forum Replies Created

Viewing 15 posts - 4,546 through 4,560 (of 8,416 total)

  • RE: An interesting thing about isnull

    I think my 'distinctly dodgy' comment warrants a little expansion :blush:

    AFAIK, SQL Server has never set out to guarantee anything about a query behaving as if it occurred all-at-once at...

    March 31, 2010 at 8:58 am

    #1143152

  • RE: TRUNCATE

    Peter Trast (3/31/2010)

    Hey, people from middle earth can't boo! 😀

    Middle Earth, if you please 😛

    March 31, 2010 at 8:51 am

    #1143147

  • RE: An interesting thing about isnull

    Hugo Kornelis (3/31/2010)

    No. That would be possible if you use NOLOCK or READ_UNCOMMITTED, but not at the default level (READ_COMMITTED).

    I know you know this! It has been blogged many...

    March 31, 2010 at 8:42 am

    #1143142

  • RE: Declarative Data Integrity

    Tom.Thomson (3/31/2010)

    Well, I like T-SQL and this one made my head hurt too: not the question, but the explanation! How can those constraints ever prevent any deletes?

    C'mon Tom...let it go!...

    March 31, 2010 at 8:35 am

    #1143137

  • RE: SSMS - feature

    Peter Trast (3/31/2010)

    If you wait long enough, it should turn into a hand. I only saw it when I went back after being told about it. It took 5 to...

    March 31, 2010 at 8:25 am

    #1143128

  • RE: TempDB Settings

    TheSQLGuru (3/31/2010)

    You are not alone in the Sharepoint feelings. The 'softies that developed the architecture and database schema/processes for that were horrible and clearly screwed the pooch in many...

    March 31, 2010 at 8:22 am

    #1143125

  • RE: Today's Random Word!

    tosscrosby (3/31/2010)

    wombat

    Can't bat

    (NZ cricket team)

    March 31, 2010 at 8:19 am

    #1143120

  • RE: TRUNCATE

    Peter Trast (3/31/2010)

    Paul White NZ (3/31/2010)

    vk-kirov (3/31/2010)

    Nice find, thank you. So, if it barks like a dog, it behaves like a dog, what is it?...

    It is a duck, with...

    March 31, 2010 at 8:19 am

    #1143118

  • RE: Full backup Scenario

    Thank you, Peter. Of course, there are some edge cases and subtleties, but unless Mr Randal appears and tells me I know nothing about nothing...I'm happy with it.

    March 31, 2010 at 8:18 am

    #1143115

  • RE: An interesting thing about isnull

    Hugo Kornelis (3/31/2010)

    I would agree that, depending on transaction isolation level and @@TRANCOUNT, the results of the three statements might be different on a busy server. But for your code,...

    March 31, 2010 at 8:14 am

    #1143111

  • RE: TempDB Settings

    TheSQLGuru (3/31/2010)

    In general tlogs should not be with data due to a) the importance of tlog throughput and b) different nature of data access between data and log files

    True, true,...

    March 31, 2010 at 7:54 am

    #1143088

  • RE: Deadlock between two read-only Stored Procedures

    PhilPacha (3/31/2010)

    Thanks, Paul!

    Sounds like it might have helped...if so, that's great news.

    I love foreign key relationships, they produce such interesting behaviours.

    March 31, 2010 at 7:51 am

    #1143083

  • RE: Are the posted questions getting worse?

    Jack Corbett (3/31/2010)

    Now calling me Jacqui or Jackie or Jacquelyn. Those may cause me to hunt you down.:-P

    Heh heh heh 😉

    March 31, 2010 at 7:47 am

    #1143080

  • RE: An interesting thing about isnull

    Hugo Kornelis (3/31/2010)

    That is caused by a related and similar reason. This "simple" CASE is also defined in ANSI in terms of the "searched" CASE (and apparently implemented in this...

    March 31, 2010 at 7:45 am

    #1143078

  • RE: Resize Transaction Log Default Size to Less Than It's Current Size

    HowardW (3/31/2010)

    ...but if the database was detached, which is an operation that can only occur after all users have been killed/disconnected and their transactions committed/rolledback, in what scenario can there...

    March 31, 2010 at 7:26 am

    #1143065

Viewing 15 posts - 4,546 through 4,560 (of 8,416 total)