Forum Replies Created

Viewing 15 posts - 5,746 through 5,760 (of 8,731 total)

  • RE: Nightly Job Failing to Truncate Transaction Log

    doug.davidson (10/1/2014)

    Luis Cazares (10/1/2014)

    Why are you truncating the log file? You're only affecting performance. You should define an appropriate size to fulfill your needs and prevent autogrowth with normal operations.

    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

    October 1, 2014 at 4:03 pm

    #1749559

  • RE: Are the posted questions getting worse?

    Congratulations Jason and Jack!

    And thank you for all the time and knowledge you share with us.

    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

    October 1, 2014 at 3:46 pm

    #1749554

  • RE: Auto incrementing alphanumeric

    I'm sure that using sequences would be easier if 2 separate counters are needed. Sequences can handle multiple row inserts and should be easier to maintain.

    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

    October 1, 2014 at 2:46 pm

    #1749547

  • RE: Auto incrementing alphanumeric

    My advice would be to use an identity column along with a char column and create a computed column with both. It will result in easier maintenance. If the C...

    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

    October 1, 2014 at 12:00 pm

    #1749476

  • RE: its very urgent !! How to Improving Performance or Query Tuning of SQLView with Select Command,Please help me on this issue

    Read the following article to know what is needed for performance problems:

    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    Your view uses functions on your joins. Remove them as they're not useful at all as demonstrated in 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

    October 1, 2014 at 10:37 am

    #1749456

  • RE: Nightly Job Failing to Truncate Transaction Log

    Why are you truncating the log file? You're only affecting performance. You should define an appropriate size to fulfill your needs and prevent autogrowth with normal operations.

    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

    October 1, 2014 at 10:30 am

    #1749451

  • RE: Query Help

    Are you looking for something like this?

    CASE WHEN Sum(poitem.qty_ordered) = Sum(poitem.qty_received) AND Sum(poitem.qty_voucher) = Sum(poitem.qty_received)

    THEN 0 ELSE 1 END

    Are you aware...

    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

    October 1, 2014 at 9:35 am

    #1749429

  • RE: sql update query with concatation on value? Is this possible

    You might be experiencing a problem described by Jeff Moden in the following article:

    http://www.sqlservercentral.com/articles/Performance+Tuning/62278/

    I'm not sure how you tried to do the update with XML PATH, but it might not...

    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

    October 1, 2014 at 8:49 am

    #1749418

  • RE: Service pack 3 for SQL Server 2008 R2

    suresh-400144 (10/1/2014)

    http://go.microsoft.com/fwlink/?LinkID=512818&clcid=0x409

    Note that this question was posted over a year and a half ago. 😉

    I corrected your link to make it clickable.

    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

    October 1, 2014 at 8:25 am

    #1749410

  • RE: Nested stored procedure

    Most people won't download RAR files. Please post the code using IFCode tags [ code="sql"][/code] or at least text files. We would also need DDL and sample data. Please, read...

    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

    October 1, 2014 at 8:22 am

    #1749409

  • RE: db_owner or not

    sqlfriends (9/30/2014)

    Thanks,

    I agree DB owner is some risky, so what role or permission should I grant them as mentioned in my previous post?

    And how to easily track them later?

    Thanks

    Why do...

    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

    September 30, 2014 at 6:11 pm

    #1749290

  • RE: db_owner or not

    You need to be sure what's really needed and what's not.

    At my job, we have full control on a production db (on several but that's not the point). One day,...

    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

    September 30, 2014 at 5:25 pm

    #1749286

  • RE: Are the posted questions getting worse?

    BWFC (9/30/2014)

    Lynn Pettis (9/30/2014)

    How silver spoon can you get???

    Four thousand plus points....

    Anyway, could I possibly prevail upon the folks around here to do a little testing for me please. ...

    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

    September 30, 2014 at 3:52 pm

    #1749276

  • RE: Are the posted questions getting worse?

    Lynn Pettis (9/30/2014)

    How silver spoon can you get???

    Can you tell me how to connect to SQL Server? Where do I find SSMS? What should I put in password? How did...

    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

    September 30, 2014 at 3:25 pm

    #1749269

  • RE: Import txt data file into temp table

    If you know the structure of the files and have the tables created, you could use BULK INSERT to import the files.

    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

    September 30, 2014 at 1:21 pm

    #1749247

Viewing 15 posts - 5,746 through 5,760 (of 8,731 total)