Viewing 15 posts - 376 through 390 (of 1,189 total)
Thanks for this thread. I realize that being careful is the way to avoid this issue, but my question is, why is this change even possible in SQL Server? The...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
November 24, 2015 at 11:29 am
Luis Cazares (11/11/2015)
webrunner (11/11/2015)
Does anyone have advice about what training might be good for an accidental DBA? I have a good deal of hands-on experience at this point...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
November 11, 2015 at 12:09 pm
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
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
November 10, 2015 at 1:39 pm
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...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
November 10, 2015 at 1:39 pm
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...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
November 10, 2015 at 7:45 am
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
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
November 5, 2015 at 12:12 pm
sqlactions (6/4/2012)
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...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
November 5, 2015 at 12:10 pm
Nice question - thanks!
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
October 29, 2015 at 8:41 am
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...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
September 30, 2015 at 9:42 am
Thanks! Very helpful.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
September 29, 2015 at 11:24 am
Thanks, good training question.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
September 29, 2015 at 8:27 am
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...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
September 28, 2015 at 9:34 am
Really helpful script. Thanks!
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
September 22, 2015 at 7:58 am
Awesome script and Excel layout. Thanks for this contribution!!
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
September 22, 2015 at 7:53 am
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>...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
September 18, 2015 at 3:08 pm
Viewing 15 posts - 376 through 390 (of 1,189 total)