Welcome to SQLSaturday #250 in Pittsburgh
http://www.sqlsaturday.com/250/
SQLSaturday is a full day FREE training event for SQL Server professionals and those wanting to learn more about SQL...
2013-09-05 (first published: 2013-09-03)
1,322 reads
When I run “Script (say table) as” it isn’t (or is) (say generating scripts for indexes). How do I fix...
2013-09-03
780 reads
Wow, more than two weeks past SQL Saturday in Curacao and I find a partially written wrap up post for Curacao in my queue. I had fully intended on...
2013-09-03
13 reads
Wow, more than two weeks past SQL Saturday in Curacao and I find a partially written wrap up post for...
2013-09-03
785 reads
I really like my Windows Phone. Yes, there are not as many apps as on a Droid or iPhone. But...
2013-09-03
547 reads
As a DBA, we're often asked to troubleshoot performance issues for stored procedures. One of the most common tools at...
2013-09-06 (first published: 2013-09-03)
3,275 reads
Have you heard about Hadoop but don't know much about it? What about "big data?" Would you like an intro...
2013-09-09 (first published: 2013-09-03)
2,111 reads
Wrote this email recently to a crew of developers who were shooting themselves in the foot with a database rich...
2013-09-05 (first published: 2013-09-03)
3,227 reads
Even though there are more pros than cons, Striping database backups are often overlooked by many DBAs. Based on my...
2013-09-03
1,673 reads
In our earlier posts , we have discussed about various types pages in details. In this post let us discuss about the organization of the data file.In other words...
2013-09-03
837 reads
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Comments posted to this topic are about the item Building a SQL Server Fleet...
Comments posted to this topic are about the item Smart AI Agents and Data...
Comments posted to this topic are about the item 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