Improved Split function
This improved Split function allows for multi-byte delimiters, optional null values, and optional null value substitution.
2007-09-10 (first published: 2007-05-01)
464 reads
Scripts
finding the blocks in sql server
Hai buddies,The following procedure can be used to find whether there are any blocks in the sql server.The procedure if run in Master database , can be used like any other system stored procedure from any database.The output of the proc will contain the followingSPID OF RUNNING APPLICATIONAPPLICATION NAMEEXECUTING DATABLOCKED (Y/N)BLOCKING SPIDBLOCKING APPLICATIONEXECUTING DATA (BLOCKING […]
2007-09-09
3,704 reads
Return comma seperated values from multiple record
It helps you in situaions whenever you wish to create commm seperated values actually originating from multiple records. Say, your query return three records in folloing patter:Student_Name=============RickyAdamMathewBut, say you wish to have records in following patter:Student_Name============Ricky, Adam, MathewThat is how it works. Try it...I beleive it will help you a lot
2007-09-07 (first published: 2007-05-01)
485 reads
Find Nth Maximum from a Table...
This is very simple query to find Nth Maximum number from a Table. For example, using this query, we can identify the 5th, 8th or Nth highest paid employee of an organization.
2007-09-06 (first published: 2007-04-29)
973 reads
Smart data archiving stored procedure
This stored procedure uses a series of input parametes to generate, and optionally execute a series of SQL commands to move production data to an archive table. The procedure assumes that the production and archive tables will have the same structure. The procedure uses the following input parameters:@SourceTable: This is the name of the table […]
2007-09-05 (first published: 2007-04-26)
4,108 reads
Mirroring Job Switcher
I wrote this so that jobs associated with a mirrored database will run on the principal and not on the mirror. Please send your comments on what implications I might be missing - I would appreciate that greatly.This procedure works in conjunction with a WMI alert you will setup in SQLSEVERAGENT -> Alerts ->Mirroring Status […]
2007-09-04 (first published: 2007-04-25)
471 reads
Clean up default constraints
The script scrapes out all default constraints (optional for particular column, table or script generation for the whole db) in SQL Server 2005 manner. Based on: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro2k/html/sql00a11.asp
2007-09-03 (first published: 2007-04-25)
593 reads
Get list of tables used in a stored procedure
It used to find the table dependencies, helps the developers during an enhancement stage to find the tables are used in a stored procedure.
2007-08-30 (first published: 2007-03-16)
3,299 reads
RC4 encryption/decryption with SQL Server
The first function is used to initialize the seed for the RC4 algorithm (second function), which does the encrypting/decrypting.
2007-08-29 (first published: 2007-02-12)
1,478 reads
Splitting strings
There are many split-functions out there. This is very fast because there is only two string manipulation functions involved, and not per-part string manipulation.
2007-08-28 (first published: 2007-02-12)
488 reads
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Spending Time in the Office
Comments posted to this topic are about the item Spending Time in the Office
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers