Forum Replies Created

Viewing 15 posts - 376 through 390 (of 1,187 total)

  • RE: Do You Have Scary Code?

    GilaMonster (11/10/2015)

    I've recently seen a system with many user-defined functions, each with thousands of lines of code, often calling each other. Tests or no tests, I'm not touching that.

    lol +1

    November 10, 2015 at 1:39 pm

    #1838967

  • RE: Do You Have Scary Code?

    Fear is sometimes good. 🙂 It may not reflect a well-run development process, but sometimes fear of changing code is actually warranted - it can reflect an honest admission of...

    November 10, 2015 at 1:39 pm

    #1838966

  • RE: Job Schedules

    Iwas Bornready (11/10/2015)

    I had to check the table structure of sysjobschedules. I would never have guessed that a date column was put into a purposely constructed int.

    I knew that this...

    November 10, 2015 at 7:45 am

    #1838849

  • RE: Risks of NOLOCK, part 1

    Hugo Kornelis (11/1/2015)

    Comments posted to this topic are about the item <A HREF="/questions/Nolock/132977/">Risks of NOLOCK, part 1</A>

    Thanks, Hugo. Great question.

    - webrunner

    November 5, 2015 at 12:12 pm

    #1838075

  • RE: SQL Server Capacity Planning

    sqlactions (6/4/2012)

    Hi,

    Check out this blog, it may help you asses the current capacity limits of your 'model' and further be able to determine what resources you need to build the...

    November 5, 2015 at 12:10 pm

    #1838073

  • RE: Casting

    Nice question - thanks!

    - webrunner

    October 29, 2015 at 8:41 am

    #1836403

  • RE: Restore

    Great question for learning and discussion. I also thought about the tail-log backup point that Hugo raised. But I figured since it wasn't mentioned at all that it was intentionally...

    September 30, 2015 at 9:42 am

    #1830483

  • RE: Get Server version Info

    Thanks! Very helpful.

    - webrunner

    September 29, 2015 at 11:24 am

    #1830232

  • RE: Backup log with norecovery

    Thanks, good training question.

    - webrunner

    September 29, 2015 at 8:27 am

    #1830163

  • RE: Logging Tables

    Thanks for this editorial, Steve.

    It would be great if some form of detailed auditing were available as a basic part of an RDBMS. It is such a crucial function that...

    September 28, 2015 at 9:34 am

    #1829927

  • RE: CPU Usage by Database

    Really helpful script. Thanks!

    - webrunner

    September 22, 2015 at 7:58 am

    #1828413

  • RE: SQL Job Timeline (Graphical)

    Awesome script and Excel layout. Thanks for this contribution!!

    - webrunner

    September 22, 2015 at 7:53 am

    #1828409

  • RE: What does "SET XACT_ABORT ON" mean?

    GilaMonster (4/16/2013)

    http://sqlinthewild.co.za/index.php/2011/05/17/on-transactions-errors-and-rollbacks/

    Thanks, Gail - that was a great explanatory article!

    FYI I did notice that one set of code in that article seems to a couple of typos:

    CREATE TABLE TestingTransactionRollbacks (

    <pre>...

    September 18, 2015 at 3:08 pm

    #1827853

  • RE: Round

    Thanks for the question and discussion. I was not aware of any of this.

    - webrunner

    September 14, 2015 at 1:24 pm

    #1826520

  • RE: What Kind of DBA Are You?

    Sean Lange (9/2/2015)

    Luis Cazares (9/2/2015)

    Sean Lange (9/2/2015)

    BrainDonor (9/1/2015)

    What's the difference between 'None of the above' and 'Other'?

    Also curious what is the difference between "Development" and "Development DBA".

    I understand it as...

    September 4, 2015 at 12:35 pm

    #1824762

Viewing 15 posts - 376 through 390 (of 1,187 total)