Raw Materials - Decisions, Decisions
Centuries ago, the philosopher Leibniz had a dream that all decisions could be made by machine. Today, his vision comes to life, more or less.
2012-01-05 (first published: 2010-06-23)
9,080 reads
Articles
Using bit columns with NULLs when three options exist in SQL Server
Frequently surveys ask yes/no questions and use a bit datatype. What are the effects of allowing this column to be NULL in a SQL Server table? Check out this tip to learn more.
2012-01-05
4,275 reads
XML-XSL Transformations in SQL Server
With the release of Master Data Services (MDS) for SQL Server 2008R2, it is now possible to perform XML transformations on the database server.
2012-01-04
7,815 reads
When to Break Down Complex Queries
Microsoft SQL Server is able to create very efficient query plans in most cases. However, there are certain query patterns that can cause problems for the query optimizer; this article describes four of these patterns.
2012-01-04
5,357 reads
Managing Transaction Logs
A great article that should answer all your questions about the transaction log from MVP Gail Shaw. A must read for all DBAs.
2012-01-03 (first published: 2008-10-31)
73,473 reads
2012-01-03 (first published: 2010-06-16)
9,179 reads
The XML Methods in SQL Server
The XML Data type has definite uses, but the way of interrogating, retrieving, and manipulating the values of properties and attributes within XML have been so foreign to the SQL language as to be somewhat of a barrier to their use. Fortunately, Robert Sheldon has once more managed to make the subject accessible to those of us who just need to get the job done.
2012-01-03
3,706 reads
Day Zero with PowerShell
Learn how to get setup with PowerShell and SQLPSX from MVP Aaron Nelson, one of the experts teaching us how to use Powershell for SQL Server.
2012-01-02 (first published: 2011-05-10)
15,858 reads
SQL Server in Luxembourg
The SQL Server Luxembourg User Group will be holding its first major event of 2012 on Tuesday 17th January, starting at 4:30pm. The venue will be Microsoft's offices at Cloche d'Or.
2012-01-02
348 reads
Querying SQL Server Agent Job Information
Is there an easy/automated way to get information on SQL Server Agent jobs instead of connecting to each server and manually getting the information through the SSMS GUI?
2012-01-02
3,521 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