January 2012 – Monthly SQL Server Checklist
It’s the first Monday of January and for most of us it’s probably a vacation day. No fear, you can...
2012-01-02
1,013 reads
Blog Posts
Pro and Cons of Parameter Sniffing
Look at the following 3 scripts:
-- 1. Hardcoded
SELECT
*
FROM
Sales.Orders
WHERE
DateAndTime < '19900101'
-- 2. Variable
DECLARE @FilterDate DATETIME = '19900101'
SELECT
*
FROM
Sales.Orders
WHERE
DateAndTime...
2012-01-02
469 reads
Renewed as MVP for SQL Server
I have been renewed as an MVP for SQL Server. This is my 4th award. It's humbling to receive the...
2012-01-02
1,265 reads
Review of my blog posts in 2011
The WordPress.com stats helper monkeys prepared a 2011 annual report for this blog.
Here’s an excerpt:
The concert hall at the Syndey...
2012-01-02
747 reads
SQL Index Fragmentation and sys.dm_db_index_physical_stats
Fragmentation of an index can severely affect performance. When logical ordering of the key within a page does not match...
2012-01-02
1,010 reads
SQL Server A to Z – YEAR
SELECT 'Happy '+ DATENAME(dw, GETDATE())Welcome to the penultimate installment of SQL Server A to Z (it’s not often I get to...
2012-01-02 (first published: 2011-12-26)
2,307 reads
Wrapping Up 2011
Goal Setting
Last year, I did a wrap up post of the year to see where I landed from where I...
2012-01-02
995 reads
2011 – The dissection
Blimey, doesn’t seem like a year since I wrote my last end of year review End of year review 2010...
2012-01-01
686 reads
2012: SQL Server, Olympics, Football and Darts
Today is the first day of 2012 and some commentators and bloggers in the SQL Server blog space use this...
2012-01-01
1,091 reads
Renewed
I received my fourth (or fifth?) renewal notice as a Microsoft MVP this morning. I am proud to be recognized...
2012-01-01
938 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers