Total Database Information At Your Fingertips Part - II
This article will help to get some basic information from your databases that may help you in different situations.
2011-11-24
5,579 reads
Articles
SQL Server Functions: The Basics
SQL Server's functions are a valuable addition to T-SQL when used wisely. Jeremiah Peshcka provides a complete and comprehensive guide to scalar functions and table-valued functions, and shows how and where they are best used.
2011-11-24
4,190 reads
SQL Server AlwaysOn - Part 2 - Availability Groups Setup
SQL Server has produced some excellent High Availability options, but I was looking for an option that would allow me to access my secondary database without it being read-only or in restoring mode. I need the ability to see transactions occur and query the secondary database.
2011-11-23
2,321 reads
Survey: Do You Monitor Your Databases?
We're looking to find out more about whether you monitor your databases, and how you do it. If you can spare a moment to complete a short survey, please click here.
2011-11-23
1,962 reads
Dealing with Incomplete Data - A T-SQL Puzzle 1
Client data received for processing may have invalid records based on processing requirements. Identifying and dealing with bad records in a specific scenario is the object of this article.
2011-11-22
4,295 reads
2011-11-22 (first published: 2010-03-17)
10,491 reads
Finding the Source of Your SQL Server Database I/O
There are a number of ways of measuring and identifying I/O-related performance information for your SQL Server database instances.
2011-11-22
3,654 reads
A simple math expression solver
Ben Kubicek wrote a recursive function that solves simple math expressions in a select statement. Read about this creative use of T-SQL.
2011-11-21
5,939 reads
New SQL Server AlwaysOn Feature - Part 1 configuration
SQL Server has produced some excellent High Availability options, but I was looking for an option that would allow me to access my secondary database without it being read-only or in restoring mode. I need the ability to see transactions occur and query the secondary database.
2011-11-21
3,145 reads
IT staff would rather pocket $100k than blast off into space
Red Gate survey asks would you take cash or trip of a lifetime?
2011-11-18
1,518 reads
Blogs
Ten Years of PowerShell
Ten years ago, I published a post about filming a Pluralsight Play by Play...
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...
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