Resource Governor clamps down on Greedy Reports
One of the things I run into every now and then is this provincial idea that reports can and should...
2011-10-10
1,309 reads
Blog Posts
Sometimes temp tables can be your best friend
Here is a quick example of when using temporary tables will give you a big performance gain. I recently was...
2011-10-10
895 reads
SQL Saturday 98 Follow-Up
I’ve been meaning to follow-up with links to the presentations that I delivered at SQL Saturday 98. It’s a few...
2011-10-10
582 reads
SQLBits9
SQLBits9 – “Query across the Mersey” was held in the majestic Adelphi hotel. This was my first SQLBits experience and was...
2011-10-10
912 reads
sys.dm_os_loaded_modules
sys.dm_os_loaded_modules is a SQL Server OS Dynamic Management View (DMV).
When executing the t-sql statement below – a recordset is returned . I’ve...
2011-10-10
2,427 reads
The PASS Summit is HERE!
Watching the twitter sphere it is apparent that many of the SQL Nation are in route to Seattle WA today....
2011-10-10
473 reads
PASS 2011 Countdown – Starting Now
Seriously, the clock is ticking and you should be in your car or a plane for PASS Summit by now. ...
2011-10-09
739 reads
An Informal Compendium of SSAS Errors, Part 4: SSAS Object Design
This is the third in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...
2011-10-08
2,217 reads
DBCC checktable
Instead of using DBCC CHECKDB , which checks on consistency and allocation across the whole database, an alternative is DBCC CHECKTABLE...
2011-10-08
2,716 reads
#SQLGive Update - New Dropoff Locations
Since announcing #SQLGive earlier this week I'm happy to report that two additional vendors have agreed to host dropoff boxes...
2011-10-07
856 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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...
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
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