The Curious Engineer

All blogs / Databases

SQL Server Code,Tips and Tricks, Performance Tuning

sqlservercode.blogspot.com

A blog about SQL Server, Books, Movies and life in general

Databases

’05’10’15’20’25
Posts
805 from 15 Sep 2005 to 17 May 2025
Posting
now and then
Kind
personal blog
Feed
http://feeds.feedburner.com/SqlServerCodetipsAndTricksPerformanceTuning

2025 1

  1. Benefits of Indexes

2021 2

  1. How to connect to a SQL Server instance on a different domain and a non default port number?
  2. After 20+ years in IT .. I finally discovered this useful command

2020 3

  1. PostgreSQL adds FETCH FIRST WITH TIES.. just like TOP n WITH TIES in SQL Server
  2. You know about waitfor delay but did you know there is a waitfor time?
  3. TVPs vs Memory Optimized TVPs

2019 18

  1. Top 10 posts from the last decade
  2. SQLSTATE 4200 Error 666 and what to do.
  3. Can adding an index make a non SARGable query SARGable?
  4. How to count NULLS without using IS NULL in a WHERE clause
  5. How to check if an Extended Event session exists before dropping it
  6. How to improve your tech skills
  7. Some numbers that you will know by heart if you have been working with SQL Server for a while
  8. Stay relevant and marketable
  9. Use sys.configurations to find features that are enabled but perhaps not used
  10. Calculating Sexy Primes, Prime Triplets and Sexy Prime Triplets in SQL Server
  11. Finding rows where the column starts or ends with a 'bad' character
  12. Using SonarQube, SonarQube Scanner and the sonar-tsql-plugin to run static code analysis
  13. Scripting out procs and user defined functions with PowerShell
  14. After 20+ years in IT .. I finally discovered this...
  15. Print.. the disruptor of batch deletes in SQL
  16. Proactive notifications
  17. Cursors and loops
  18. SQL Server Maintenance

2018 7

  1. Happy Fibonacci day, here is how to generate a Fibonacci sequence in SQL
  2. A little less hate for: String or binary data would be truncated in table
  3. First public preview of SQL Server 2019 is available for download
  4. Azure SQL Data Warehouse, Azure SQL Database and SQL Server sessions from the Build 2018 conference
  5. Webinar: SQL Server on Linux tools: SQL Server Integration Services
  6. Reinventing the wheel
  7. When uncompressing data, make sure to use the correct function

2017 35

  1. The 15 most popular posts in 2017
  2. Use T-SQL to create caveman graphs
  3. How to update 2 tables with 1 statement in SQL Server..the hard way....
  4. Foreign Keys don't always need a primary key
  5. Your lack of constraints is disturbing
  6. SQL Server does support regular expressions in check constraints, you don't always need triggers
  7. Standardized Naming And Other Conventions
  8. Do not trust the SSMS designers, learn the T-SQL way
  9. Triggers, when to use them, when not to use them
  10. Coding SQL Server triggers for multi-row operations
  11. Sargable Queries...
  12. Data types storage differences
  13. Sizing database files
  14. Why would anyone use a global temporary table?
  15. PASS tv has added a boatload of videos
  16. I don't always use a RIGHT JOIN, but when I do, it's because I am lazy
  17. Why I am learning Python and why you might need to learn it as well
  18. SSMS: When did the query finish, when did the query start?
  19. T-SQL Tuesday #92, Lessons learned the hard way
  20. Five great SQL Server GitHub repos that every SQL Server person should check out
  21. Running SQL Queries Against Baby Names from Social Security Card Applications
  22. Having fun with maxed out uniqifiers on a non unique clustered index
  23. All the Build 2017 data related sessions in 1 spot, SQL Server, CosmosDB, Azure SQL DB and more
  24. Not sure that I like the message from Online Resumable Index Rebuild in SQL Server 2017
  25. SQL Server 2017: SQL Graph
  26. SQL Server 2017: SELECT INTO File Group
  27. How to shut down SQL Server
  28. Security in SQL Server on Linux Microsoft Engineering Town Hall
  29. The strange case of the missing indexes....
  30. Importing The Metropolitan Museum of Art's Open Access Initiative data into SQL Server
  31. Using bigint with FORMATMESSAGE
  32. Creating the Wide World Importers sample database v1.0
  33. T-SQL Tuesday #86: String or binary data would be truncated
  34. BULK INSERT and csv format, new in vNext 1.1
  35. Running queries against the songs you played with Alexa

2016 56

  1. The 15 most popular posts in 2016
  2. Didn't go to PASS but want to watch the sessions?
  3. SQL Server vNext version Community Technology Preview 1.1 available
  4. Interesting SQL related links for the week of Dec 16, 2016
  5. Connecting to SQL Server when your default database is not available
  6. Interesting SQL related links for the week of Dec 09, 2016
  7. Interesting SQL related links for the week of Dec 02, 2016
  8. Changing the SQL Server port on Linux
  9. You snooze you lose... I lost....
  10. What to get your friendly DBA this holiday season
  11. BULK INSERT with a file containing linefeeds gotcha
  12. Interesting SQL related links for the week of Nov 25, 2016
  13. Installing SQL Server on Linux, connecting and running queries from Linux
  14. How to read the errorlog on SQL Server installed on Linux
  15. What we learned from the reddit SQL Server AMA thread on /r/sqlserver
  16. Interesting SQL related links for the week of Nov 18, 2016
  17. SQL Server AMA thread on reddit is live now
  18. What's new in SQL Server 2016: CREATE OR ALTER
  19. Playing around with the new stuff in SQL Server vNext and SQL Server 2016 SP1
  20. SQL Server 2016 SP1 released, SQL Server vNext available for download
  21. What's new in SQL Server 2016: Truncate partitions
  22. Interesting SQL related links for the week of Nov 11, 2016
  23. What was the first computer you bought, what were some of your favorite games?
  24. Sometimes, you can stare at something for 5 minutes before seeing it
  25. Why you need additional privileges to truncate tables compared to delete statements
  26. Did you know that the MSSQL Tiger Team has a GitHub repo?
  27. Interesting bug with milliseconds and datetime on SQL Server 2016
  28. Are your foreign keys indexed? If not, you might have problems
  29. Want to know if your connect item is fixed? There is a twitter account for that
  30. The best thing about the PASS summit for me is...
  31. Two free SQL Server books from Microsoft Press
  32. No, you are not getting the dark theme for SSMS anytime soon
  33. Some cool SQL Server announcements SQL Graph, Adaptive Query Plan, CTP1 of SQL vNext, SQL Injection detection
  34. SQL Pass Summit 2016... day 5
  35. SQL Pass Summit 2016... day 4
  36. SQL Pass Summit 2016... day 3
  37. SQL Pass Summit 2016... day 2
  38. SQL Pass Summit... SQL Teaser Transactions
  39. PASS Summit 2016 sessions I am attending
  40. If you are going to PASS Summit 2016, build your schedule today
  41. Living in the NYC tri-state area? Attend the SQL 2016 Launch Event in NYC on June 2nd
  42. How to disable tests in tSQLt
  43. SQL Server 2016 will be generally available on June 1, 2016
  44. Microsoft releases SQL Server Horizontica, a Vertica killer
  45. The most interesting Build sessions for people working with data
  46. How to get SQL Server on Linux?
  47. SQL Server 2016 Release Candidate 0 now available for download
  48. Gotcha with the LEAD analytical function and date datatype
  49. Did you know I have a github repository for stuff I run over and over?
  50. Easy running totals with windowing functions
  51. #BackToBasics returning rows with maximum values from a table
  52. How to store twitter search results from R into SQL Server
  53. Quickly change m/d/yyyy dates to mm/dd/yyyy dates in Excel
  54. The one change I make to each tSQLt database
  55. #BackToBasics: Returning all rows from one table that do not exists in another table
  56. A challenge for 2016....... accepted!

2015 25

  1. TempDB Database changes in SQL Server 2016
  2. SQL Server 2016 Community Technology Preview 3.0 is now available for download
  3. SQL Server 2016 Community Technology Preview 3.0 will be available this week
  4. How much memory does a SQL Server connection use?
  5. Some reasons your tSQLt test is not executing
  6. Your first step in dealing with SQLState = S1000 I/O error while writing a BCP data-file
  7. Unit testing in SQL Server, a list of all the posts
  8. Unit testing in SQL Server, installing tSQLt and doing a quick test
  9. Dropping all objects in a schema
  10. Unit testing in SQL Server, taking a first look a tSQLt
  11. Unit testing in SQL Server..what are unit tests
  12. Unit testing in SQl Server... why?
  13. Whenever you use the designer in SSMS, click on the Generate Change Script icon to verify what it will do
  14. Review of SQL Performance Explained by Markus Winand
  15. Dealing with temporary tables and named constraints
  16. Defaults with parameters in SQL Server stored procedures gotcha
  17. It is ten years ago that I wrote my first blogpost
  18. Links to a handful of posts I created today
  19. Questions for SQL Server MVPs
  20. My last day as a SQL Server MVP
  21. Awesome SSMS shortcuts that will save you tons of time
  22. Pass Summit 2014 pre-conference day 2
  23. My 3 favorite sessions at PASS Summit 2014
  24. What is a valid variable name in T-SQL?
  25. Did you know you can pass false and true to SQL Server bit parameters?

2013 1

  1. My non SQL blog is up

2012 4

  1. SQL Advent 2012: Recap
  2. SQL Advent 2012 has started
  3. SQL Advent Recap and What is coming in SQL Server 2012 recap
  4. OT: Being healthier as a geek

2011 2

  1. SQL Advent 2011 series of posts
  2. 6 new SQL Server Denali CTP3 posts

2010 1

  1. Post I created about SQL Server Denali

2009 3

  1. Win A Copy Of SQL Server 2008 Administration in Action
  2. 10 must read SQL Server posts by Ted Krueger
  3. Some SQL Server posts I wrote lately and I now have a RSS feed just for my posts on lessthandot.com

2008 85

  1. With this post I bid you all adieu
  2. SQL Server 2005 Service Pack 3 Beta and SQL Server 2008 Feature Pack October 2008 available for download
  3. today is a sad day
  4. Help me win this bet
  5. Interview With Louis Davidson Author of Pro SQL Server 2008 Relational Database Design and Implementation
  6. Interesting Bug/Feature In SQL Server 2008 RTM
  7. Only In A Database Can You Get 1000% + Improvement By Changing A Few Lines Of Code
  8. SQL Tip, Compiling Your SQL Without Running It to See If It Would Run
  9. Microsoft Visual Studio 2008 Service Pack 1 Available For Download
  10. SQL Server 2008 is RTM
  11. Microsoft Visual Studio Team System 2008 Database Edition GDR July CTP Released
  12. sp_indexinfo an enhanced index information procedure
  13. Awesome Collection Of ASP.NET Hacks, Tips and Tricks
  14. Interview With SSIS Guru Jamie Thomson
  15. I tried to keep it a secret but it is all over the internet: I am a SQL Server MVP
  16. Working On SQL Admin Hacks, Tips and Tricks
  17. SQL Server 2008 Release Candidate 0 Available To The General Public For Download
  18. Puzzle: Friday the Thirteenths
  19. Less Than Dot A New community Site Has Been Launched
  20. SQL Teaser uniqueidentifier
  21. Interview With Erland Sommarskog About SQL Server and Transact SQL
  22. Interview With Craig Freedman About Indexing, Query Plans And Performance
  23. I have a question for you on DB development blunders!
  24. Spring Cleaning, Getting Rid Of Some Books
  25. SSMS Tools PACK 1.0 is now available
  26. How to log when a function is called?
  27. SQL Teaser: @@ROWCOUNT
  28. Should SQLServer Have The CREATE [OR REPLACE] PROCEDURE Syntax?
  29. What Would You Like To Ask Erland Sommarskog?
  30. What Would You Like To Ask Craig Freedman?
  31. Do you depend on sp_depends (no pun intended)
  32. Testing for SQL Server Vulnerabilities
  33. Who do you want to see interviewed next?
  34. SQL Teaser: Some Things Are Not What They Seem
  35. How to rename a column in a SQL Server table without using the designer
  36. Interview With Stéphane Faroult About Refactoring SQL Applications
  37. Solutions for Common T-SQL Problems Wiki Launched
  38. Use IDENT_CURRENT() to return the last identity value generated in all tables in a SQL Server Database
  39. Links Of The Week 20080414
  40. Video: SQL Server Data Services Architecture
  41. Links Of The Week 20080405
  42. Database Refactoring Interview With Scott W. Ambler
  43. SQL Champ - A Quiz to Prove Your SQL Knowledge
  44. Not An April Fool’s Joke: SQL Server 2000 Mainstream Support Ends In A Week
  45. Links Of The Week 20080330
  46. How To Use COALESCE And NULLIF To Prevent Updating Columns When A Parameter IS NULL Or A Default Value
  47. Technet Radio: A Look Inside SQLCAT (SQL Customer Advisory Team)
  48. Links Of The Week 20080322
  49. SOT: I found a new 'worst query'
  50. What tastes better, Microsoft SQL Server 2005 or Oracle 11g?
  51. Links Of The Week 20080317
  52. 6th Annual Financial Services Developer Conference
  53. StrataFrame Or CSLA.NET, Which Framework Would You Use?
  54. Video: SQL Server Data Services and the Future of Data in the Cloud
  55. Microsoft Announces SQL Server Data Services
  56. In SQL Server 2008 The CONVERT function is enhanced to allow conversions between binary and character hexadecimal values
  57. 46 New Dynamic Management Views In SQL Server 2008 CTP6
  58. Microsoft SQL Server 2008 Feature Pack CTP, February 2008
  59. SQL Server 2008 February CTP is now available for public download
  60. If Airplanes Were Made By Using Scrum/Agile
  61. Weekly Links 20080217
  62. HTTP Endpoints deprecated In SQL Server 2008, Just Like Notification Services
  63. SQL Server 2008 Whitepapers
  64. This is just awesome
  65. SQL Server 2008: When Was The Server Last Started?
  66. Review of Inside Microsoft SQL Server 2005 Query Tuning and Optimization
  67. 33 New Dynamic Management Views In SQL Server 2008
  68. Windows Server 2008 and Vista SP1 releasing to manufacturers today
  69. Should You Get Your Database Under Version Control?
  70. Vote for SQL Server 2005 Service Pack 3
  71. Some Very Sad News For The SQL Server Community
  72. SQL Server 2008 To RTM In Q3 2008
  73. Tip: Find all The Rows Where Any Of The Columns Is Null Or Zero Or Both
  74. Some Links To Blogs By Some Friends Of Mine
  75. SQL Server 2005 Best Practices Analyzer (January 2008) Available For Download
  76. The last two days have been the worst of my life
  77. Yet Another Date Teaser
  78. Has Anyone Succeeded In Creating A Collision Between NEWID and NEWSEQUENTIALID
  79. I won't be flying on this sucker
  80. The World Is Small, The Risk Of Your Data Being Stolen Is Not!
  81. Use the *1 trick to do math with two varchars, this prevents the Invalid operator for data type. Operator equals subtract,type equals varchar message
  82. Top Ten Posts Of 2007
  83. Top Ten Posts Of All Time
  84. Wow, talking about a rant against Ruby On Rails
  85. You know What I Am Trying To Say :-)

2007 255

  1. The Best Geek Story Ever Told
  2. A year in review, The 21 + 1 best blog posts on SQLBlog
  3. Red Gate SQL Data Generator 1.0 Beta Available For Download
  4. The Sad State Of Programmers Part 3: General Tips
  5. Alien VS Predator picture
  6. help hisham to set up an online business, aka begging on the web
  7. Screencast: SQL Server 2008 Change data capture
  8. I am stuffed
  9. SharePoint and SQL Server Reporting Services Posts
  10. Kids Might Become Overwhelmed Tomorrow
  11. Stop The Press, Internet Explorer 8 Passes ACID 2 Test
  12. Interview With Joe Celko About The Forthcoming Book Thinking In Sets
  13. Use XACT_STATE() To Check For Doomed Transactions
  14. EXISTS or COUNT(*)
  15. GNET: Even Google Screws Up By Showing A Bunch Of MySQL Messages
  16. Would You Put Your Database In The Cloud?
  17. SQL Server Business Intelligence Screencasts
  18. The Strange Case OF Nulls And Case
  19. Retrace : A SQL Profiler Trace Swiss Army Knife
  20. SQL Teaser: LEN vs DATALENGTH
  21. Office 2007 Service Pack 1 Available For Download
  22. The Sad State Of Programmers Part 2 : The In Person Interview
  23. Video: Microsoft SQL Server 2008 Nov CTP - Spatial (Part 1/3)
  24. The Most Natural Set Option
  25. The Sad State Of Programmers Part 1 : The Phone Interview.
  26. EURO 2008 draw
  27. Screencast: SQL Server 2008 - Table valued parameters
  28. Integer Math In SQL Server
  29. Visual Studio 2008 Training on Channel 9
  30. .NET Framework 3.5 Common Namespaces and Types Poster Available For Download
  31. World Cup Soccer 2010 Qualification - UEFA draw, England And Croatia In The Same Group Again!
  32. Whitepaper on Malware to Attack Databases
  33. Just For My English Friends
  34. Thanksgiving SQL Teaser COUNT
  35. Visual Studio 2005 Support for SQL Server 2008, Community Technology Preview
  36. Surface Area Configuration Tool Is Discontinued, SQL-DMO Removed from Microsoft SQL Server 2008 Express
  37. Microsoft SQL Server 2008 CTP November 2007 Available For Download
  38. Visual Studio 2008 RTM Available On MSDN
  39. Visual Studio 2008 Available For Download Early Next Week
  40. Microsoft Buiness Intelligence Screen Casts
  41. INTERCEPT In SQL Server 2005
  42. How Is Your Sensitive Data Encrypted In The Database?
  43. SQL Teaser: Printing Without Using PRINT
  44. E-Learning: What's New in Microsoft SQL Server 2008
  45. Return Null If A Value Is A Certain Value
  46. Christmas Is Coming Early This Year
  47. Microsoft Commits to November Release Date for Visual Studio 2008 and the .NET Framework 3.5
  48. How many Java programmers does it take to round up to a power of two?
  49. Do you want to laugh or cry?
  50. Sort Values Ascending But NULLS Last
  51. Interview With Kalen Delaney About Inside Microsoft SQL Server 2005 Query Tuning and Optimization
  52. SQL Server 2008 Whitepapers
  53. SQL Teaser: Guess the output
  54. Self-paced Course: What's New in Microsoft SQL Server 2008
  55. LAMP + Porn = perfect Job?
  56. How to find out the recovery model for all databases on SQL Server 2000, 2005 and 2008
  57. SQL Teaser: Guess the output
  58. Screencast: SQL Server Analysis Services what's in it for me?
  59. SQL Teaser PASS Special: Table Size
  60. SQL Injection Cheat Sheet
  61. Cumulative update package 3 for SQL Server 2005 Service Pack 2 is available
  62. SQL Gotcha: Do you know what data type is used when running ad-hoc queries?
  63. Microsoft SQL Server 2008 CTP 4 Released
  64. Download LINQPad
  65. Spam so bad it is funny
  66. Summer SQL Teaser #13 Numeric
  67. geekSpeak recording - Real World SQL Server Integration Services with Matthew Roche
  68. Late Summer Cleaning
  69. Microsoft Gains Momentum in Business Intelligence Market as It Prepares to Launch Major BI Offerings
  70. SQL Server 2008 Live Meeting Event on August 21st on DateTime function
  71. Do you know how NULLIF and non-deterministic functions work?
  72. Article: LINQ to SQL (Part 6 - Retrieving Data Using Stored Procedures)
  73. SQL Server 2008 Webchat and Live Meeting Series
  74. Summer SQL Teaser #12 Missing Dates
  75. SQL Server Monitor Gadget for Windows Vista Sidebar
  76. Agile: Planning Poker and Scrum
  77. Showtime You Tricked Me, Shame On You
  78. Becoming A Better Programmer In 6 Months: The First 20 days
  79. Summer SQL Teaser #11 NULLIF
  80. SQL Server 2008 Has Nanosecond Precision?
  81. SQL Server Notification Services Removed from SQL Server 2008
  82. SQL Server 2008 July CTP Has Been Released, The 10 New Features
  83. Say Hello To My New Boss
  84. Cannot resolve collation conflict for equal to operation.
  85. Have You Seen 300?
  86. Summer SQL Teaser #10 ROLLBACK
  87. Visual Studio 2008 Beta 2 Released!
  88. Becoming A Better Programmer In 6 Months: The First 10 days
  89. This has to be one of the worst planned projects in recent Database history
  90. Visual Studio Team Edition for Database Professionals Service Release 1 Is Here
  91. SQL Server Podcast: James Luetkehoelter Talks About Disaster Recovery Planning
  92. Summer SQL Teaser #9 @@TRANCOUNT
  93. Summer SQL Teaser #8 Comments And Go
  94. Some Pics
  95. The Internet has Crashed
  96. Non-Technical: Happy Birthday Twins
  97. Become a Better Developer... in 6 months
  98. Best Practice: Backups
  99. DMVStats (A SQL Server 2005 Dynamic Management View Performance Data Warehouse ) Released
  100. Summer SQL Teaser Datetime Yet Again
  101. Summer SQL Teaser: Datetime
  102. Oracle Unveils Oracle Database 11g
  103. SQL Server 2008 will launch on Feb. 27, 2008
  104. Giving Away 2 Invites For Pownce
  105. SQL Controversy: Capitalizing Keywords
  106. Summer SQL Teaser Non Existing Database
  107. SQL Server 2005 Best Practices Analyzer Released, End Of Support For SQL Server 2000 SP3a In 6 Days
  108. SSIS Script Task In SQL Server 2008 Can Use VB Or C#
  109. Guess What I Will Be Doing Tomorrow (June 29th 2007) At 6PM
  110. Summer SQL Teaser #4 Nulls and Counts
  111. Good Distributed Partitioned Views / Federated Databases Article
  112. Which SQL Server 2005 Analysis Services Book Should I Get?
  113. Book Review: Expert SQL Server 2005 Development By Adam Machanic
  114. C# IsNullOrEmpty Function In SQL Server
  115. SQL Myth: Truncate Cannot Be Rolled Back Because It Is Not Logged
  116. Three New SQL Server Best Practices Articles On TechNet
  117. SQL Teaser NULL vs COALESCE
  118. How To Protect Yourself From Fat-Finger Sally, Crazy Bosses and Other SQL Villains
  119. SQL Server 2008 Is RTM (According to SERVERPROPERTY('productlevel'))
  120. SQL Server 2008 (Katmai) Cannot Be Installed On A PC With SQL Server 2000 On It
  121. SQL Server 2008 June CTP now available!
  122. SQL Server 2008/Katmai Webcast
  123. Did You Know SQL Server Has A Black Box Like An Airplane?
  124. Excel 2007 Files Are WinZip/WinRAR Files In Disguise
  125. Sam Gentile Reviews RubyMicrosoft Essay By Martin Fowler
  126. Speed Up Performance And Slash Your Table Size By 90% By Using Bitwise Logic
  127. Blogging On sqlblog.com
  128. Check Your SQL For SQL Injection Vulnerabilities By Using These 15 Free SQL Injection Scanners
  129. Top 10 .NET Framework Technologies to Learn in 2007. What do you think?
  130. Object Databases Suck RDMBS's Rock
  131. Book Review: Pro SQL Server 2005 Database Design and Optimization
  132. Inconvenient Truth???
  133. It's Time For Violence: A song about Databases vs CodeMonkey
  134. Interview with Adam Machanic Author Of Expert SQL Server 2005 Development
  135. flickrvision
  136. Google: A Girl's Best Friend
  137. Make Your Case Sensitive Searches 1000 Times Faster
  138. Great Programming Quote
  139. Why Does OBJECTPROPERTY Have A TableIsFake Property?
  140. Some Katmai (SQL Server 2008?) News
  141. Three Ways To Return All Rows That Contain Uppercase Characters Only
  142. Public CTP of Visual Studio Team Edition for Database Professionals first Service Release Available For Download
  143. How Do Spammers/Phishers Get People To Click On A Link With An Email Like This?
  144. Nice Silverlight Developer Reference Poster
  145. Microsoft SQL Server Community Samples: Service Broker On CodePlex, Astoria and Jasper Announced
  146. SIMP = Silverlight + IIS + MySQL + PHP
  147. I-Hate-Oracle Club Forum On Worse Than Failure
  148. Podcast With Jeff Atwood From Coding Horror
  149. Lambda Expressions, LINQ, DLINQ And XLINQ Samples For Orcas
  150. Virus A Very Addictive Game
  151. Microsoft SQL Server Reporting Services Management Changes In Katmai
  152. You Should Never Use IN In SQL To JOIN With Another Table
  153. AdventureWorksLT Sample Database Available For Download, Don't Forget To Attach The DB To See It
  154. ORDER BY 1 Will Not Work In LINQ The Same As In SQL
  155. Stop messing around with SQL Server 2005 SP2 and give us SP3 ASAP!
  156. Visual Studio Orcas Beta 1 Available For Download
  157. Interview With Itzik Ben-Gan Author Of Inside Microsoft SQL Server 2005: T-SQL Querying
  158. Flamed By Celko?
  159. The Chapter On SQL Server 2005 Service Pack 2 Is Closed
  160. Does Anyone Use ~ (Bitwise NOT)?
  161. Hilarious Paris Hilton Subway Ad
  162. Script Multiple Procs With Create And Drop Statements In SQL Server 2005
  163. Sopranos: Bobby Baccalla beats the crap out of Tony Soprano
  164. The Real Microsoft Vista Marketing
  165. Two New Hotfixes Available To Fix The Maintenance Plan Issues Caused By SQL Server 2005 SP2
  166. April 8th Is Almost Here
  167. SQL Server 2007 Beta1 CTP Released
  168. SQL Server 2005 Books Online Scoped Search Provided By search.live.com
  169. TEMPDB and SQL Server 2005 Tip
  170. A list of SQL Server 2005 Whitepapers and SQL Server 2000 Whitepapers
  171. How Not To Do Search Engine Optimization
  172. SQL Server 2005 SP2 Has Added The OBJECT_SCHEMA_NAME Function, OBJECT_NAME Has Been Enhanced
  173. 30 + Tools and Hacks for Gmail
  174. Microsoft SQL Server Samples and Community Projects On CodePlex
  175. The Ten Most Asked SQL Server Related Programming Questions In Newsgroups
  176. SQL Server Speaks Almost As Many Languages As I Do
  177. Microsoft Joins OpenAjax
  178. Perfect SQL Developer Setup
  179. St. Patrick's Day Joke: Irish Daughter
  180. Google Buys Gapminder
  181. Don't Know What To Say In Meetings?
  182. Amazon Elastic Compute Cloud (Amazon EC2)
  183. Online Indexing Operations in SQL Server 2005 Whitepaper Available For Download
  184. Did You Have Your Pie On Pi Day?
  185. GMail Storage Will Be 3560 MB on April 1st 2012
  186. Priceless Comment About Slashdot Users
  187. How To Get The Database Name For The Current User Process
  188. SQL Server 2005 Performance Dashboard Reports Available For Download
  189. R.I.P Visual FoxPro
  190. map of the world, based on the frequency of its locations mentioned in books.
  191. Wladimir Klitschko Knocks Out Ray Austin In The Second Round
  192. Scribd: The YouTube Of Documents
  193. Windows Server 2003 Service Pack 2 x64 Edition Release Candidate Available For Download
  194. how to save a whole heap of money on SQL Server 2000 licenses
  195. Can you solve Joe Celko's SQL puzzles? Three puzzles. Many answers.
  196. Visual Studio 2005 Service Pack 1 Update for Windows Vista Available For Download
  197. SQL Server 2005 Service Pack 2a?
  198. .NET Rocks Podcast: Paul Randal on SQL Server 2005 Performance and Recovery
  199. How To Make A FileGroup Read Only in SQL Server 2005
  200. ASP.NET Library Site Launched
  201. Arrays and Lists Article Updated For SQL Server 2005
  202. The Digg Effect
  203. Top 5 Post and Google Searches For Jan and Feb 2007
  204. Top Ten Posts Of All Time
  205. How Do I? video series focused on SQL Server 2005 Express
  206. Visual Studio Code Name "Orcas" - March 2007 Community Technology Preview (CTP) Available For Download
  207. Using ALTER INDEX…REBUILD To Rebuild A Clustered Index Does Not Rebuild Its Nonclustered Indexes By Default On SQL Server 2005
  208. Failure Trends in a Large Disk Drive Population
  209. The Real Reason Why Condoleezza Rice Never Smiles
  210. Math Geniuses?
  211. How To Find Out Which Columns Have Defaults And What Those Default Values Are
  212. SQL Server 2005 Best Practices Analyzer (February 2007 CTP) Available For Download
  213. SQL Server 2005 Books Online Is Not Part Of The Service Pack 2 Download
  214. February 2007 Feature Pack for Microsoft SQL Server 2005
  215. Podcast With Dr. Peter Chen on the Entity Relationship Model and ADO.NET Entity Framework On Channel 9
  216. Microsoft Releases SQL Server 2005 Service Pack 2
  217. Chuck Boyce Has Some Joe Celko Videos On YouTube
  218. Man sues IBM over firing, says he's an Internet addict
  219. Clerks II: Starwars vs Lord of the Ring Clip On YouTube
  220. Podcast With SQL Maven Joe Celko
  221. How Is SQL Server Books On Line Created?
  222. The Sysinternals Troubleshooting Utilities have been rolled up into a single Suite of tools
  223. Microsoft .NET Micro Framework Is Now Available
  224. Ten SQL Server Functions That You Hardly Use But Should
  225. Clippy Is Not Dead, Clippy Is Alive.....On Linux
  226. Wal-Mart Wine
  227. ASP.NET:DataFormatString Doesn't Work In A GridView If HtmlEncode Is True
  228. How to Backup Your Blogger Blog
  229. Use A Combination OF NULLIF and COALESCE TO Display A Custom Value
  230. SSIS Connectivity White Papers Available On Microsoft's Site
  231. What Happens When You Let a Three Year Old Use Your Computer For 2 Minutes?
  232. More Than 10 Tips To Help Your Virtual PC Performance.
  233. John Carpenter’s The Thing
  234. Give Me One Good Reason Why You Would Store Documents In The Database?
  235. SQL Server 2005 High Availability Podcast On DotNet Rocks
  236. How To Restart A Remote Computer
  237. Need Help With Picking Out An ASP.NET 2.0 Book
  238. ASP.NET AJAX PDF Cheat Sheets Available For Download
  239. Are You ready For Daylight Saving Time Changes In 2007
  240. ASP.NET AJAX Version 1.0 Released
  241. Microsoft SQL Server Database Publishing Wizard 1.0,SharePoint Server 2007 SDK And Windows SharePoint Services v3 SDK Available For Download
  242. Check If Auto Update Statistics Is Enabled With DATABASEPROPERTY
  243. SQL Server Doesn't Like Cheaters
  244. A Witchbrew Of SQL Server News And Interesting Links
  245. sp_refreshview
  246. Visual Studio Code Name "Orcas" - January Community Technology Preview (CTP) Released
  247. How To Check If Any, ALL Or No Parameters Have A NULL Value
  248. SQL Server Integration Services 2005 Connectivity Whitepaper Available At ssis.wiki.com
  249. Increase Your Productivity With Query Analyzer
  250. SQL Server 2005 Express Edition for Beginners Learning Videos Available
  251. Difference of two datetime columns caused overflow at runtime
  252. Blogstats For The Year 2006
  253. Top Google Searches For December 2006 And For 2006
  254. Top 10 Posts For The Year 2006
  255. Dynamic Search Conditions In T-SQL Has Been Updated

2006 253

  1. The Road to Hell By Chris Rea Or Highway to Hell By AC/DC
  2. SQL Server 2005 SP2 Backup With Vardecimal Enabled Can't Be Restored On SQL Server 2005 SP1 or Earlier
  3. Guess Who Gave This Answer In A Newsgroup?
  4. Sweet Child O' Mine By Guns N' Roses Or Child in Time By Deep Purple?
  5. sys.dm_db_session_space_usage
  6. Whole Lotta Rosie By AC/DC or Whole Lotta Love By Led Zeppelin?
  7. Display 1 When Any Column Is 1 And 0 Otherwise by Using SIGN, SUM Or (Bitwise OR)
  8. SQL Server 2005 Will Be Supported On Vista And Windows Server Longhorn
  9. SQL Server 2005 Service Pack 2 - Community Technology Preview (CTP) December 2006 Available For Download
  10. How Well Do You Interview And Do You Use Wizard Driven Programming?
  11. BadVista: The Worst FUD You Will Ever Read.... St. Ignucious Has Gone Wild
  12. Three Ways To Display Two Counts From a Table Side By Side
  13. Visual Studio 2005 Service Pack 1 (SP1) Released
  14. Index Build Strategy In SQL Server
  15. Problems With ROW_NUMBER() In A WHERE Clause
  16. SQL Server 2005 Practical Troubleshooting: The Database Engine Is Shipping!
  17. Visual Studio Team Edition for Database Professionals links
  18. Wedding Anniversary
  19. Plan For The Day…Gone Wrong In a Big Way
  20. Get The Domain Name Of Your SQL Server Machine
  21. Visual Studio 2005 Team Edition for Database Professionals Released to Manufacturing
  22. Top 5 Posts For November 2006
  23. Top SQL Server Google Searches For November 2006
  24. Interview With SQL Server MVP Louis Davidson: Author Of Pro SQL Server 2005 Database Design and Optimization
  25. Use SCHEMABINDING In Views To Protect Against Alteration Or Dropping Of Tables
  26. Do You Use Partitioned Views Or Indexed Views In SQL Server 2000
  27. SQL Server - Best Practices Site Available On TechNet
  28. Auto Update Statistics Asynchronously.
  29. Happy Thanksgiving
  30. Windows Vista Consumer Launch Countdown Gadget
  31. Upgrading My Skills To SQL Server 2005
  32. SQL Hacks
  33. SQL Server 2005 - Service Pack 2 - Web Chat Today At 9AM PST
  34. Twisted Sister: Twisted Christmas
  35. Visual Studio Team Edition for Database Professionals RTM has been set for Nov. 30, 2006
  36. Going Mobile with SQLServer Compact Edition Podcast On Channel 9
  37. Use SESSIONPROPERTY To Check If NUMERIC_ROUNDABORT Is On Or Off
  38. sys.sp_estimated_rowsize reduction_for_vardecimal
  39. SQL Server 2005 Service Pack 2 CTP (November 2006) Download Links
  40. Windows Vista RTM
  41. SQL Server 2005 Service Pack 2 CTP
  42. SQL Server 2005 Script Repository
  43. How Are Dates Stored In SQL Server?
  44. ISO-11179 Naming Conventions
  45. SQL Teaser
  46. Top 5 Posts For October 2006
  47. Top SQL Server Google Searches For October 2006
  48. Download A FREE Trial Of Spotlight On SQL Server And Win A Xbox 360
  49. Working Four Days A week Until Next Year
  50. Halloween SQL Teaser
  51. One Of The Reasons I Participate In Forums And Newsgroups
  52. What Are You Watching On Halloween?
  53. SQL Server experienced revenue growth of over 30%
  54. Enable xp_cmdshell In SQL Server 2005 With The Surface Configuration Tool Or With A Script
  55. http://sqlservercode.blogspot.com In Top 100000 On Technorati
  56. Microsoft Changing Live Search Back To MSN Search
  57. Do You Know How Between Works With Dates?
  58. SQL Server 2005 Practical Troubleshooting: The Database Engine Sample Chapter Available
  59. SQLQueryStress Beta 1 Available For Download
  60. Visual Studio Team Edition for Database Professionals CTP 6 Is Available For Download
  61. SQL Server Database Publishing Wizard CTP 1 released
  62. Scrum
  63. Hello OUTPUT See You Later Trigger Or Perhaps Not?
  64. Saving A DTS Package On Another Server
  65. Datamining Speech In SQL Server 2005
  66. SQL Teaser/Puzzle Inspired By Hugo Kornelis
  67. An Interview With Ken Henderson About The Forthcoming Book SQL Server 2005 Practical Troubleshooting: The Database Engine
  68. sys.identity_columns
  69. Non Technical: What Sleepless Nights?
  70. SQL Server Utility SQLIOSim Is Available For Download
  71. Yahoo Launches .NET Developer Center, Windows Vista RC2 Available For Download
  72. SQL Server Blog Of The Week: Snaps & Snippets By Mi Lambda (Matija Lah)
  73. SQL Challenge: Random Grouping Of Data
  74. Answer To A SQL Challenge By Omnibuzz (SQL Garbage Collector)
  75. Red Gate's SQL Refactor Public CTP Released
  76. Three Team Edition for Database Professionals Screencasts On Channel 9
  77. SQL Server Teaser
  78. Top 5 Posts For September 2006
  79. Top SQL Server Google Searches For September 2006
  80. iWoz: From Computer Geek to Cult Icon: How I Invented the Personal Computer, Co-Founded Apple, and Had Fun Doing It
  81. Return All 78498 Prime Numbers Between 1 and 1000000 Continues in the Land Down Under
  82. Trouble With ISDATE And Converting To SMALLDATETIME
  83. SQL Server Application Platform Podcast About SQL Server Service Broker On Channel 9
  84. Cool And Sexy New SQL Server Blog
  85. Return A Rowcount By Using Count Or Sign
  86. Happy One Year Anniversary
  87. Return All 78498 Prime Numbers Between 1 and 1000000 In 3 seconds
  88. Five Ways To Return Values From Stored Procedures
  89. You Can Rollback Tables That You Have Truncated (Inside A Transaction)
  90. DDL Trigger Events Documented In Books On Line
  91. Do Not Concatenate VARCHAR and VARCHAR(MAX) Variables
  92. O'Reilly Code Search
  93. What Is Your Corporate Standard
  94. The sum or average aggregate operation cannot take a bit data type as an argument
  95. sys.dm_db_index_usage_stats
  96. Don't Use Union On Tables With Text Columns
  97. SQL Server 2005 Failover Clustering White Paper
  98. Kalen Delaney Has Finished Inside SQL Server 2005: The Storage Engine And Is Also Blogging On SQLblog.com
  99. Microsoft SQL Server 2005 Everywhere Edition Access Database Synchronizer
  100. Count Those Parentheses
  101. SQL Server 2005 And SOA (Service-Oriented Architecture)
  102. SQL Server 2005 Best Practices Analyzer Coming Soon??
  103. Top SQL Server Google Searches For August 2006
  104. Top 5 Posts For The Month Of August
  105. sys.dm_exec_sessions
  106. Dynamic Management Views Blog Post Series Coming To A Screen Near You
  107. A SQL Super Hero Is Born
  108. Visual Studio 2005 Team Edition For Database Professionals Review On Regdeveloper
  109. Round Up Or Down To Nearest Percentage Value By Using FLOOR And CEILING
  110. Win One Of Ken Henderson's SQL Server Guru Books By Creating A PhotoShop Joe Celko Action Figure
  111. Friday Joke and Frappr Map Update
  112. SqlServerCode Frappr Map
  113. Quest Toad for SQL Server 2.0 Released
  114. DDL Trigger Events Revisited
  115. Architecting Microsoft.com – SQL Server Podcast And Video
  116. Query Multiple Databases
  117. Analysis Services Stored Procedure Project Released On CodePlex
  118. Use The Sieve of Eratosthenes To Find All PrimeNumbers Below 1 Million
  119. Try Quest LiteSpeed And Win An iPod Nano (Hopefully)
  120. SQL Server Book Sales Up 98% Compared To Last Year
  121. Store The Output Of A Stored Procedure In A Table Without Creating A Table
  122. Top SQL Server Google Searches For July 2006
  123. 6 Different Ways To Get The Current Identity Value From A Table
  124. @@ROWCOUNT And Trigger Woes
  125. Integer Math In SQL Server
  126. Return All the Rows From A Table Where At Least One Of The Columns IS NULL
  127. Undocumented Options For UPDATE STATISTICS
  128. A Father Again
  129. Flat File Bulk Import Speed Comparison In SQL Server 2005
  130. Three Ways To Get The Time Portion Of A Datetime Value
  131. Visual Studio 2005 Team Edition for Database Professionals Interview On Channel 9
  132. Visual Studio 2005 Team Edition for Database Professionals CTP 4 Available
  133. SqlBlog
  134. Non Updating Update Performance Improvement In SQL Server 2005
  135. Setting Identity Value Back To 1 After Deleting All Rows From A Table
  136. Building SQL Server Integration Services Packages
  137. Designing Effective Aggregations In Analysis Services 2005
  138. Free Quest LiteSpeed For SQL Server Developer Edition
  139. DDL Triggers And Events
  140. Top 5 Posts For June 2006
  141. Top SQL Server Google Searches For June 2006
  142. List DDL Triggers By Using The sys.triggers Catalog View
  143. Murphy's Law And SQL Server
  144. DELETE and Subquery (IN) Problem
  145. The Difference Between Unique Constraint And Unique Index
  146. SQL Server Datetime Datatypes
  147. 3.5 Ways To Show Stored Procedure Code In SQL Server 2005
  148. 5 Reasons I Will Blog A Little Less The Next 6 Weeks
  149. Use OBJECTPROPERTY To Generate A List Of Object Types
  150. Scriptio 0.5.5 Released
  151. Check For Valid SMALLDATETIME
  152. COALESCE And ISNULL Differences
  153. Retrieve Column Info Of Table Valued Functions By Using INFORMATION_SCHEMA.ROUTINE_COLUMNS
  154. Rename A column In A Table With sp_rename
  155. Data Dude
  156. INFORMATION_SCHEMA.SCHEMATA SQL Server 2005 Change
  157. Use DATEADD And DATEDIFF To Get The Start And End Date For A Quarter
  158. Top 5 Posts For May 2006
  159. Top SQL Server Google Searches For May 2006
  160. Unit Testing For The DB, Visual Studio Team Edition for Database Professionals Is Here
  161. Import Dates, Skip Bad Data By Using ISDATE() And CASE
  162. red-gate SQL Prompt: Intellisense for SQL Server
  163. Chaos Isolation Level In SQL Server
  164. Populating A Dropdown With Weekly Dates
  165. Spatial Indexes In SQL Server 2005
  166. SQL Server Pics From Version 1.0 On
  167. SQL Server Teaser: Isolation Level
  168. Cumulative Hotfix Package (build 2153) For SQL Server 2005 Available
  169. Customers who bought this item also bought...
  170. List All Tables Without An Index
  171. SQL Compare Without The Price Tag
  172. Convert Millisecond To "hh:mm:ss" Format
  173. Syntax Error Converting The Varchar Value To A Column Of Data Type Int
  174. Changing The Schema Of A Table In SQL Server 2005
  175. String Or Binary Data Would Be Truncated
  176. Moved Into A New House
  177. Top SQL Server Google Searches For April 2006
  178. Top 10 Articles Of All Time
  179. Top 5 SQL Server Posts For April 2006
  180. A Developer’s Guide to SQL Server 2005
  181. Check For Not In Table Values (16 Different Ways And Counting)
  182. Splitting City, State and Zipcode From One Column (Or Flat file)
  183. SQL Server 2005 SP1 Books Online (April 2006) For Download
  184. How To Script Multiple Jobs Or Stored Procedures In SQL Server 2005 Management Studio
  185. SQL Server 2005 Service Pack 1 Download Link
  186. Microsoft Releases SQL Server 2005 Service Pack 1
  187. Inside Microsoft SQL Server 2005: T-SQL Querying
  188. Use PARSENAME, CHARINDEX, PATINDEX or SUBSTRING To Grab Values Up To A Certain Character
  189. Grant Execute/SELECT Permissions For All User Defined Functions To A User
  190. Grant Execute Permissions For All Stored Procedures To A User
  191. Use OBJECT_DEFINITION To Track Procedure Changes
  192. NULL Is Not 'NULL'
  193. SQL Server Everywhere Edition <> Sybase SQL Anywhere
  194. Left Join
  195. Top SQL Server Google Searches For March 2006
  196. Top 5 SQL Server Posts for March 2006
  197. SQL Server 2005 Distilled Book Published
  198. Use sp_executesql Or EXEC To Get The Count For Dynamic Table Names
  199. Use DATEADD And DATEDIFF To Get The First And Last Day Of The Month
  200. ROW_NUMBER, NTILE, RANK And DENSE_RANK
  201. Ranking In SQL Server 2000
  202. Microsoft SQL Server 2005 Jolt Winner
  203. Programming SQL Server 2005 Book
  204. OPENROWSET And Open Excel file Problems
  205. SQL Server 2005 Service Pack 1 - Community Technology Preview (CTP)
  206. OPENROWSET And Excel Problems
  207. Find Out If A Table Has An Identity Column
  208. Search All Stored Procedures That Contain Specific Text
  209. Create Stored Procedures With Optional Parameters
  210. Create Procedures That Run At SQL Server Startup
  211. Returning Grouped Random Results
  212. Conversation With Database Legend Jim Gray
  213. Pro SQL Server 2005 Assemblies
  214. SQL Server Cursors Not Always Evil
  215. Top 5 SQL Posts Of All Time
  216. Top 5 SQL Server Posts for February 2006
  217. Top SQL Server Google Searches For February 2006
  218. Find All tables That Contain A Certain Column
  219. SQL Server Upgrade Your Skills To 2005 Webcasts
  220. Three Way To List All Databases On Your Server
  221. Convert Float Stored As Varchar To Numeric
  222. SQL Server And Business Intelligence Podcast
  223. XML In SQL Server 2005 Podcast
  224. Sort A SQL Server Table With CASE Or CHARINDEX
  225. User Definded Functions And GETDATE() (nondeterministic built-in functions )
  226. Use CHARINDEX, LEN and SUBSTRING To Find Data Between Characters
  227. How To Check For A Certain Time With SQL
  228. Beginning SQL Server 2005 For Developers: From Novice To Professional
  229. Check If Temporary Table Exists
  230. SQL:Format Data From Numberformat To Timeformat
  231. SQL Server Related Webcasts For February 2006
  232. Varchar To Varbinary And Vice Versa
  233. Top 5 SQL Server Posts for January 2006
  234. Top SQL Server Google Searches For January 2006
  235. SQL Server Site Geo Map For January 2006
  236. Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. SQL 2005
  237. NULL Trouble In SQL Server Land
  238. Professional SQL Server 2005 Integration Services
  239. Format SQL Server Decimal Data
  240. Use XP_CMDSHELL To Get All File Names With Size In A Directory
  241. Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. SQL 2000
  242. Kill All Connections To Your SQL Server Database
  243. Improve Your SQL Server Skills By Helping Others
  244. sp_MSforeachtable
  245. Find All Tables Without Triggers In SQL Server
  246. ISNUMERIC SQL Server Trouble
  247. Compare Tables With Tablediff
  248. Troubleshooting Performance Problems in SQL Server 2005
  249. Contact Me
  250. Top 5 SQL Server Posts for December 2005
  251. SQL Server Site Geo Map For December
  252. Top SQL Server Google Searches For December
  253. Happy New Year

2005 54

  1. Format SQL Server Money Data Type
  2. How To Resolve A Deadlock
  3. SQL Server 2005 System Table Map PDF Download
  4. SQL Query Optimizations
  5. Test SQL Server Login Permissions With SETUSER
  6. SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach
  7. SQL Server 2005 Free E-Learning
  8. Fun With SQL Server Update Triggers
  9. Keep Your Statistics Up To Date
  10. SQL Server 2005 System View Poster
  11. SQL Server 2005 December BOL Update And Samples
  12. SQL Server Site Geo Map For November
  13. SQL Server 2005 Master Database System Views
  14. November SQL Google Searches
  15. SQL Server 2005 Sample Book Chapters
  16. Mapping SQL Server 2000 System Views To SQL Server 2005
  17. SQL Server 2000 Undocumented Procedures For Files, Drives and Directories
  18. Calculating Thanksgiving By Using SQL in SQL Server
  19. SQL Server 2005 Virtual Labs
  20. Use OBJECTPROPERTY To Find Out Table Properties
  21. Feature Pack for Microsoft SQL Server 2005
  22. SQL Server 2005 Launch In Philadelphia
  23. Find all Primary and Foreign Keys In A Database
  24. SQL Server 2005 Book Rant
  25. Cannot add, update, or delete a job that originated from an MSX Server
  26. Pad Numbers By Using CASE, LEFT And CONVERT
  27. SQL Server 2005 launch Webcast
  28. Formatting Data By Using CHARINDEX And SUBSTRING
  29. Finding ASCII, Numbers and Alphabet Characters In SQL Server Tables
  30. Top Google Searches On SQL Server Code
  31. SQL Server/Math Puzzle
  32. Percentage Of NULLS And Values In A SQL Server Table
  33. Microsoft SQL Server Developer Edition 2005 CD/DVD For Sale On Amazon
  34. SQL Server 2005 and Visual Studio 2005 are released!!!
  35. SQL Server 2005 Certification Links
  36. My Top 3 SQL Server Books
  37. SQL Server 2005 Books On Line on MSDN
  38. Some Undocumented DBCC Commands
  39. Find Out How Many Occurrences Of A Substring Are In A String
  40. Do Not Drop And Create Indexes On Your Tables
  41. Which Service Pack Is Installed On My SQL Server
  42. List All The Indexes In My Database
  43. Concatenate Data Into One Comma Delimited String
  44. Find Out Server Roles For a SQL Server Login
  45. How to find all the tables and views in a database
  46. Split a comma delimited string fast!
  47. Fast Date Ranges Without Loops In SQL Server 2000
  48. Put Tables Into Memory
  49. SQL Server MVP's
  50. Query Analyzer Trick
  51. Date formatting in SQL Server
  52. Average length of all rows in a table
  53. How to return random results from SQL SERVER
  54. @@IDENTITY returns wrong identity field