Forum Replies Created

Viewing 15 posts - 5,536 through 5,550 (of 8,416 total)

  • RE: SQL Random selection with NewID()

    Eralper (3/11/2010)

    So do you think it is better to use only NEWID() function? Although using CheckSum() might result with a fine distribution of numbers.

    Each has strengths and weaknesses making...

    March 11, 2010 at 2:31 am

    #1131884

  • RE: Log Growing Pains

    arr.nagaraj (3/11/2010)

    The query you used to capture tsqls doesnt capture sleeping connections. Was that intentional? I would prefer to grab the sleeping ones as well so that I grab...

    March 11, 2010 at 2:29 am

    #1131883

  • RE: SQL Random selection with NewID()

    Eralper (3/11/2010)

    I have seen on some web sites suggesting to use ORDER BY CHECKSUM(NEWID()) instead of using only NEWID() function.

    I think it affects the seed of the NewId function to...

    March 11, 2010 at 1:52 am

    #1131868

  • RE: Cannot Shrink Database

    GTR (3/9/2010)

    Are you sure DBCC shrinkfile will shrink below initial size of the mdf or ldf file size?

    If you are unsure, you should test it. It's the best way...

    March 11, 2010 at 12:31 am

    #1131836

  • RE: Data Type size

    kaladharreddy15 (3/9/2010)

    Why do we want to keep field datatypes as small as possible in SQL Server 2005?

    We do this in order to fit the maximum number of fields on a...

    March 11, 2010 at 12:27 am

    #1131832

  • RE: Improve Searches

    kaladharreddy15 (3/9/2010)

    If the table customer had millions of rows, what would you do to improve searches based on last name ?

    It depends on the searches. Full-text index maybe? ...

    March 11, 2010 at 12:24 am

    #1131830

  • RE: DateFunction

    kaladharreddy15 (3/9/2010)

    Write a query based on Customer table that returns list of customers having same birthday. List all

    groups.

    I can't - my Customer table doesn't include birthday information.

    March 11, 2010 at 12:21 am

    #1131828

  • RE: Slow Windows 7 ODBC Connection to SQL Server 2005

    Open Registry Editor, and navigate to HKEY_LOCAL_MACHINE\SOFTWARE. Right-click on the ODBC key, choose Export, and attach the resulting output to your next post.

    March 11, 2010 at 12:18 am

    #1131827

  • RE: T-SQL help

    Jeff Moden (3/10/2010)

    Heh... never mind. I didn't read the original post carefully enough.

    No worries. It is a bit off an odd requirement... kinda makes me doubt that the...

    March 11, 2010 at 12:03 am

    #1131821

  • RE: procedure or direct query?which one is best

    Jeff Moden (3/10/2010)

    Heh... not so sure about that. The article on Triangular Joins actually started out as a single post... including the graphics.

    Ah. Ok then - you are...

    March 11, 2010 at 12:01 am

    #1131820

  • RE: Scalar-valued Functions in Where clause

    Jeff Moden (3/10/2010)

    Oh I agree that a CLR would be the thing to do here. No question about that. It's just that not all Developers (or even DBA's)...

    March 10, 2010 at 11:59 pm

    #1131819

  • RE: Log Growing Pains

    CirquedeSQLeil (3/10/2010)

    Thanks Paul. After submitting the article and taking another look at it, I found a few things that could have been changed to improve the scripts. I...

    March 10, 2010 at 11:59 pm

    #1131818

  • RE: Log Growing Pains

    Very nice Jason.

    March 10, 2010 at 11:28 pm

    #1131806

  • RE: T-SQL help

    Jeff Moden (3/10/2010)

    That kind of presupposes that you know what order the delimited parameter is going to be in, doesn't it? 😀

    Nope. My reading of the requirement is that...

    March 10, 2010 at 11:26 pm

    #1131804

  • RE: procedure or direct query?which one is best

    Jeff Moden (3/10/2010)

    Heh... I did beat around the bush a bit, huh? 😛

    Could've been worse...you have a long way to go to beat some of Barry's posts :laugh:

    March 10, 2010 at 11:23 pm

    #1131801

Viewing 15 posts - 5,536 through 5,550 (of 8,416 total)