SQL Server – sp_help without arguments.
sp_help returns information about database objects and types.
@object_name argument is optional for sp_help. When executed without any argument it returns...
2011-08-24
2,504 reads
Blog Posts
SQLMCM Training – Day 16
Today Bob spoke the whole day about securing SQL Server, security itself, and encrypting
data. It was really hard content, and...
2011-08-24
637 reads
VMFS LUN resizing options in vSphere
Introduction
First off, many thanks to Gethyn for the opportunity to post on his excellent blog.
I’m Christian Dadswell and I...
2011-08-24
1,851 reads
What I’ve Been Up To Lately
I ran into a friend at a recent event and during the discussion he asked what I was doing lately...
2011-08-24
642 reads
A Couple of Data Compression Tricks in SQL Server 2008
As I have said several times before, I am a big fan of data compression in SQL Server 2008 and...
2011-08-23
1,933 reads
Autogrow bug – fixed with Denali
Recently I ran into a bug related to autogrow of the log file. Because this was the second time I...
2011-08-23
1,876 reads
Computed Columns and CASE
I wrote about computed columns recently, but I didn’t realize that a logical expression could be used here, such as...
2011-08-23
28,995 reads
Defining Your Culture
Imagine that you take over a team, department, maybe even a whole company, and as you look around at how...
2011-08-23
650 reads
Disk IO performance and SQLIO
Performance testing a new disk subsystem from a SQL Server perspective is one of the fun aspects of DBA work....
2011-08-23
3,449 reads
Get All SESSIONPROPERTY Values for Your Session
As a follow-up to my SERVERPROPERTY() post, this is a quick script to grab all the SESSIONPROPERTY() values from your...
2011-08-23
865 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
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...
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