Forum Replies Created

Viewing 15 posts - 2,356 through 2,370 (of 8,731 total)

  • RE: Are the posted questions getting worse?

    djj (8/5/2016)

    Brandie Tarvin (8/5/2016)

    A million things to do at work and they want me off my PC. I've got a new one I've got to configure.

    So I'm importing my outlook...

    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

    August 5, 2016 at 6:45 am

    #1894035

  • RE: Updating the View or the table?

    Almost missed the fact that firstname wasn't part of the view. It's a good thing I double checked.

    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

    August 5, 2016 at 6:35 am

    #1894034

  • RE: Query Improvement

    sqlenthu 89358 (8/4/2016)

    Mainly I see the substring condition in the where clause and the aggregate function in select condition using case statement. The query takes little more time than what...

    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

    August 4, 2016 at 2:11 pm

    #1893947

  • RE: Query Improvement

    For accurate replies, post DDL and sample data. For performance problems, follow this article to know what we need: http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    This has small changes that might not be relevant, but I...

    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

    August 4, 2016 at 2:02 pm

    #1893946

  • RE: Need syntax help on using the sp_exec statement

    mw112009 (8/4/2016)

    Done! Works!

    Thanks

    Do you understand how it works? The article should explain it clearly, but you can post any questions after reading 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

    August 4, 2016 at 1:34 pm

    #1893940

  • RE: MySQL Forums ?

    robert.sterbal 56890 (8/4/2016)

    yes. Their commitment and direction is contrary to an open source product. Some of the people coming to the forums of the most value will eventually leave when...

    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

    August 4, 2016 at 1:32 pm

    #1893939

  • RE: Query to track hourwise,daywise,weekwise,Monthwise and yearwise data

    This should be handled in the front end, the query should only return the values aggregated in the smallest unit fo measure (hours in this case, apparently).

    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

    August 4, 2016 at 1:24 pm

    #1893935

  • RE: MySQL Forums ?

    robert.sterbal 56890 (8/4/2016)

    mysql is now owned by oracle.

    Is that a problem? The site I posted seems to to be active.

    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

    August 4, 2016 at 1:17 pm

    #1893930

  • RE: To Shrink or Not to Shrink.... alternatives?

    If the database is not going to grow back, you could certainly shrink it. Remember to leave enough space for future growth.

    The backups don't include free space, so you shouldn't...

    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

    August 4, 2016 at 1:04 pm

    #1893927

  • RE: Need syntax help on using the sp_exec statement

    You could do it with the following method: http://www.sqlservercentral.com/articles/comma+separated+list/71700/

    DECLARE @sql NVARCHAR(MAX);

    SELECT @sql = ( Select 'ALTER TABLE ' + TABLE_SCHEMA + '.' + table_name

    ...

    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

    August 4, 2016 at 11:30 am

    #1893909

  • RE: How do we add a CONSTRAINT to a COLUMN to be like **/**/****

    One last thing. Try to stay away from scalar functions, they'll only slow you down. I'm not talking about coding time, but real processing time once the system is live.

    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

    August 4, 2016 at 11:22 am

    #1893902

  • RE: joining multiple tables without a join

    skippyV (8/4/2016)

    Luis Cazares (8/4/2016)

    With 1.2 and 427 million rows, you really should add an index to those tables. You should start by defining the clustered index and add non-clustered indexes...

    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

    August 4, 2016 at 11:18 am

    #1893900

  • RE: Need syntax help on using the sp_exec statement

    Assign it to a variable and then use sp_executesql

    Here's another link: https://technet.microsoft.com/en-us/library/ms175170(v=sql.105).aspx

    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

    August 4, 2016 at 11:14 am

    #1893897

  • RE: MySQL Forums ?

    I've never needed them, but you could always go to http://forums.mysql.com/ or http://stackoverflow.com/

    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

    August 4, 2016 at 11:12 am

    #1893894

  • RE: How do we add a CONSTRAINT to a COLUMN to be like **/**/****

    Here's an example:

    CREATE TABLE CheckTest(

    CharDate varchar(25)

    )

    GO

    ALTER TABLE CheckTest ADD CONSTRAINT CK_CharDate CHECK( CharDate = CONVERT( varchar(10), CONVERT( datetime, CharDate, 101), 101));

    GO ...

    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

    August 4, 2016 at 11:07 am

    #1893891

Viewing 15 posts - 2,356 through 2,370 (of 8,731 total)