Stored Procedure to Pause Execution
Ever needed to pause in a SQL script? Or wanted to simulate a long running process for testing? This stored procedure accepts an integer and pauses for that many seconds.
2002-10-04
1,222 reads
T-SQL
Script All Object Permissions
Quick and dirty script to generate the required SQL to reinstate permissions on each user object. This can be saved off for DR purposes.
2002-09-24
451 reads
Using the DATEDIFF function to select rows
I keep seeing people using CONVERT to convert a date to a varchar in order to do comparison or search queries. I haven't seen a situation yet where DATEDIFF can't be used.
2002-08-29
1,233 reads
Divide big delete into several small ones
Big transactions cause the Tlog to grow.When you do a clean of a large table, the delete statement can cause a very long transactionSometimes it's necessary to prevent this.So we divide one big delete into several little ones.A table with call centre data gets +/- 1-mlj records a day. Every day we run a script […]
2002-08-27
823 reads
Function to Return the Amount of Children in a Tree
Assuming we have the following table (that stores hierarchical data) :CREATE TABLE [staff] ( [employee] [int] NOT NULL , [employee_name] [varchar] (10) NULL , [supervisor] [int] NULL , PRIMARY KEY CLUSTERED ( [employee] ) ON [PRIMARY] , FOREIGN KEY ( [supervisor] ) REFERENCES [staff] ( [employee] ))I ‘ll built a […]
2002-08-23
839 reads
Working with email addresses in SQL Server!
This article shows you how to design the storage for email addresses, how to validate email addresses, how to retrieve demographic information from email addresses efficiently, using computed columns and indexes. It also covers the security aspect of dealing with email addresses.
2002-08-01
1,340 reads
2002-07-19
576 reads
Example of How to use set IDENTITY_INSERT
a Basic example of how to manipulate an IDENTITY COLUMN AN HOW TO STOP the automatic counting using SET IDETNTITY_INSERT
2002-07-18
705 reads
Get computer Net Name in T-SQL
procedure is an extended xp called xp_getNetName to get the computer network identifcation name
2002-07-18
771 reads
Getting Information if a file exists in SQL
THERE is an extended sp called xp_fileexists given a full path to a file Name information is a 3 Bit vector 0/1 if a file doesn't/does exist0/1 is given name is a directory0/1 if the parent directory exists
2002-07-18
1,082 reads
Blogs
Measuring What Matters: Operationalizing Data Trust for CDOs
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
A Small LLM Fail
By Steve Jones
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...
SQL Server Versions: Out With the Old, In With the Supported
By Kevin3NF
If your production SQL Servers are still running 2016 (or older) you’re basically banking...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
SQL Server Ghosts
Comments posted to this topic are about the item SQL Server Ghosts
The Selfish Case for Learning AI
Comments posted to this topic are about the item The Selfish Case for Learning...