Forum Replies Created

Viewing 15 posts - 1 through 15 (of 54,660 total)

  • Reply To: Replace Numbers

    ZZartin wrote:

    Jeff Moden wrote:

    While you guys are bantering, I hope it's your SSNs that the OP is going to obfuscate with this easily broken method. 😀

    Don't worry I'm sure it's just...

  • Reply To: A DateRange Table Valued function

    Jonathan AC Roberts wrote:

    Jeff Moden wrote:

    Nice function, Jonathan.  Well done!

    Thank you Jeff, that's a great compliment coming from someone as experienced as you.

    I just used the function to hammer out a solution to...

  • Reply To: TSQL: Create dynamic partition DataRange

    Let's try something a wee bit different and let's use a really nice tool written exactly for this type of thing.  The tool was written by Jonathan Roberts, is a...

  • Reply To: Burning Out

    Great article but, having been there and done that, be REALLY careful that you don't (as my Grandmother used to say) "Jump from fat to fire" (reference to a cast...

  • Reply To: Replace Numbers

    While you guys are bantering, I hope it's your SSNs that the OP is going to obfuscate with this easily broken method. 😀

  • Reply To: Partitioning and Indexes needed on huge table

    The big thing for partitioning for me has nothing to do with queries.  As Grant indicates, partitioning almost never improves performance.  Even so called "partition elimination" is usually slower than...

  • Reply To: Identify what causes tempdb to increase

    Johan Bijnens wrote:

    SQL2005 doesn't have XE!

    Check your default trace file or run a trace to figure it out !

    Ah... thanks, Johan.  Shows how much I use EE.

    The problem with using...

  • Reply To: How to get YYYYMMDDHHMMSS

    Thank you for the great feedback and the quote from BOL.

    Now if we could get the OP to cough up the reason for wanting to do this task. 😀

  • Reply To: How to get YYYYMMDDHHMMSS

    Bruin wrote:

    This is getting the data I need, but not the format.

    select replace(convert(varchar, getdate(),101),'/','') + replace(convert(varchar, getdate(),108),':','')

    10212021102437

    I want YYYYMMDD before the time portion.

    Thanks.

    Just out of sheer curiosity, why do you...

  • Reply To: How to get YYYYMMDDHHMMSS

    A lot of the methods posed so far do the job but are actually relatively slow because of all the string manipulation using both concatenation and REPLACE.  Using a nice...

  • Reply To: Replace Numbers

    RonMexico wrote:

    My goal is to replace the numbers 1-9 in a column with a different number. For this example the numbers would change to

    1=7

    2=3

    3=9

    4=1

    5=4

    6=2

    7=5

    8=6

    9=8

    I tried using the replace function shown...

  • Reply To: How to get YYYYMMDDHHMMSS

    MMartin1 wrote:

    Jeff Moden wrote:

    p.s.  Using VARCHAR with no length is one of those code smells that you might want to avoid.

    It would default to varchar(30) , but still to wide for...

  • Reply To: TSQL: Create dynamic partition DataRange

    Lidou123 wrote:

    Any help please?

    If you want faster help in the future, please see the first link in my signature line below for one of many different ways to post "Readily...

  • Reply To: Replace Numbers

    This looks like it might be used for the old and totally unsafe hack for "encrypting" SSNs and other critical numeric information.  If it is, STOP!  Do it correctly with...

  • Reply To: How to get YYYYMMDDHHMMSS

    planetmatt wrote:

    Replace all that with

    SELECT FORMAT(GETDATE(),'yyyyMMddhhmmss')

    You need to be really careful there.  FORMAT is about 43 times slower than just about anything you might want to do with CONVERT.  It's...

Viewing 15 posts - 1 through 15 (of 54,660 total)