SQL Saturday Precon - SSIS Design Patterns
SQL Saturday is hitting Dublin for the first time on March 24th.
2012-03-20 (first published: 2011-12-23)
5,639 reads
SQL Saturday is hitting Dublin for the first time on March 24th.
2012-03-20 (first published: 2011-12-23)
5,639 reads
This article describes my experience in upgrading a four node cluster with three active instances to SQL 2008
2012-03-20
2,462 reads
SQL Server includes a subset of four ranking functions that can be used to rank the rows of your result set over a partition. This article presents those functions and examples of their use.
2012-03-20
3,874 reads
When rounded detail quantities are created by an allocation, often the total must foot back exactly to the allocated amount.
2012-03-19
6,013 reads
The database field contains long string with data for Quantity and Parts. The challenge is to parse the data into separate (Quantity and Parts) fields for displaying in a report.
2012-03-19
2,654 reads
The first SQL Saturday event in Turkey, on Mar 31, 2012 at the Microsoft office in Istanbul. Sign up and come for a free day of SQL Server training.
2012-03-19
1,391 reads
What do you do when you need to remove an orphaned user, but they are the owner of a Schema or Role on that database?
2012-03-16
3,321 reads
This article describes how to add a log shipping monitor to a log shipping configuration that is already in place.
2012-03-15
7,236 reads
This is the first in a four-part series on the new AlwaysOn feature in SQL Server 2012. In this article, AlwaysOn is introduced and contrasted with previous high-availability solutions in SQL Server. The second part of the series will commence with a detailed walkthrough on preparing the environment for AlwaysOn
2012-03-15
3,949 reads
In Part 2 of this series we will shred an XML document and insert its records into a SQL Server table using both the OpenXML and XQuery methods.
2012-03-14
18,285 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