Forum Replies Created

Viewing 15 posts - 106 through 120 (of 859 total)

  • RE: Generate schedule table

    Abu Dina (11/12/2012)

    Very good! I have much to learn.... 😛

    I'm glad you asked about what I'm doing.

    Let me try to explain, I have:

    1 SQL Server Instance with 25 databases (I...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    November 13, 2012 at 10:33 am

    #1558568

  • RE: Hight memory usage by SQL SERVER 2008 R2

    are you running multiple instances? Also our former server admin had an extra couple of 0's in the max server memory when he first set it up. couple...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    November 12, 2012 at 4:34 pm

    #1558347

  • RE: No record count in PIVOT

    mickyT (11/12/2012)

    michielbijnen (11/12/2012)

    There is a comma! As far as I know the syntax is correct for the columns variable. Or not?

    As an example

    select 'Count IsPrimary', [0], [1]

    from (select isprimary, blockid...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    November 12, 2012 at 3:30 pm

    #1558340

  • RE: No record count in PIVOT

    michielbijnen (11/12/2012)

    There is a comma! As far as I know the syntax is correct for the columns variable. Or not?

    every thing in the dynamic sql is correct since the extra...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    November 12, 2012 at 3:28 pm

    #1558339

  • RE: Need to transpose some data - and not sure of the best way to do so - pivot table perhaps?

    One thing i do when i need something like these requirements is create a consistent uniquifier using something like ROW_NUMBER() and have the base of my pivot something like this:

    SELECT...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    November 12, 2012 at 3:20 pm

    #1558336

  • RE: No record count in PIVOT

    it looks like there is an extra minus sign in your query at whereisnull(h.ldatuitdienst, getdate()+1) > pd.eddatum - @DaysMinus -

    Other than that with out some sample data it...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    November 12, 2012 at 1:34 pm

    #1558309

  • RE: Multiple Server Reboot with SQL Server 2008 R2 on it

    what i might do is manually shut down the service then disable the SQL Server service while they do their multiple reboots then once they are done restart and re-enable...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    November 12, 2012 at 12:45 pm

    #1558282

  • RE: Generate schedule table

    well to generate the table here is a faster and more direct way. it uses a tally table to generate the dates (posted as a cte Tally Table). ...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    November 12, 2012 at 11:39 am

    #1558261

  • RE: How many rows in a table before using a clustered index?

    Bobby Glover (11/10/2012)

    capnhector (11/9/2012)

    Bobby Glover (11/9/2012)

    Praise the lord for this post. I have the same issue 1000 tables 750 are heaps, the wierd thing is they have NON-CLUSTERED PKs in...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    November 10, 2012 at 8:20 am

    #1557914

  • RE: Buffer Pool

    SQLSACT (11/10/2012)

    Are these clean pages or clean buffers?

    Thanks

    these are clean pages. SQL Server only drops pages from the buffer if there is not enough memory (or the server is...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    November 10, 2012 at 7:55 am

    #1557908

  • RE: Today's Random Word!

    Revenant (11/9/2012)

    crookj (11/9/2012)

    JAZZ Master (11/9/2012)

    anthony.green (11/9/2012)

    capnhector (11/8/2012)

    Cliff Jones (11/8/2012)

    crookj (11/8/2012)

    capnhector (11/8/2012)

    JAZZ Master (11/8/2012)

    bcsims 90437 (11/8/2012)

    crookj (11/8/2012)

    Ray K (11/8/2012)

    opc.three (11/7/2012)

    Ground Game

    aerial assault

    Space Combat

    Space Invaders

    BMEs

    BMI

    MIBs

    Tommy Lee Jones and Will Smith

    apple built self...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    November 9, 2012 at 4:41 pm

    #1557852

  • RE: Buffer Pool

    SQLSACT (11/9/2012)

    GilaMonster (11/9/2012)

    SQLSACT (11/9/2012)

    I'm trying to understand what happens to clean pages in the buffer pool (when a select statement brings pages into the buffer pool).

    What happens to the pages...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    November 9, 2012 at 4:28 pm

    #1557847

  • RE: rebuild on clustered index

    muthyala_51 (11/9/2012)

    Sorry for the confusion. It doesn't release space to OS, I mean to say free space in the DB increases, when we rebuild PK. Probably the best way to...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    November 9, 2012 at 4:24 pm

    #1557846

  • RE: Consecutive count for multiple records

    Nathan check out my post above yours. the outputed data was demonstrating how the 2 ROW_NUMBER()'s worked together. if you run the actual query it will return the...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    November 9, 2012 at 4:04 pm

    #1557842

  • RE: Tlog Shipping

    sdvandeslunt (11/9/2012)

    Thanks for the reply. Unfortunately that answer is exactly what I was afraid was the truth. (When you say version you mean SQL server version right, not...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    November 9, 2012 at 3:58 pm

    #1557841

Viewing 15 posts - 106 through 120 (of 859 total)