Forum Replies Created

Viewing 15 posts - 6,316 through 6,330 (of 10,144 total)

  • RE: Issue: Index creation is not running in parallel

    anthony.green (5/16/2012)

    I thought the whole point of allowing the MAXDOP setting in statements is to override what is set at the server level as the options are evaluated at run...

    May 16, 2012 at 7:36 am

    #1488398

  • RE: Issue: Index creation is not running in parallel

    BOL also states "To suppress parallel plan generation, set max degree of parallelism to 1". My italics. If parallel plan generation is suppressed, should it matter what MAXDOP setting you've...

    May 16, 2012 at 7:28 am

    #1488390

  • RE: Issue: Index creation is not running in parallel

    Because "The instance is configured with max degree of parallelism=1", perhaps?

    May 16, 2012 at 6:45 am

    #1488337

  • RE: Capture data rows from output cursor into table variable

    kingdonshel (5/13/2012)

    I have been trying to insert rows into table variable from the reults of an output cursor ...

    What is it that you're trying to accomplish here? If you can...

    May 15, 2012 at 1:49 am

    #1487556

  • RE: Are the posted questions getting worse?

    GilaMonster (5/12/2012)

    Talking about London, heading that way tonight and won't have much time for SSC while I'm there. Could some people keep a watch for corrupt databases, production restores or...

    May 14, 2012 at 7:03 am

    #1487075

  • RE: Where Statement affects Index?

    Charmer (5/11/2012)

    Thank you Guys...i am clear now..

    You will be if you can find the time to read this excellent article by David Durant[/url].

    May 11, 2012 at 7:15 am

    #1486296

  • RE: Where Statement affects Index?

    Charmer (5/11/2012)

    ChrisM@Work (5/11/2012)

    Charmer (5/11/2012)

    Hi Friends,

    I am here to discuss the general topics of index....

    One of my colleague says if we add filtering(where statement) , it will affect index. Is that...

    May 11, 2012 at 7:13 am

    #1486292

  • RE: Where Statement affects Index?

    Charmer (5/11/2012)

    Hi Friends,

    I am here to discuss the general topics of index....

    One of my colleague says if we add filtering(where statement) , it will affect index. Is that true.? How...

    May 11, 2012 at 6:51 am

    #1486273

  • RE: DateAdd together with DateDiff

    It's been longer than a coffee break since the OP last posted anything 😀

    May 11, 2012 at 1:20 am

    #1486123

  • RE: improve performance of sp

    Tim Walker. (5/10/2012)

    I have amended my original proposal to a genuinely useful one:

    CREATE PROC WhenCanIGoHome AS

    SELECT 'You can go home at '+CONVERT(varchar, DATEADD(s,5+(3595*RAND(CHECKSUM(NEWID()))),GETDATE()),108)

    :hehe:

    Tim

    Late again! Your dinner's in the dog.

    May 10, 2012 at 6:50 am

    #1485663

  • RE: case statement

    ranuganti (5/10/2012)

    so how should we use this statement without returning 2 records

    select

    case when Void = 0 then SUM(weight) end AS totalweight

    from test

    when i use this i get

    result as:

    total...

    May 10, 2012 at 6:34 am

    #1485648

  • RE: Need help with SQL statement using COUNT function

    mldardy (5/8/2012)

    I am using a Select statement where I get the difference between two columns (ForecastQtyContainers and LastYearQtyActualContainers). I'm able to get that fine but I want take the Difference...

    May 10, 2012 at 6:03 am

    #1485628

  • RE: String conversion

    anthony.green (5/10/2012)

    if its a date time column could you not just do

    select CONVERT(varchar,getdate(),10)

    No leading zero for days and months...

    May 10, 2012 at 2:20 am

    #1485535

  • RE: String conversion

    SELECT STUFF(REPLACE('/'+CONVERT(VARCHAR(10),GETDATE(),1),'/0','/'),1,1,'')

    May 10, 2012 at 1:47 am

    #1485517

  • RE: String conversion

    Jeff Moden (5/9/2012)

    BWAAA-HAAA!!! This will do it! :-P:-D Makes a "great" interview question. :sick:

    WITH F(x) AS (SELECT TOP (CHECKSUM(66-ASCII('A'))) '/'+CONVERT(CHAR(8),GETDATE(),CAST(EXP(0) AS INT)) FROM sys.objects)

    SELECT STUFF(REPLACE(LEFT(x,POWER(73,1/2)*POWER(25,1/2.0)),'/0','/')

    ...

    May 10, 2012 at 1:42 am

    #1485513

Viewing 15 posts - 6,316 through 6,330 (of 10,144 total)