Forum Replies Created

Viewing 15 posts - 4,606 through 4,620 (of 8,416 total)

  • RE: Understanding indexes

    sqlsc-1053844 (3/30/2010)

    So the key position needs to match the query? Or a better question might be, do you have any links to where I can read up on this?

    Sure:

    Introduction to...

    March 30, 2010 at 12:24 pm

    #1142556

  • RE: Need help with T-SQL Statement

    If you are looking for a powerful index reorganizing/rebuilding script, you could do much worse than look at MVP Michelle Ufford's very popular scripts:

    http://sqlfool.com/category/sql-scripts/

    The latest stable version is 3.0 I...

    March 30, 2010 at 12:21 pm

    #1142551

  • RE: Get minimum data without using MIN() function

    TheSQLGuru (3/30/2010)

    IIRC the two you mention as being useful and cool still carry the downside of preventing parallel query plans at a minimum.

    I know why you say that, since all...

    March 30, 2010 at 12:15 pm

    #1142546

  • RE: Error while Rounding

    No worries 🙂

    March 30, 2010 at 12:05 pm

    #1142538

  • RE: Memory Available Bytes Counter

    What is max server memory set to at the moment?

    Which edition of SQL Server are you running?

    32 or 64 bit?

    Is the server dedicated to SQL Server, or are there other...

    March 30, 2010 at 12:03 pm

    #1142535

  • RE: What is the ideal size for a table

    Ather M (3/26/2010)

    Can somebody tell me what is ideal size for table.

    The smallest size that meets the needs that inspired its creation.

    March 30, 2010 at 11:59 am

    #1142530

  • RE: Understanding indexes

    sqlsc-1053844 (3/30/2010)

    The existing index has four keys and no includes. I think you're asking how the suggestion relates to the existing. Here's that information.

    Suggestion:

    [myTable] (sugKey) INCLUDE (sugInclude1, sugInclude2)

    Existing:

    col1 (sugInclude1)

    col2

    col3 (sugInclude2)

    col4...

    March 30, 2010 at 11:57 am

    #1142526

  • RE: Aggregation of records

    saurabh Srivastava-398090 (3/30/2010)

    Thanks all for your responses. I got it resolved. It was a pretty simple thing.

    It's always nice to know the problem is solved...though it would be nice if...

    March 30, 2010 at 11:54 am

    #1142521

  • RE: Removing Blank Fields

    Yep, avoid implicit conversions like that wherever possible:

    DECLARE @Example

    TABLE (

    field1 VARCHAR(30) NULL,

    ...

    March 30, 2010 at 11:53 am

    #1142519

  • RE: What is the RAM ramification of CTE?

    keepintouch2b (3/30/2010)

    I notice table variables is recommended to store upto 2 to 3 Megs.

    Does this also apply CTE?

    There's no such recommendation.

    A (non-recursive) CTE is exactly equivalent to a derived table...

    March 30, 2010 at 11:50 am

    #1142513

  • RE: to find count of rows

    naresh1253 (3/30/2010)

    Select * into newTable from oldTable (nolock)

    If the database is currently using the FULL...

    March 30, 2010 at 11:44 am

    #1142509

  • RE: Today's Random Word!

    Plinth

    March 30, 2010 at 11:37 am

    #1142501

  • RE: Best way to transpose multiple rows onto 1 row?

    Jeff Moden (3/30/2010)

    Actually... that's Lynn's article on Dynamic Tally Tables.

    How odd. I distinctly remember looking for yours at the time. Not sure I have even read Lynn's.

    March 30, 2010 at 11:18 am

    #1142487

  • RE: Get minimum data without using MIN() function

    TheSQLGuru (3/30/2010)

    In the past 3 years I have made more money consulting helping clients with performance problems due to UDFs than any single other issue - that should say all...

    March 30, 2010 at 11:15 am

    #1142485

  • RE: Question of the Day for 01 Mar 2004

    David Burrows (3/30/2010)

    Hey Paul

    :ermm: Whats with the post on a very,very old thread

    Or are you just trying to bolster your point count with QOD 😛

    Answered the QotD, left a comment.

    Anything...

    March 30, 2010 at 11:08 am

    #1142480

Viewing 15 posts - 4,606 through 4,620 (of 8,416 total)