Generate Date Range
Generates a rowset with a datetime values for every day between a start datetime and end datetime.
2002-07-04
651 reads
Scripts
2002-07-04
697 reads
Index Locking Strategy
This script returns the index locking strategy informationfor all user tables in a database. It also generates the required TSQL statement to alter locking strategies if required. These statements require CTRL-C and CTRL-V individually into query analyser for execution. Results are best viewed in text only. This TSQL can be wrapped in a stored procedure […]
2002-07-04
1,405 reads
VB6/ADO Stored Procedure Call Generator
Generates a VB6/ADO procedure prototype, procedure call, and ADO Command Object Parameters.Append calls. To use, simply set the @spname variable equal to the name of your stored procedure, run, and cut and paste the output into you VB program. The generated code may require some slight modifications, but this should save you a lot of […]
2002-07-04
1,091 reads
Finding a string occurance in Tables/View/SP...
This script search the active database for the stringyou're looking for.It searhes with in Table Names, Table Columns, Views, SP's, Triggers, Indexes and System Tables.Enjoy it ...
2002-07-03
538 reads
Concatenate Rows without a cursor
You might come accross a situation where you want to retrieve the values of all the rows concatenated and stored in one variable. Here is the solution. Lets say you have a table called tblCustomerOrders which has CustID and OrderID. You now want all the OrderIDs for a particular Customer to be stored in one […]
2002-07-02
1,114 reads
GetFileInfo2
An Improved version of GetFileInfo that now includes the space utilization of each datafile. Provides more detail per file. Predict when your files are going to grow!! Both data and log files. This script organizes information about the database files on the server. A cursor is used to get the information from each database. The […]
2002-06-28
590 reads
Function to return a delimited list as a table
This SQL2000 function accepts a delimited list of values as a string and the character you want to use as a delimiter.The function then splits these out and returns them as a table.The function assumes that the input string will contain unique integer values.Useage: - SELECT Id FROM fnSplit('1,2,3,4' , ',')
2002-06-27
604 reads
Get File Info
This script organizes information about the database files on the server. A cursor is used to get the information from each database. The information is reported in Megabytes, including the next allocation from disk. No bells and whistles...and if I can find how dbcc showfilestats works I will add the amount of space used in […]
2002-06-24
1,140 reads
List All Jobs and Their Schedules
This queries the sysjobs, sysjobschedules and sysjobhistory table to produce a resultset showing the jobs on a server plus their schedules (if applicable) and the maximun duration of the job.
2002-06-20
4,273 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