Forum Replies Created

Viewing 15 posts - 2,686 through 2,700 (of 2,862 total)

  • RE: Sabbaticals

    I got sabbatical to learn Azure. I suspect this would not happen in today's depressed economy.

  • RE: The Age of Software

    Yes, it will depend on one's perspective. If we are talking a single-user desktop RDBMS like access, an in-between hardware-agnostic layer will probably do. As I am on an...

  • RE: The Age of Software

    Eric M Russell (6/29/2011)


    . . . Even a RDBMS like SQL Server which is built exclusively on Win32/64 executables should be able to retain that functionality regardless of wether it's...

  • RE: The Age of Software

    Paul, you are of course absolutely right, there was one. However, its driver model was so difficult that very few third parties bothered to port their products to it. ...

  • RE: The Age of Software

    I am a bit surprised that (so far) no one mentioned memory hogging as a sound reason for going to a newer OS. XP is 10 years old and...

  • RE: PerfectDisk Vs DisKeeper

    Jeff

    This is about what works for you and what you feel comfortable defending to your boss during your performace review.

    That is where IMO this or any SqlServerCentral forum ends and...

  • RE: Split a field with duplicate seperators

    Both thumbs up!

    As they say, you learn the important stuff only if you keep on learning after you think you know it all...

  • RE: PerfectDisk Vs DisKeeper

    So far I have tried the newest version on my laptop (plain 500 GB) and on my dev machine (RAID2). I have not seen the results on RAID5 or...

  • RE: PerfectDisk Vs DisKeeper

    The newest version of DisKeeper does not have to run as often as the previous versions. DisKeeper hooks the disk drivers and prevents fragmentation during write operations; so far as...

  • RE: Split a field with duplicate seperators

    This is my take on it:

    DECLARE @string VARCHAR(MAX) = 'RNL00:123456-3:123';

    DECLARE @nibble VARCHAR(MAX) = REVERSE(@string);

    SET @nibble = REVERSE( SUBSTRING( @nibble, 0, CHARINDEX( ':', @nibble ) ) );

    If...

  • RE: Split a field with duplicate seperators

    REVERSE your string, split the first portion and REVERSE it back.

  • RE: remove Identity from a column

    ashkan siroos (6/16/2011)


    Shall I drop my column and all of its relations?:(

    This is Terrible:(

    Ashkan

    The code I gave you is safe and preserves all your data. And it is...

  • RE: remove Identity from a column

    Sorry for the typos, BTW. I was getting into a meeting.

  • RE: remove Identity from a column

    To remove the Identity property, creatr a new column name 'tempID' then temporarily storing the ID data into it while I recreate ID column so as to remove the Identity...

  • RE: Problem using IF EXISTS(SELECT * FROM MYVIEW)

    Well, that I am taking for granted.

Viewing 15 posts - 2,686 through 2,700 (of 2,862 total)