Forum Replies Created

Viewing 15 posts - 691 through 705 (of 8,731 total)

  • RE: Are the posted questions getting worse?

    Grant Fritchey - Thursday, February 8, 2018 8:58 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

    February 8, 2018 at 9:31 am

    #1979049

  • RE: Upgrade Sql 2000 to SQL 2008

    almirfiorio - Thursday, February 8, 2018 8:04 AM

    NorthernSoul - Thursday, February 8, 2018 7:08 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

    February 8, 2018 at 8:15 am

    #1979032

  • RE: oracle quctions

    You can delete any number of rows, you just need to use the correct WHERE clause.
    https://docs.oracle.com/cd/B14117_01/appdev.101/b10807/13_elems014.htm

    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

    February 8, 2018 at 6:01 am

    #1979007

  • RE: Self-Join with aggregation and pivot ?

    will_william - Wednesday, February 7, 2018 1:04 PM

    Hello -
    I need to generate a result set that will be coming from a table...

    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

    February 7, 2018 at 1:45 pm

    #1978953

  • RE: Upgrade Sql 2000 to SQL 2008

    Are you clicking on the green arrow (Debug) instead of the red exclamation sign (Execute)?

    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

    February 7, 2018 at 7:19 am

    #1978873

  • RE: Upgrade Sql 2000 to SQL 2008

    Jobs and logins are not part of the database, they're part of the instance (server).
    Jobs are stored in the msdb database and logins are stored in the master database....

    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

    February 7, 2018 at 6:47 am

    #1978856

  • RE: Increament id if running total for group exceeds value

    I actually used the Quirky Update which is great for this sort of things. I would test it as I'm not sure about updating 2 columns at once. Check 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

    February 6, 2018 at 11:27 am

    #1978745

  • RE: Help me with the SELECT statement please ?

    ScottPletcher - Monday, February 5, 2018 11:29 AM

    That's an Itzik Ben-Gap "Gaps and Islands" query.  Sorry, I don't have time now to...

    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

    February 5, 2018 at 12:08 pm

    #1978607

  • RE: Help me with the SELECT statement please ?

    ScottPletcher - Monday, February 5, 2018 11:29 AM

    That's an Itzik Ben-Gap "Gaps and Islands" query.  Sorry, I don't have time now to...

    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

    February 5, 2018 at 12:08 pm

    #1978605

  • RE: Sequential 'Alter Table' queries

    Maybe you have a BEGIN without END? Or something similar.

    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

    February 5, 2018 at 12:01 pm

    #1978603

  • RE: Spanish characters

    johnnycash - Thursday, February 1, 2018 10:44 AM

    Thank you Luis!

    The weird part is that when it was running on SQL Server 2008,...

    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

    February 1, 2018 at 10:54 am

    #1978236

  • RE: Spanish characters

    johnnycash - Thursday, February 1, 2018 10:13 AM

    Hello to all gurus!

    I've inherited a software application using a SQL 2008 DB.  We migrated...

    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

    February 1, 2018 at 10:28 am

    #1978232

  • RE: Query performs poorly on prod server, works well when run against a restored copy of DB

    jasona.work - Wednesday, January 31, 2018 1:21 PM

    tommiwan - Wednesday, January 31, 2018 12:23 PM

    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

    January 31, 2018 at 1:31 pm

    #1978095

  • RE: how to do Intermediate calculations for partial rows based on a particular field

    Naveen PK - Wednesday, January 31, 2018 1:14 PM

    Business defines the formula. For simplicity, assume that formula is fixed in this...

    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

    January 31, 2018 at 1:27 pm

    #1978093

  • RE: Does denormalizing the data enhance performance?

    I would start by defining adequate clustered indexes to your tables. Then add any nonclustered indexes that might be needed.

    Check the following for more help:
    How...

    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

    January 31, 2018 at 1:20 pm

    #1978089

Viewing 15 posts - 691 through 705 (of 8,731 total)