SQL Feeds - All your SQL feeds in one place.

Tuesday, March 10, 2009

Things You Know Now

by KKline via Kevin Kline on 3/10/2009 9:47:00 PM

I was recently tagged by Chris Shaw, in his blog post Things You Know Now, with the thread started by Michelle Ufford (aka the SQLFool), in her blog post also entitled Things You Know Now.  In the original thread, Michelle asks "It doesn't have to be DBA skills, but what do you wish you knew when you were starting?" Of course, I wish I knew the top and bottom value of a lot of stocks years before anyone else did.  That'd make Kevin a very wealthy dude.  It would als ...

[ read more ]

Geek City: Two Compression Questions and Parameter Metadata

by Kalen Delaney via Kalen Delaney on 3/10/2009 5:46:00 PM

I am teaching the SQL 2008 version of my course for the first time this week. My life is still is disarray and spare time is practically non-existent.  During the evenings after I class I am trying to get caught up on several projects that I fell way behind on over the last month when most of my time was spent in the hospital. Blogging has been put on the back burner, but I thought I could share some of the questions that came up in class on the first day.  I usually try to track ...

[ read more ]

Geek City: Two Compression Questions and Parameter Metadata

by Kalen Delaney via Kalen Delaney on 3/10/2009 5:46:00 PM

I am teaching the SQL 2008 version of my course for the first time this week. My life is still is disarray and spare time is practically non-existent.  During the evenings after I class I am trying to get caught up on several projects that I fell way behind on over the last month when most of my time was spent in the hospital. Blogging has been put on the back burner, but I thought I could share some of the questions that came up in class on the first day.  I usually try to track ...

[ read more ]

To NOLOCK Or Not?

by David L. Penton via The Penton-izer on 3/10/2009 2:05:00 AM

I was having a discussion with another DBA the other day about a particular stored procedure. It was a paging stored procedure with a number of other tasks to do. He was adamant about me including the NOLOCK hint for the SELECT statements. He ranted a bit about how it was "best practice" to use the NOLOCK hint on all SELECT statements.  I retorted with a different general statement of "let's optimize first and then see where we are."  I added that I felt it was a la ...

[ read more ]

Legal Note

The content of the postings is owned by the respective author. SQL Feeds is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on SQL Feeds, please contact us. Designated trademarks and brands are the property of their respective owners. All rights reserved.

Advertise with us