Forum Replies Created

Viewing 15 posts - 376 through 390 (of 454 total)

  • RE: Replication

    send2vic (5/12/2010)

    According to msdn it is supported in SQL Server Enterprise 2005

    "Peer-to-peer replication is available only in SQL Server 2005 Enterprise Edition."

    http://msdn.microsoft.com/en-us/library/ms151196(SQL.90).aspx

    This is true. But since the question...

    May 12, 2010 at 7:25 am

    #1166183

  • RE: Play with NULLIF

    Paul White NZ (5/3/2010)

    @sknox:

    I laughed when I saw Hugo's :Whistling: reply.

    Paul

    So did I ... AFTER I'd already posted my reply. Oh, the wonders of asynchronous operations!

    May 4, 2010 at 7:24 am

    #1161778

  • RE: Play with NULLIF

    Paul White NZ (5/3/2010)

    Hugo Kornelis (5/3/2010)

    Using ISNULL can work around this - although the result is admittedly not trivial to understand:

    AND NULLIF(Column1, Column2) IS NULL

    AND NULLIF(Column2, Column1) IS NULL

    :w00t: ...

    May 3, 2010 at 10:15 am

    #1161374

  • RE: Optimising Server-Side Paging - Part I

    Good article. One thing I noticed is that you're using a contiguous identity for your tests, but relying on ROW_NUMBER() for the paging.

    I'm assuming that ROW_NUMBER() is used because you're...

    April 26, 2010 at 7:40 am

    #1157618

  • RE: SQL Server 2008 Compression

    David Walker-278941 (4/22/2010)

    sknox (4/22/2010)

    This is also why (I believe) the compression results in faster backup and access times -- the bottleneck in this particular test is the disk array.

    I think...

    April 23, 2010 at 8:32 am

    #1156900

  • RE: SQL Server 2008 Compression

    David Walker-278941 (4/22/2010)

    This is confusing: "As you can see from the disk bytes/sec counter, there is a considerable savings caused by both row and page level compression, with the page...

    April 22, 2010 at 10:35 am

    #1156297

  • RE: Using IDENTITY as a key column

    JT-361866 (4/20/2010)

    The first part of the question was fine, but the second "SQL Server does not have an efficient way to retrieve rows based on a known value for PersonID."...

    April 20, 2010 at 9:23 am

    #1154691

  • RE: Using IDENTITY as a key column

    Hugo Kornelis (4/20/2010)

    Tom Brown (4/20/2010)

    A Good question. I learned something from this.

    I've used IDENTITY for ages, assuming its both duplicate-proof and automatically indexed.

    I'm glad to have...

    April 20, 2010 at 7:54 am

    #1154583

  • RE: NULL

    The answer is simply answering a different question than the one given. The given question is "What does NULL mean?", not "What is result of a test with a NULL...

    April 13, 2010 at 7:54 am

    #1150731

  • RE: ANSI_NULLS

    Paul White NZ (4/7/2010)

    honza.mf (4/7/2010)

    There is only one complication with negative queries I mentioned above. Easy to solve but hard to explain to (some) non-developpers. "I want to see all...

    April 7, 2010 at 12:27 pm

    #1147672

  • RE: Column length

    In SQL Server 2005 the IsNull() function will truncate the length of replacement_value to that of check_expression.

    This explanation feels a little light. For completeness, it should include the behavior...

    April 6, 2010 at 8:15 am

    #1146512

  • RE: An interesting thing about isnull

    Paul White NZ (3/31/2010)

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

    March 31, 2010 at 11:06 am

    #1143278

  • RE: SSMS - feature

    I just tested this, and got the following results:

    SSMS 2005 - popup came up "CTRL-Click to open...", CTRL-click opens in a new tab.

    SSMS 2008 - NO POPUP, CTRL-click opens in...

    March 24, 2010 at 8:04 am

    #1138936

  • RE: Expanding The Scope of Bridge Tables

    paulgrahamster (3/23/2010)

    One such rule you've built in states that no two functional areas can have a particular training course in common. Because you're linking a completed training course through the...

    March 23, 2010 at 8:36 am

    #1138259

  • RE: Answers to Your QOD

    As I see it, the person who composes a QOD is responsible for giving a full effort towards the accuracy of the answers and explanation. The general community of SSC...

    March 19, 2010 at 10:13 am

    #1136863

Viewing 15 posts - 376 through 390 (of 454 total)