Find Db space used using SQL-DMO
Use SQL-DMO to find database size used for more than one sql server in your enviroment.
2003-11-10
189 reads
Scripts
Strip Non-numeric characters from string function
Sometimes it's necessary to strip non-numeric characters from the string, so you can convert to integer without error. Often it happens when you want to use stored procedure, especially system procedures. The output there can be already with some characters (MB, KB and such), but you want this result to be used for your own […]
2003-11-10
1,332 reads
Comma seperated list - another approach
This will make a comma seperated list from a column using 2 select statements.
2003-11-07
212 reads
Database File(s) Growth Notification
This stored proc notify the user(s) if the data/log file grew. When you execute it for the first time it will get the data/log files sizes and inserts in a table. Next time when you run the script if will compare the current size with the previous files size. This script must need sqlmail configured […]
2003-11-07
1,511 reads
ClearData
We can use this sp to clear data in tables. I mainly created this sp for two reason. 1.This is useful to commence the testing from scratch. 2.Whenever we ask the database backup from our customer. They hesitant to give the production database because of confidential. I have used Delete and Truncate statement to clear […]
2003-11-06
186 reads
Execute VBScript commands or .vbs files via T-SQL.
sp_ExecVBScript allows you to execute either a .vbs file or an ad-hoc VBScript command within a T-SQL batch. Note that the command (whether it be ad-hoc or contained in the .vbs file) cannot have any code that requires user input (such as Input Boxes or Message Boxes).
2003-11-05
7,708 reads
Restore all Databases in a Directory
Not my script but a guy a work with (Bruce Canaday). This will restore all databases in a given directory. It will also create the data and log directories if they don't exist. A DR Drill dream :).
2003-11-05
3,032 reads
Paged data without temp table and without cursor 2
I modified mbenothmane's script..plz refer to "Paged data without temp table and without cursor(http://www.sqlservercentral.com/scripts/contributions/947.asp)"
2003-11-03
136 reads
Return Column as List of Comma Seperated Values
Need a comma seperated list of a particular column in a table. This will do the trick.
2003-11-03
613 reads
Transfer or Restore Logins to New Server
Not my script, but this script will transfer the logins to a new server or help you restore the in a DR situation with their correct passwords (encrypted).
2003-11-03
1,162 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