SQL Server Instant File Initialization (PQW)
In this article we’re going to look at instant file initialization. What it is, why it’s cool and how you can use it in your environments.
2012-04-02
5,224 reads
Articles
TSQL Challenge 79 - Finding the Islands
The challenge is to find the Islands(gaps) in sequential dates. You need to write a query to identify continuous intervals from the start date and end date.
2012-04-02
893 reads
Init Replication From Backup
One of the great features with SQL Replication is the ability to initialize a subscription from backup instead of from a snapshot. The official use for this is to take a database backup and restore it to a subscriber then replicate any additional changes to the backup.
2012-04-02
1,927 reads
SQL Saturday #133 - Costa Rica
A free day of training in Costa Rica on Apr 14, 2012. If you are near San Jose, sign up today.
2012-04-02
1,094 reads
The SQL Saturday Australia Tour
Free days of training in Australia during the spring of 2012. Apr 12 in Brisbane, Apr 14 in Wellinton, Apr 19 in Canberra, Apr 21 in Sydney, Apr 24 in Adelaide, and Apr 28 in Perth.
2012-04-02 (first published: 2012-03-19)
2,346 reads
How to create a database backup using visual studio
This article describes how to backup a database using a C# Windows Form.
2012-03-30
15,458 reads
2012-03-30
556 reads
2012-03-30
613 reads
World Backup Day
This Saturday is World Backup Day, and with this in mind, Red Gate's Brian Harris talks about SQL Backup 7 and why they want to make backup verification a focus for more DBAs.
2012-03-30
1,962 reads
A Variety of SQL Rally Pre-Cons
The 2012 SQL Rally is coming in May to Dallas, TX and there are a number of pre-conference sessions that can help you learn about something that interests you at an inexpensive price.
2012-03-29
1,782 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