Forum Replies Created

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

  • RE: COUNT_BIG

    ravindraee24 (3/10/2010)

    why SELECT COUNT_BIG(*) not return same result????????????

    i hope:cool: 1,2,and 3 are correct

    There is an explanation by sknox on page 2 of this discussion, which clearly explains why 2 and...

    March 11, 2010 at 8:49 am

    #1132105

  • RE: Primary Keys

    Lynn Pettis (3/10/2010)

    No assumptions needed. If you look at the syntax for creating a PRIMARY KEY, the default may be to create a clustered index, but that is not...

    March 10, 2010 at 9:21 am

    #1131493

  • RE: COUNT_BIG

    sistemas 95572 (3/9/2010)

    Thank you Oleg, I am curious about uniquely identifying rows in tables w/o PKs (sorry about the off topic).

    I mean, as I understand from your explanation there is...

    March 9, 2010 at 1:32 pm

    #1130935

  • RE: COUNT_BIG

    sistemas 95572 (3/9/2010)

    Hey pal,

    what do you mean by volatile rowid from the heap?

    Check a couple of posts upstairs, i pointed out the case of a full nulled row, but wasn't...

    March 9, 2010 at 12:53 pm

    #1130904

  • RE: COUNT_BIG

    sjimmo (3/9/2010)

    Oleg,

    Thanks for the explanatin. You're right - I did not have any nulls.

    Looks like I am getting the credit I don't deserve :w00t:. The original explanation was posted by...

    March 9, 2010 at 10:49 am

    #1130820

  • RE: COUNT_BIG

    CirquedeSQLeil (3/9/2010)

    Nice explanation and test setup Oleg.

    Thank you Jason.

    I wish the day will come when somebody will explain to me how to properly format the results output when including...

    March 9, 2010 at 10:45 am

    #1130818

  • RE: COUNT_BIG

    sknox (3/9/2010)

    sjimmo (3/9/2010)

    Good question - Thought that I knew the answer, and was wrong. Now, I have a question. I ran the following against an existing database to prove/disprove the...

    March 9, 2010 at 10:21 am

    #1130802

  • RE: Sparse Columns

    ziangij (3/5/2010)

    sorry for sounding stupid, but has anybody implemented sparse in his/her code ?

    what was the reasoning behind.. is it really worth ?

    Implementation of the sparse column makes sense only...

    March 5, 2010 at 7:04 pm

    #1129526

  • RE: Counting spaces with datalength

    Fal (3/3/2010)

    benkoskysa (3/3/2010)

    ... I used a database where the sys.master_files table was empty...

    Well, it can't be empty. At the very least you can expect 8 rows from a brand-spankin'...

    March 4, 2010 at 10:27 am

    #1128616

  • RE: How many rows are returned from the query below?

    I think that this was an OK QoD, maybe a bit too easy to deduce the correct answer, but not every question of the day has to be complex. On...

    March 3, 2010 at 9:14 am

    #1127870

  • RE: Optimization

    vk-kirov (3/1/2010)

    Oleg Netchaev (3/1/2010)

    there are a couple of records inserted into the system tables when the procedure is created. The procedure name is inserted into sysobjects and the text of...

    March 1, 2010 at 2:24 pm

    #1126711

  • RE: Optimization

    vk-kirov (3/1/2010)

    skjoldtc (3/1/2010)

    If stored procedures are never saved to disk

    The explanation says that stored procedure plans are never saved to disk. Of course, stored procedures themselves are saved to disk,...

    March 1, 2010 at 9:39 am

    #1126530

  • RE: Optimization

    skjoldtc (3/1/2010)

    If stored procedures are never saved to disk, why do you have to bother compiling them? This is a misconception (or misunderstanding by me) on my part. I'm still...

    March 1, 2010 at 9:07 am

    #1126505

  • RE: SARGable

    Tao Klerks (2/26/2010)

    Hmm, I was more bothered by the fact that NOT IN() is assumed to NOT be SARGable... In SQL 2000 this was always true when there was more...

    February 26, 2010 at 8:57 am

    #1125644

  • RE: SSRS timeout

    As far as the SqlCommand is concerned, there is only one way to set the timeout such that report does not time out - set it to zero. In other...

    February 15, 2010 at 9:00 am

    #1118832

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