Forum Replies Created

Viewing 15 posts - 1,996 through 2,010 (of 2,647 total)

  • RE: Very Puzzling T-SQL question

    If you are asking if there is a function that can magically count arbitrary items in a non defined list, it does not exist 🙂 You should count your delimiters...

    Jared
    CE - Microsoft

    January 10, 2012 at 2:46 pm

    #1431437

  • RE: SQL Agent Job succeeds even though step should fail

    Evil Kraig F (1/10/2012)

    Brandie Tarvin (1/9/2012)

    Evil Kraig F (1/6/2012)

    Brandie Tarvin (1/6/2012)

    To be clear: I'm not concerned with fixing the timeout issue itself. I've got that covered. What I'm concerned with...

    Jared
    CE - Microsoft

    January 10, 2012 at 2:42 pm

    #1431432

  • RE: Unable to shrink transaction log - could not locate files

    jpomfret7 (1/10/2012)

    Running SELECT * FROM test.dbo.sysfiles I got the following

    [/code

    fileidgroupidsizemaxsizegrowthstatusperfnamefilename

    116705152-1020test_dataJ:\SQLdata\test_data.mdf

    201280415-164000660test_logH:\SQLLog\test_log.ldf

    32823280-16400020test_indexG:\SQLIndex\test_index.mdf

    411363672-16400020test_data1P:\SQLData\test_data1.ndf

    And does that drive letter and file path still exist? I have to ask... 🙂

    Jared
    CE - Microsoft

    January 10, 2012 at 2:37 pm

    #1431425

  • RE: Few tricky Questions about SQL Server 2008 that I came across...

    Why are these tricky? Seems more like you didn't want to do your homework yourself... All of these answers can be found by using google or searching SSC.

    Jared
    CE - Microsoft

    January 10, 2012 at 2:33 pm

    #1431419

  • RE: Displaying SQL Server Syntax in WordPress

    GilaMonster (1/10/2012)

    SyntaxHighlighter plugin.

    🙂 That's what I finally got. I didn't realize that the shortcodes are only built in through wordpress.com. Thanks Gail!

    Jared
    CE - Microsoft

    January 10, 2012 at 2:08 pm

    #1431406

  • RE: Displaying SQL Server Syntax in WordPress

    _Beetlejuice (1/10/2012)

    Use Windows Live writer.

    You can publish directly to WordPress from there, and it keeps all of the formatting\colours

    http://explore.live.com/windows-live-essentials-other-programs?T1=t5

    Very interesting! I will check this out later tonight to see...

    Jared
    CE - Microsoft

    January 10, 2012 at 12:53 pm

    #1431374

  • RE: Displaying SQL Server Syntax in WordPress

    Gianluca Sartori (1/10/2012)

    I'm using wordpress.com and there you just need to surround your code with

    [sourcecode language=sql]

    SELECT SomeColumn FROM SomeTable

    [/sourcecode]

    and everything displays just fine, with copy,print,view source and help buttons.

    You...

    Jared
    CE - Microsoft

    January 10, 2012 at 10:07 am

    #1431288

  • RE: Understanding and Using APPLY (Part 1)

    reinpost (1/6/2012)

    SQL Kiwi (1/6/2012)

    reinpost (1/6/2012)

    Just a trivial remark: right at the start it says

    APPLY is named after the process of applying a set of input rows to a table-valued...

    Jared
    CE - Microsoft

    January 6, 2012 at 12:11 pm

    #1429804

  • RE: Reindexing and fragmentation

    Guras (1/6/2012)

    SQLKnowItAll (1/5/2012)

    Why are you concerned here... Are you experiencing performance problems or are you just digging?

    Just digging...

    Fragmentation being displayed as a percentage of say anywhere under 100 pages is...

    Jared
    CE - Microsoft

    January 6, 2012 at 7:44 am

    #1429626

  • RE: Reindexing and fragmentation

    Why are you concerned here... Are you experiencing performance problems or are you just digging?

    Jared
    CE - Microsoft

    January 5, 2012 at 3:14 pm

    #1429393

  • RE: High Fragmentation on New Indexes

    Index fragmentation is meaningless when the indexes are small... How many pages are your indexes?

    Jared
    CE - Microsoft

    January 5, 2012 at 11:19 am

    #1429241

  • RE: big expressions ins derived column

    Sure... Do it in the normal query editor and then copy and paste...

    Jared
    CE - Microsoft

    January 5, 2012 at 11:12 am

    #1429232

  • RE: Reindexing and fragmentation

    Guras (1/5/2012)

    rfr.ferrari (1/5/2012)

    how many row???

    what size in kbytes?

    total number of rows - 361

    I don't know how to find the kb.

    With 361 rows, you do not need to worry...

    Jared
    CE - Microsoft

    January 5, 2012 at 11:10 am

    #1429227

  • RE: How SQL uses Memory

    Dev (1/5/2012)

    GilaMonster (1/5/2012)

    Dev (1/5/2012)

    GilaMonster (1/3/2012)

    SQLKnowItAll (1/3/2012)

    lol However, it is good to know that books that are paid fr can help people around the world; i.e. SQL...

    Jared
    CE - Microsoft

    January 5, 2012 at 7:44 am

    #1429025

  • RE: Split Function - Comma and/or Space Delimited

    Cadavre (1/5/2012)

    SQLKnowItAll (1/4/2012)

    Cadavre (1/4/2012)

    Jeff Moden wrote an excellent article on splitters here[/url].

    Thanks for that, but what I am really trying to get at in this post is not an actual...

    Jared
    CE - Microsoft

    January 5, 2012 at 5:11 am

    #1428919

Viewing 15 posts - 1,996 through 2,010 (of 2,647 total)