Changing jobs -- Pros and Cons
I read Andy's post Changing Jobs - Should You? today with great interest. I think it is good topic in the...
2008-08-08
1,324 reads
I read Andy's post Changing Jobs - Should You? today with great interest. I think it is good topic in the...
2008-08-08
1,324 reads
I recently got a request to do a "cold" backup of a small yet complex db environment, I say "small" because...
2008-08-02
743 reads
I was fighting an error that was very rare to appear. I originally put a post on a MS forum
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.replication&tid=57229124-0a5a-4ec3-9055-a06b7869b872&cat=&lang=&cr=&sloc=&p=1
The...
2008-07-02
4,465 reads
Yesterday, I was fighting with an error I have never seen in the replication and not much info can be obtained via...
2008-06-03
16,307 reads
Most of us DBAs have worked on our career to get where we are. A DBA is usually a second or third step in IT and we we've looked to advance our understanding of technology. Jeffrey Yao now brings us a new level of database work to which we may aspire.
2008-05-09 (first published: 2007-07-12)
15,755 reads
This is an old topic and well documented, just google it and I believe you will get a lot,
However,...
2008-04-22
2,258 reads
In my last post, I talked about what prompted me to give a deep thought to documentation work. Documentation, to me,...
2008-03-17
1,037 reads
As a DBA, documentation work is unavoidable, we need to do documentation about things we have done, for example, what...
2008-03-01
1,082 reads
In DBA world, usually two types of DBA are defined depending on what a DBA is focusing on, i.e. development DBA...
2008-02-29
1,921 reads
Last week, in our production, we noticed some records are missing in the subscriber side while existing on the publisher...
2008-01-15
942 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