GO statement breaks SSIS Execute SQL Task
I have lost an hour today trying to find a bug in my SSIS package, and it was so small...
2011-11-30
6,838 reads
NOT IN or IN?
I have been having a hard time believing my eyes when I noticed that these queries give different results:
1. select...
2011-09-27
783 reads
MDX Performance - burdens of IIF
I used to think naively that IIF is an innocent little function that can only do good and help me...
2011-02-11
3,126 reads
PARTITION BY clause works incorrectly when in nested select over large volumes of data
I have been witnessing a very strange behaviour of ROW_NUMBER() PARTITION BY clause in complex join and nested select or...
2010-11-03
2,778 reads
SSRS axe work: How to use fields from different Datasets in the same field Expression and Grouping in Report Builder 2.0?
Last week I was puzzled by one of my colleagues - he needed help in creating a Report Builder 2.0 SSRS...
2010-10-07
6,847 reads
SQL or MDX query trace in SSRS - trick of imagination or a real thing?
I sometimes have ghost memories - I remember some things that had never in fact happened. And I was wondering if ...
2010-08-30
3,326 reads
SSRS Subscriptions failure - should we always listen to our DBA's?
During the configuration of one of the SSRS instances I have stumbled upon a problem with SSRS Subscription. Subscriptions were...
2010-08-04
1,026 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
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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...
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