2009-12-03
4,636 reads
2009-12-03
4,636 reads
2009-12-02
3,642 reads
This article contains instructions on how to use some of my favorite methods to remove duplicate fields from a table.
2009-11-30
13,651 reads
This script will synchronize all stored procedures between two servers, using spSynchStoredProcedure.
2009-12-15 (first published: 2009-11-26)
2,230 reads
2009-12-23 (first published: 2009-11-26)
658 reads
2009-12-18 (first published: 2009-11-26)
638 reads
Synchronize source code between two servers for multiple stored procedures
2009-12-21 (first published: 2009-11-26)
2,304 reads
Use this stored procedure to synchronize source code of a stored procedure between two servers.
2009-12-11 (first published: 2009-11-26)
2,056 reads
2009-11-25
3,524 reads
2009-11-24
3,437 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