String Search
Search for a string value within columns of data types CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, XML.
2015-12-24 (first published: 2012-03-19)
6,781 reads
Scripts
Object Search
Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.
2015-12-23 (first published: 2009-04-29)
5,043 reads
2015-12-22 (first published: 2012-11-26)
3,413 reads
Know read and write ratio before you tune database performance
A script to get the user table query ratio and update radio,etc
2015-12-21 (first published: 2015-12-11)
1,795 reads
2015-12-18 (first published: 2015-12-09)
4,616 reads
SQL server Service, Account, Trace Flag info
This script outputs sql server service, start type, status, Service Account, installation location, start up time, uptime of sql server related services along with startup trace flags.
2015-12-17 (first published: 2015-12-09)
1,149 reads
Script to configure Log File Size for Large DBs
Use this script to set recommended Log files size growth for larger DBs. For more, please refer article: http://sqlmag.com/blog/choosing-default-sizes-your-data-and-log-files
2015-12-15 (first published: 2015-12-07)
1,245 reads
Check FileSize and LogUsage for all DBs
This script provide informations about SQL DBs files size and Log usage.
This little script use os_performance_counters
2015-12-14 (first published: 2015-12-03)
1,513 reads
Faster Log Shipping Restores
When you’re reading from a log shipped secondary, you want the duration of restores to be as short as possible. The sproc provided switches the restores to “NORECOVERY” mode, and then switch back to “STANDBY” at the end of the process.
2015-12-11 (first published: 2015-11-23)
3,146 reads
Estimate compression for all tables and indexes with both Row and Page
This will log output of estimate compression for both PAGE and ROW for all tables and indexes
2015-12-10 (first published: 2015-11-20)
2,523 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