Forum Replies Created

Viewing 15 posts - 44,596 through 44,610 (of 59,063 total)

  • RE: SQL Server 2005 Paging – The Holy Grail

    For my ends, the 'holy grail' approach is absolutely the fastest and most efficient technique

    Heh... sure... 7 to 8 seconds compared to just over a second. I'm sure...

    March 13, 2009 at 10:38 pm

    #959621

  • RE: sql_variant

    Steve Mong (3/13/2009)

    Certain classes of apps can't anticipate the data types they'll be required to store, manipulate, etc.

    Master Data Management apps have always been prominent examples (wherein Oracle's product...

    March 13, 2009 at 10:31 pm

    #959619

  • RE: split date and time from datetime

    vijays (3/13/2009)

    select convert(datetime, convert(float, getdate()) - floor(convert(float, getdate())))

    Unfortunately, this is one of the posts where the original post made by the OP isn't even close to what the OP actually...

    March 13, 2009 at 6:25 am

    #959031

  • RE: How do I select a specific entry from a select top nn statement

    RBarryYoung (3/11/2009)

    PeterR (3/11/2009)

    OK Jeff - Why is it necessary?

    (Hope I got the question right)

    Since that wasn't the question that Jeff wanted, I'll answer this one, ...:D

    They are necessary because all...

    March 13, 2009 at 12:15 am

    #958918

  • RE: Please clarify

    prvreddy (3/12/2009)

    Hi guys,

    Yesterday, I attended one interview for DBA.I got following questions.But i didn't answers these questions.Please help me in this regard.

    1)if log file fills 100% then how...

    March 13, 2009 at 12:09 am

    #958917

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/12/2009)

    My favorite snooty response, mainly because I've received it several times, "You're being far too SQL Server specific. What happens when you need to switch platforms?"

    My favorite...

    March 12, 2009 at 9:41 pm

    #958896

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/12/2009)

    Steve Jones - Editor (3/12/2009)

    I'm just glad they're coming here instead of Google first 🙂

    Yeah. You can buy pork chops in bulk now and get a much...

    March 12, 2009 at 9:32 pm

    #958895

  • RE: SQL Server 2005 Paging – The Holy Grail

    Jeff Moden (3/12/2009)

    C. Westra (3/12/2009)

    I'm afraid differences in resources are partly induced by Sql Server caching (intermediate) results between the first and latter queries.

    If you use DBCC DROPCLEANBUFFERS between the...

    March 12, 2009 at 9:26 pm

    #958894

  • RE: SQL Server 2005 Paging – The Holy Grail

    C. Westra (3/12/2009)

    I'm afraid differences in resources are partly induced by Sql Server caching (intermediate) results between the first and latter queries.

    If you use DBCC DROPCLEANBUFFERS between the queries, caches...

    March 12, 2009 at 9:10 pm

    #958891

  • RE: SP naming convention policy

    Sorry... almost for got...

    select @name where @name like ''_\_[a-z][a-z][a-z]\_%'' ESCAPE '\'

    The code above is one way to use underscores as both a single character wild card and a "literal". ...

    March 12, 2009 at 9:07 pm

    #958890

  • RE: SP naming convention policy

    dallas13 (3/12/2009)

    well i agree but irrespective of all tht we r going to create new system , we are building it from scratch..

    Now so far i m using NAme facet...

    Where...

    March 12, 2009 at 9:01 pm

    #958888

  • RE: Can I make this any faster

    chrisau168 (3/12/2009)

    hey mate

    what's authority

    rules were made so you know what you are breaking

    and you are only breaking them "only" when you get caught

    BWAA-HAA!!! Now THAT's ironic... THAT's probably...

    March 12, 2009 at 8:06 pm

    #958881

  • RE: Get Month Name

    karthikeyan (3/12/2009)

    A little modification in Jeff's code.

    SELECT DateName(mm,DATEADD(mm,MonthNumber,-1))

    Yep... good call.

    March 12, 2009 at 6:55 pm

    #958866

  • RE: split date and time from datetime

    dmoldovan (3/12/2009)

    Try also:

    CONVERT(CHAR(8), GETDATE(), 114)

    CONVERT(CHAR(8), GETDATE(), 108)

    No... not for the application the OP is going to use and almost never for everything else because both methods are slow due to...

    March 12, 2009 at 6:50 pm

    #958865

  • RE: how can i convert this date'200702071630+1100' in datetime or in string '20070207'

    karthikeyan (3/11/2009)

    Can you explain it how it is internally trated by sqlserver? how it is opearting internally? how the memory structure will differ for each function?

    if you see REVERSE() is...

    March 12, 2009 at 12:30 am

    #958091

Viewing 15 posts - 44,596 through 44,610 (of 59,063 total)