Dynamic Add/Remove file in Mirroring/Logshipping
Yesterday we were having discussion on high availability feature Mirroring and Log shipping with my colleagues (Amol & Alankar) on whether...
2012-02-15
494 reads
Yesterday we were having discussion on high availability feature Mirroring and Log shipping with my colleagues (Amol & Alankar) on whether...
2012-02-15
494 reads
A typical DBA day can include a mixture of Operational, Engineering and Architectural tasks. Whilst maintaining 100% database server availability...
2012-02-15
717 reads
I recently had a scary conversation with a user, which can be broken down to:
User: Why would the data have...
2012-02-14
779 reads
In November last year, our very own Henrik Sjang Davidsen did a session at the ANUG event called Masters at...
2012-02-14
1,027 reads
Check out my article on SQLServerCentral.com in which I discussed SQL Server 2008 R2 installation setup which you can use to install...
2012-02-14
1,137 reads
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2012-02-14
653 reads
If you are interested in listening to my sultry Minnesota voice this Thursday, you have the opportunity to do it…...
2012-02-14
642 reads
Got some great news today! Turns out Sarah (Blog | @DanceM0m) and I will be heading to Atlanta in a couple...
2012-02-17 (first published: 2012-02-14)
1,617 reads
Have you ever experienced this?
You have developed a set of Reporting Services report that your users love and they often...
2012-02-20 (first published: 2012-02-14)
2,708 reads
Knowing precisely how to start on your next adventure is tricky. With so many options and decisions in front of...
2012-02-17 (first published: 2012-02-13)
2,345 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