2009-03-23 (first published: 2009-02-17)
1,002 reads
2009-03-23 (first published: 2009-02-17)
1,002 reads
2009-03-19 (first published: 2009-02-17)
1,473 reads
This code will drop all stored procedures made with splog. With minor modification it will also drop all functions and sp not made with splog.
2009-03-13 (first published: 2009-02-12)
1,051 reads
2009-03-11 (first published: 2009-02-13)
1,807 reads
Dynamically creates a VB.NET class from parameters in a SQL Stored procedure.
2009-03-09 (first published: 2009-02-16)
1,090 reads
This script uses the system backup history to run a differential backup and place it in the directory of the last full backup.
2009-03-06 (first published: 2009-02-12)
658 reads
2009-03-04 (first published: 2009-02-16)
1,309 reads
This function will return the first, second, third, fourth or last day of a given month.
2009-03-03 (first published: 2009-02-10)
1,241 reads
Find And Replace any string, in the entire table with this function. Parameterized for easy use.
2009-02-26 (first published: 2009-02-09)
916 reads
The default trace keeps the last 20 meg of info, and a max of 5 files...This loads all 5 files into a table so it can be reviewed.
2009-02-25 (first published: 2009-02-07)
1,291 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
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