Instant File Initialisation
I have been reading up on instant file initialization and I have read a couple of good blog posts by...
2010-01-21
1,440 reads
Gethyn Ellis
DDL Triggers
We had a request from a developer who wanted to access data from a source database and another database on...
2010-01-20
1,023 reads
SQL Server 2008 R2 - Release May2010
SQL Server 2008 R2 now has a release date...May 2010.
Check out the microsoft site for more details...link to follow
2010-01-20
555 reads
SQL Server Resource Governor
I didn’t know this bit Resource Governor in SQL Server 2008 is only available in Enterprise edition
2010-01-20
1,089 reads
January Roundup
I have just put together the January newsletter for www.gre-sqlserver-solutions.com and scheduled it to run Sunday night/Monday morning. It is...
2010-01-16
703 reads
Lock configuration setting and preventing locking contention
The locks configuration option for SQL Server controls the number of locks available in SQL Server. You can view this...
2010-01-11
742 reads
Permon Counters Missing Windows 64 Bit SQL Server 32 Bit
For reasons beyond the scope of this post I have an environment where I have Windows 2003 R2 64 bit...
2010-01-11
755 reads
A Day Off
I'm having a day off tomorrow, got some nice things planned including a trip to the beach with the puppies....
2009-12-10
490 reads
Database Books
Well my theory on posting every week has been tested to the limit somewhat and I didn’t get anything written...
2009-12-08
452 reads
weekly update
Well I said that I would try to post regularly and seeing as its Sunday and I haven’t posted for...
2009-11-29
598 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers