Drop and Recreate all Synonyms
Had a quick job the other day restoring a pair of databases under different names which is all straight forward...
2014-10-27
171 reads
Had a quick job the other day restoring a pair of databases under different names which is all straight forward...
2014-10-27
171 reads
Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to...
2014-09-25
2,620 reads
Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to...
2014-09-25
1,131 reads
I was having a discussion the other day and was quite surprised to hear that there still appears to be...
2014-09-02 (first published: 2014-08-26)
7,909 reads
I was having a discussion the other day and was quite surprised to hear that there still appears to be...
2014-08-26
179 reads
Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party...
2014-07-25
640 reads
Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party...
2014-07-25
140 reads
A few months back I made the decision to leave the relative comfort and security of my permanent role and...
2014-07-09
582 reads
I was intrigued by the deferred-drop feature that has been inside SQL since SQL Server 2000 SP3 after watching one...
2014-05-31
1,781 reads
There are a whole raft of cool new features in 2014 including things like In-Memory OLTP, increased Azure integration/options and...
2014-04-29
1,690 reads
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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