Forum Replies Created

Viewing 15 posts - 5,926 through 5,940 (of 8,416 total)

  • RE: Help- Very Complex SQL query

    Jeff Moden (2/22/2010)

    I guess I didn't understand that one... it sets all the rows to 50 instead of doing the requested data smear.

    It works on my system :crying: but...

    February 22, 2010 at 6:58 am

    #1122918

  • RE: UNION a series of TOP statements

    Jim Russell-390299 (2/22/2010)

    is there a WHERE keyword missing after "FROM Test"?

    The first AND is a typo...is should be a WHERE.

    February 22, 2010 at 6:46 am

    #1122907

  • RE: ALTER a HUGE TABLE

    bhushanvinay (2/22/2010)

    This is an other thing which i thougt should be straright forward doing this not null and then updating it to some default value, which business requires. Then agian...

    February 22, 2010 at 6:44 am

    #1122903

  • RE: SQL Server 2005 Log File Affinity

    george sibbald (2/22/2010)

    Stevie, if not already doing so sounds like you would benefit from cutting down\spreading out the reindexing you are doing. If you search BOL for sys.dm_db_index_ physical_stats that...

    February 22, 2010 at 5:39 am

    #1122867

  • RE: Decimal Truncation in division

    wschampheleer (2/22/2010)

    The result of

    SELECT CAST(1.67574 AS DECIMAL(38,10)) / CAST(10000 AS DECIMAL(38,10)) conv_factor has datatype decimal(38,6).

    True.

    wschampheleer (2/22/2010)

    From BOL: In Transact-SQL statements, a constant with a decimal point is automatically converted...

    February 22, 2010 at 5:36 am

    #1122864

  • RE: Rebuild Indizes with Stored Procedure

    Hi Stefan,

    Have you looked at Michelle Ufford's Index Defrag Script?

    You can find it here: http://sqlfool.com/2009/06/index-defrag-script-v30/

    Paul

    February 22, 2010 at 4:19 am

    #1122829

  • RE: CPU time drops, but elapsed time increases

    Sander A. (2/22/2010)

    Paul White (2/22/2010)

    So, the worktable was either an index spool or lazy spool caused by the lack of a useful index. The post containing the execution plan...

    February 22, 2010 at 4:13 am

    #1122827

  • RE: SQL Server 2005 Log File Affinity

    No worries Stevie. Sounds like you've had a tough week!

    Good luck!

    February 22, 2010 at 4:09 am

    #1122826

  • RE: Best example of grouping ???

    Kingston Dhasian (2/22/2010)

    The Craig Freedman's Blog is pretty simple and easy to understand.

    Thanks for pointing that out. I thought Craig did an excellent job, but I was starting to...

    February 22, 2010 at 4:07 am

    #1122824

  • RE: CPU time drops, but elapsed time increases

    Right, now I see it. I had been working from the data (CPU/ IO) contained in the execution plan post. The figures and plans there bear no resemblance...

    February 22, 2010 at 4:05 am

    #1122821

  • RE: SQL Server 2005 Log File Affinity

    Yes, minimally-logged index rebuilds can be very efficient, especially if you are able to advantage of parallelism.

    Be sure to back up your log immediately before switching to BULK_LOGGED mode from...

    February 22, 2010 at 3:27 am

    #1122808

  • RE: EXISTS

    Right. 😎

    February 22, 2010 at 2:37 am

    #1122788

  • RE: CPU time drops, but elapsed time increases

    RBarryYoung (2/22/2010)

    OMG, is it really 4am?!?

    Lightweight 😛

    I was still posting at 6:30am last night/this morning/you know what I mean.

    February 22, 2010 at 2:17 am

    #1122776

  • RE: CPU time drops, but elapsed time increases

    Barry,

    One day, we will meet in person, and we will have a long and no doubt fascinating conversation about all this :-D.

    I think we probably agree more than is apparent...

    February 22, 2010 at 2:15 am

    #1122774

  • RE: EXISTS

    True.

    Is it just me and you on SSC tonight?

    Or are we both suffering from post-itis?

    Paul

    February 22, 2010 at 2:09 am

    #1122771

Viewing 15 posts - 5,926 through 5,940 (of 8,416 total)