Forum Replies Created

Viewing 15 posts - 1,291 through 1,305 (of 8,731 total)

  • RE: How to use 'between' in CASE statement?

    Charmer - Wednesday, May 10, 2017 11:18 AM

     
    Luis,  I could not understand. If you don't mind,  Could you please explain me...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 10, 2017 at 11:59 am

    #1942066

  • RE: Removing cursor

    legeboka - Wednesday, May 10, 2017 10:18 AM

    Thank you ChrisM It's close. Record PK=6 should not be updated because size increased by...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 10, 2017 at 11:13 am

    #1942057

  • RE: Downgrading database from SQL Server 2016 to SQL Server 2012

    dirk.dromgoole 30656 - Wednesday, May 10, 2017 9:51 AM

    The database is too large to restore to SQL Server 2016 Express Edition. The...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 10, 2017 at 10:08 am

    #1942046

  • RE: Today's Random Word!

    rodjkidd - Wednesday, May 10, 2017 8:11 AM

    ManicStar - Wednesday, May 10, 2017 6:53 AM

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 10, 2017 at 9:06 am

    #1942030

  • RE: Downgrading database from SQL Server 2016 to SQL Server 2012

    With that size, flat files might be a better option as you won't be using both databases while transferring the data through the network.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 10, 2017 at 8:48 am

    #1942024

  • RE: Downgrading database from SQL Server 2016 to SQL Server 2012

    dirk.dromgoole 30656 - Wednesday, May 10, 2017 7:52 AM

    Thank you all for the quick replies.

    Using SSIS would be great but the SQL...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 10, 2017 at 8:02 am

    #1942009

  • RE: Are the posted questions getting worse?

    ChrisM@Work - Wednesday, May 10, 2017 7:45 AM

    Brandie Tarvin - Wednesday, May 10, 2017 7:39 AM

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 10, 2017 at 7:48 am

    #1942001

  • RE: Removing cursor

    legeboka - Wednesday, May 10, 2017 6:52 AM

    Good morning,
    I have a store proc that uses cursor to update table with 80 million...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 10, 2017 at 7:04 am

    #1941985

  • RE: Downgrading database from SQL Server 2016 to SQL Server 2012

    Script just the structure, not the data. Then use SSIS or anything similar to move the data from one database to the other.
    You can't downgrade a database. For that...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 10, 2017 at 6:49 am

    #1941980

  • RE: SQL books and reference materials

    BiboKid - Wednesday, May 10, 2017 5:29 AM

    Hello guys,Im a new DBA but my weakness is High Availability, Replication and DR. ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 10, 2017 at 6:33 am

    #1941975

  • RE: SSIS Data Flow vs SQL Stored Procedure Loop

    SSIS is better handling errors as you can send the problematic rows to a different destination.
    T-SQL can be faster and easier to write. But, as mentioned by Alan, it...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 9, 2017 at 1:01 pm

    #1941878

  • RE: Insert data into a table without disabling the constraints (pk and fk)

    I don't see why wouldn't you.

    CREATE TABLE SomeTable(
      SomeID int PRIMARY KEY,
      SomeValue varchar(100),
      SomeDate datetime
    );
    INSERT INTO SomeTable
    VALUES( 1, 'A',...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 9, 2017 at 10:16 am

    #1941845

  • RE: Are the posted questions getting worse?

    Sean Lange - Tuesday, May 9, 2017 8:04 AM

    Has anyone ever done a performance test of a table valued functions that are...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 9, 2017 at 9:01 am

    #1941812

  • RE: How to use 'between' in CASE statement?

    Charmer - Tuesday, May 9, 2017 3:56 AM

    Luis Cazares - Monday, May 8, 2017 5:51 AM

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 9, 2017 at 5:50 am

    #1941761

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Tuesday, May 9, 2017 4:47 AM

    GAH. Not awake this morning.

    Made a recent change to code and am now unit...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 9, 2017 at 5:30 am

    #1941757

Viewing 15 posts - 1,291 through 1,305 (of 8,731 total)