Sponsoring SQLSaturday!
SQLServerCentral and Red Gate software are pleased to announce our sponsorship of SQLSaturday! events.
2009-03-02
609 reads
Articles
Finding the Worst Performing T-SQL Statements on an Instance
Greg Larsen introduces some Dynamic Management Views (DMVs) and Dynamic Management Functions (DMFs) to help monitor your application's T-SQL performance. In addition, he provides a Stored Procedure that utilizes the DMVs and DMFs to produce a report that quickly identifies poorly performing T-SQL statements.
2009-03-02
5,852 reads
Processing XML files with SQL Server functions
Loading and processing XML files into SQL Server tables can be simple, thanks to a method that uses SQL Server functions and XPath expressions.
2009-03-02
2,790 reads
Red Gate Software Supports SQLSaturday!
If you've read my blog over the past year and a half you know that I've been heavily involved in trying to build a 'franchise' around SQLSaturday, with the guiding principle being that the event has to be locally owned. We've had some decent success, but we've also seen that in many cases groups are reluctant to try hosting one, usually due to one of the following:
2009-03-02
1,244 reads
SQL Saturday
sql_saturday_logo I’ve been pretty lucky in my career to have the opportunity to attend quite a few conferences. I’ve attended one, and often more than one, a year, and I’ve had great opportunities to not only learn more about SQL Server and technology, but also to network and meet professionals from all over the world, many of whom have become good friends.
2009-03-02
1,852 reads
The SQL Bailout
With all the bailouts being requested in the US, where is the money for DBAs who need it?
2009-03-02
598 reads
The SQL Bailout
With all the bailouts being requested in the US, where is the money for DBAs who need it?
2009-03-02
636 reads
The SQL Bailout
With all the bailouts being requested in the US, where is the money for DBAs who need it?
2009-03-02
834 reads
A Cloudy Week - Database Weekly (Mar 2, 2009)
There has been a lot of news about cloud computing this past week, including an announcement about SQL Server.
2009-02-28
748 reads
A Cloudy Week - Database Weekly (Mar 2, 2009)
There has been a lot of news about cloud computing this past week, including an announcement about SQL Server.
2009-02-28
1,009 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