Controlling Growth of a Distribution Database
This article provides a practical example of minimizing the growth of a distribution database.
2011-03-02
2,953 reads
This article provides a practical example of minimizing the growth of a distribution database.
2011-03-02
2,953 reads
Depending on your anticipated workload and which SQL Server components you have installed, there are a number of instance level...
2011-03-02
2,690 reads
A free day of training in Denver on Mar 5, 2011. Learn about Windows, .NET, SQL Server, Sharepoint and more. Spread the word to people you know in the area.
2011-03-02 (first published: 2011-02-16)
2,378 reads
Learn how you can setup Database Mirroring using disparate file paths and drive letters.
2011-03-01
6,975 reads
Earlier in the month I shared with you 10 Things That Every DBA Should Do and so it only seems natural...
2011-03-01
5,946 reads
A Thousand Men Marching Still Only March As Fast As One Man.
la·ten·cy - Computers . the time required to locate the first bit or character in a storage location, expressed as access timeminus word time.
Often when talking to people...
2011-03-01
3,045 reads
To query an Analysis Services cube, MDX is used as the query language. In most business settings, one would find a set of queries that are common across a number of user query requirements. To cater to this, even with a modest size IT team, there is a good chance that the same queries are developed redundantly either within a SSAS MDX script or repetitively in an ad-hoc manner in client applications. In this tip we would look at how to reuse queries without redeveloping them over and over.
2011-03-01
3,774 reads
A while back I wrote up a short introductory overview of Genetic Algorithms. Just for the shear, absolute fun of...
2011-02-28
2,838 reads
I was referred to someone on twitter today who wants to email query results without setting up database mail. I...
2011-02-28
1,959 reads
This article looks at the distribution database what information can be obtained for monitoring transactional replication.
2011-02-28
2,431 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