Depending on whether you’re (A) me, or (B) you, the next few weeks are either (A) an insanely busy but enjoyable period of imparting knowledge, or (B) a wonderful opportunity to hear me speak at any of several different venues. Here’s the summary (past events greyed out): 7/27 4:45PM CST – EDMPASS. 7/29 11:30AM CST – SQLLunch.com. 7/29 […]
Category: sqlserverpedia-syndication
Un-SQL Friday #005: Bad Interviews
Yesterday a friend told me a tale of an interview he conducted with a, shall we say, less than desirable candidate. (Most of his responses started with “Well, there was this girl, and we were at a party….”). This, again, is an Un-SQL Friday topic if ever there was one! I hereby declare this Friday […]
Search Argument Case Study: WHERE the year was 2002…
Content Rating: Beginner, Tips It’s entirely possible that you’re fiddling with your search arguments too much, and missing out on the boost a good index gives your query. Here’s a quick demonstration of the power of a well-thought-out search clause on a date column. For this example we’ll use AdventureWorks (freely available at Codeplex). Let’s […]