RYO Maintenance Plan – Database Backups
Remember kids...
Anyone who knows me knows that I’m a big proponent of automating routine tasks. If I have to do...
2012-01-26 (first published: 2012-01-23)
3,587 reads
Remember kids...
Anyone who knows me knows that I’m a big proponent of automating routine tasks. If I have to do...
2012-01-26 (first published: 2012-01-23)
3,587 reads
If some long running error situation , the Error Log can become very big. In those situations , it can be time-consuming...
2012-01-26
737 reads
Move over Poseidon. I’m hitting the sea with my own trident (assuming I can get it through the TSA). My...
2012-01-26
842 reads
In my previous blog, I introduced the “X on XMLA” series. In this blog, I will do more of an...
2012-01-26
672 reads
I was trying to acquire a license for a product I was trying to look at using a free program....
2012-01-26
1,047 reads
Congratulations to Philippe Falardeau - he has made the official Oscar Nominations!
http://www.monsieurlazharmovie.com/tourné à Montréal – Filmed in Montreal! The hilarious Algerian comedian...
2012-01-25
2,747 reads
I wrote recently about capacity planning, with an item near the end about disk usage. Someone pointed out to me...
2012-01-25
1,091 reads
Try researching recovering the master database online and you will see countless references to having to have SQL at the...
2012-01-25 (first published: 2012-01-20)
3,049 reads
Over the last couple of years I've come to the conclusion that the default replication agent profiles just don't cut...
2012-01-25 (first published: 2012-01-22)
7,112 reads
As your SSAS cube gets bigger, cube processing time will become a problem. This is especially true as more and...
2012-01-25
11,394 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