Comparing Stored Procedures, Part 3
Third in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2011-03-30 (first published: 2009-02-16)
2,497 reads
Third in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2011-03-30 (first published: 2009-02-16)
2,497 reads
Second in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2011-03-29 (first published: 2009-02-09)
2,585 reads
2011-03-28 (first published: 2009-02-06)
8,184 reads
This custom sp rebuilds \ reorganizes indexes for SQL 2005 databases and logs results for further analysis.
2011-03-25 (first published: 2009-02-16)
7,238 reads
Using opendatasource to retrieve data from Excel files as if querying a table.
2011-03-22 (first published: 2009-01-27)
11,943 reads
2011-03-18 (first published: 2010-09-21)
2,896 reads
This script will allow you to update 2 databases with the same names, but different schemas/software/database versions.
2011-03-14 (first published: 2011-03-03)
2,260 reads
Returns the item from a delimited list at the specified position. Both position and delimiter are parameters.
2011-03-10 (first published: 2011-02-21)
1,124 reads
2011-03-09 (first published: 2011-02-21)
858 reads
2011-03-07 (first published: 2011-02-21)
8,728 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers