Re-blog – January 6 – January 12
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-01-13
654 reads
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-01-13
654 reads
The raw ones from podcasts in late Nov and Dec 2011.
Dec 2011 Bloopers
Filed under: Blog Tagged: Humor, syndicated
2012-01-12
1,128 reads
I recently ran into a production instance of SQL Server 2005 SP2 (Build 3042) that is running in a two...
2012-01-12
2,680 reads
We’ve been awfully busy these last few weeks, what with holidays and work and whatnot. But that hasn’t stopped us...
2012-01-12
701 reads
Introduction
In past, many times I have written on Fragmentation of Indexes and how to Defrag them. You can find some...
2012-01-12
15,619 reads
SQL Server has means built into it to track possible missing indexes. This used to be found through the use of the Index Tuning Wizard. The process has improved...
2012-01-12
17 reads
On Friday, January 6, 2012, I got the opportunity to present an expanded version of my “Scaling SQL Server” presentation...
2012-01-12
1,184 reads
In the SAN environment , the Logical Disk Performance objects counters monitor the logical partitions.
I use the Logical Disk Read Bytes/sec ...
2012-01-12
1,866 reads
When developing reports in Reporting Services you will often use the built-in
expression language to make report data and formatting...
2012-01-12 (first published: 2012-01-05)
4,739 reads
There are several ways to check the version of SharePoint 2010 currently installed in your environment. That about sums up...
2012-01-11
1,760 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