Forum Replies Created

Viewing 15 posts - 166 through 180 (of 212 total)

  • RE: Data Type

    Date is one of the most requested data types and finally MS implemented it in SQL Server 2008 and i love it. The new datatypes are just one of the...

    July 1, 2009 at 12:56 am

    #1018178

  • RE: Automating tests for T-SQL code

    I have not tried this tool yet, but if it works as mentioned, then this is what I am looking for. 🙂

    I will try this as soon as possible...

    June 30, 2009 at 12:26 am

    #1017389

  • RE: get real!

    steve.saunders (6/26/2009)

    real is actually a synonym for float(24) which has a precision of only 7 digits.

    You are right! Real and float(24) only has a precision of 7 seven digits. The...

    June 28, 2009 at 11:25 pm

    #1016603

  • RE: Spatial Modeling

    SanjayAttray (6/24/2009)

    Found answer after some googling. But, this is not related to SQL Server right?

    I think it is more related to science then SQL server. When i need to...

    June 25, 2009 at 4:42 am

    #1015188

  • RE: Question of the Day for 05 Sep 2005

    nice every option is 

     :-D

    June 23, 2009 at 6:03 am

    #1013854

  • RE: one character of data

    Toreador (6/17/2009)

    hakan.winther (6/17/2009)

    I think this QoD has been discussed enough, dont you agree! We all have different views on this case and let us leave it this way. The poor...

    June 17, 2009 at 6:51 am

    #1010864

  • RE: one character of data

    I think this QoD has been discussed enough, dont you agree! We all have different views on this case and let us leave it this way. The poor author of...

    June 17, 2009 at 6:23 am

    #1010832

  • RE: decimal

    Hi!

    My recommendation is to never use default values because of maintainability. What would happen if MS (I really hope they dont) changes the default value for decimal in this case?...

    June 17, 2009 at 2:27 am

    #1010692

  • RE: nvarchar

    beezell (5/28/2009)

    Since the abbreviation is "nvarchar" I can see National VARying CHARacter. How did it become National CHARacter VARying? If that was the case shouldn't it be ncharvar?...

    June 9, 2009 at 2:01 am

    #1006497

  • RE: one character of data

    Cliff Jones (6/5/2009)

    I don't think any of the answers that include varchar or nvarchar can be correct.

    But the question provoked an interesting discussion.

    I agree, there is an overhead...

    June 9, 2009 at 1:23 am

    #1006489

  • RE: one character of data

    MarkusB (6/5/2009)

    I've chosen for nchar(1) because it only says that the value won't be NULL or empty, but there's no limitation on the characters used. Also depending on your collation...

    June 9, 2009 at 1:19 am

    #1006484

  • RE: Maximum instances supported by SQL Server 2008

    Noel McKinney (5/18/2009)

    The page below (under "Scalability & Performance") gives 50 for Enterprise and 16 for Standard edition:

    http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

    I had seen the comparison above and got the question right....

    May 25, 2009 at 1:33 am

    #999576

  • RE: TOP

    I always use order by when i use TOP, but now i realize how important it really is. I have not thought of why it is important before, and I...

    April 23, 2009 at 5:04 am

    #982765

  • RE: TOP

    I agree that you cannot be 100% sure of what method will be chosen by the SQL optimizer, but in this case the index scan would be much more expensive...

    April 23, 2009 at 2:20 am

    #982705

  • RE: TOP

    Carlo Romagnano (4/23/2009)

    I disagree! See the question of yesterday.

    I do not understand why you disagree? Do you want to be more specific?

    /Håkan Winther

    Senior SQL Server DBA

    April 23, 2009 at 1:10 am

    #982676

Viewing 15 posts - 166 through 180 (of 212 total)