Steps to install Service Pack for SQL Server 2005 – Multiple Instances
Steps to install Service Pack for SQL Server 2005 on multiple instances in one go :-
Step 1 : First page of...
2014-07-28 (first published: 2014-07-21)
8,016 reads
Add them to ALL the roles!
I seem to get a lot of permissions questions these days and one of the more frequent ones goes along...
2014-07-28 (first published: 2014-07-21)
8,672 reads
Speaker Buddy System
SirSQL made a rather stirring post recently. He talked about a speaker buddy system to help out new speakers in...
2014-07-25 (first published: 2014-07-21)
8,015 reads
PASS Data Arch VC presents SQL Server MVP Grant Fritchey - How to Build a Database Deployment Pipeline
Please come join the Data Architecture VC this Wednesday to get info from MVP Grant about Database Deployment something all...
2014-07-21
460 reads
Clustered Columnstore Indexes – part 34 (“Deleted Segments Elimination”)
Continuation from the previous 33 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
Segment Elimination for Deleted Row Groups
After some very interesting and inspiring conversations...
2014-07-20
555 reads
Extraordinary #2
This is another situation that happened on a database migration at a client site. The database migration was done by using SSIS...
2014-07-19
111 reads
Things You Can Find in the Plan Cache at SQLBits
On Saturday, I had the pleasure to present my session, “Things You Can Find in the Plan Cache”, at SQLBits!
Thanks to...
2014-07-19
453 reads
Database jokes
Sometimes when work is tough you simply need to take your eyes and mind away from your working console. Jokes are one matter that you can take a look on and smile...
2014-07-18
10 reads
Database jokes
Sometimes when work is tough you simply need to take your eyes and mind away from your working console. Jokes are one matter that you can take a look on and smile...
2014-07-18
245 reads
Database jokes
Sometimes when work is tough you simply need to take your eyes and mind away from your working console. Jokes are one...
2014-07-18
1,313 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