Forum Replies Created

Viewing 15 posts - 1,576 through 1,590 (of 8,731 total)

  • RE: Running date update

    Jeff Moden - Tuesday, February 14, 2017 9:12 AM

    So how long does the update through the CTE take for 1 million out...

    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 14, 2017 at 9:44 am

    #1928406

  • RE: Using SQL Profiler

    epascascio76 - Tuesday, February 14, 2017 8:27 AM

    Good  morning group!  I have a  question... I have a  DBA on my team who...

    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 14, 2017 at 8:52 am

    #1928390

  • RE: Timeouts in Microsoft SQL Server 2008 R2

    Timeouts are defined by the connection. You won't find them on the DB server, you need to capture them in the App server which is the one getting the timeouts.

    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 14, 2017 at 6:25 am

    #1928334

  • RE: Running date update

    Yet another option.

    WITH OnlyTs AS(
      SELECT Date1, LEAD(Date1, 1, '9999') OVER(ORDER BY Date1) NextDate
      FROM #SomeTab
      WHERE Stat = 'T'
    )
    --SELECT *

    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 13, 2017 at 9:27 am

    #1928138

  • RE: Are the posted questions getting worse?

    Is a 200GB storage or less common for productive db servers? I know that I have a lot more in my laptops which obviously use cheaper storage, but it doesn'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

    February 10, 2017 at 12:37 pm

    #1927875

  • RE: All disk space used, after deleting rows the table has 6GB "unused"space but I cannot release it or shrink the mdf.

    Something baffles me. You're using 70GB of data between data and indexes.
    Why is it so important to recover 6GB when the logic indicates that you'll use it again?...

    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 10, 2017 at 12:27 pm

    #1927871

  • RE: Wildcard Searches

    jason.baker.sd - Friday, February 10, 2017 11:31 AM

    Nice article and primer for string searching.  For the decimal test, you could also use...

    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 10, 2017 at 12:07 pm

    #1927866

  • RE: Forum User Post Levels

    Remember that you also get points from liked posts. It seems that someone/something is liking random posts according to what I saw on my profile some days ago. With 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 10, 2017 at 7:07 am

    #1927755

  • RE: How to declare and pass a variable inside the SQL String when using Stored Procedure.

    ScottPletcher - Thursday, February 9, 2017 8:01 AM

    Since you're already using dynamic SQL, you can directly pass the value to 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

    February 9, 2017 at 8:15 am

    #1927541

  • RE: Need suggestion for case statement code optimisation.

    This is an untested version that might help. It only works if you're repeating the exact same CASE clause.

    select Salutation,
      case when len(FirstName)= 0 then...

    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 9, 2017 at 8:07 am

    #1927535

  • RE: Split Row into Multiple Rows

    Sean Lange - Thursday, February 9, 2017 7:03 AM

    cnitzsche - Wednesday, February 8, 2017 11:03 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

    February 9, 2017 at 7:20 am

    #1927523

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Wednesday, February 8, 2017 2:31 PM

    Didn't Redgate have a tool for creating deployment packages for SQL Databases?  It has...

    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, 2017 at 3:27 pm

    #1927415

  • RE: CTE Recursive Query

    robertopmorris - Wednesday, February 8, 2017 12:51 PM

    I have a table with the following fields:
    ParentWO
    IssueQty
    ChildWO
    Production_Qty
    Qty_Complete

    I want to write a recursive statement 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 8, 2017 at 1:32 pm

    #1927406

  • RE: Interview Question

    Steve Thompson-454462 - Wednesday, February 8, 2017 8:30 AM

    I'd throw in my vote for not loading up stored procs with business rules....

    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, 2017 at 9:10 am

    #1927362

  • RE: Your Favorite Feature that Needs Work

    GilaMonster - Wednesday, February 8, 2017 4:57 AM

    Thom A - Wednesday, February 8, 2017 3:04 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, 2017 at 6:35 am

    #1927303

Viewing 15 posts - 1,576 through 1,590 (of 8,731 total)