PASS Data Architecture Virtual Chapter presents Data Warehouse Architecture
On Thursday August 18th, John Racer will discuss some common architects and practices for Data Warehouses.
2011-08-18
772 reads
On Thursday August 18th, John Racer will discuss some common architects and practices for Data Warehouses.
2011-08-18
772 reads
2011-08-18 (first published: 2009-08-12)
9,534 reads
Today we have a guest editorial from Brad Wallace that is an attempt to answer the question 'Why is database engineering so expensive?'
2011-08-18
719 reads
The article presents an automated process to see when remote servers last synced to publisher and send notification reminders.
2011-08-18
2,183 reads
If you think about it carefully, you’ll realise, that index maintenance is necessary and that it makes sense, and that SQL Server is not doing this task automatically according to the book.
2011-08-18
5,492 reads
A commentary of the experiences of James Dimauro at SQL Saturday #64 in Baton Rouge, LA in August 2011.
2011-08-17
549 reads
On Tuesday August 23rd, Brad McGehee will take you through real-world examples to show what Red Gate SQL Monitor can do for you.
2011-08-17 (first published: 2011-07-20)
1,749 reads
The storage subsystem for a SQL Server can prove to be a bottleneck if the best choices of hardware aren't made, but there are ways to relieve the I/O bottlenecks if the causes are well understood. This requires benchmarking. Glenn Berry gives expert advice on getting to grips with the disk subsystem.
2011-08-17
2,286 reads
2011-08-16 (first published: 2009-08-05)
9,056 reads
This article will help to get some basic information from your databases that may help you in different situations.
2011-08-16
9,364 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