Filtering in SSMS
Do you spend seconds, maybe even minutes trying to find things in SSMS? Ever find yourself scrolling up and down...
2011-12-21
1,999 reads
Do you spend seconds, maybe even minutes trying to find things in SSMS? Ever find yourself scrolling up and down...
2011-12-21
1,999 reads
I was recently asked to provide some performance tuning recommendations for an ETL process that extracts data from Oracle using...
2011-12-21
8,037 reads
AlwaysOn is a new integrated high availability (HA) and disaster recovery (DR) solution that provides redundancy within a datacenter and across datacenters...
2011-12-21
1,584 reads
I wrote a while back about my coffee cup from SQLSaturday #100. I took it to work (where I usually...
2011-12-21
646 reads
Virtualization is awesome! It really helps when you are a developer. On my laptop I don’t even have SQL Server...
2011-12-21
5,414 reads
After a server move to the failover Data Centre – a file copy between the two sites slowed down by 6x. ...
2011-12-21
670 reads
As I write this the final hours for the 2011 PASS Board of Directors elections are ticking away. Before the...
2011-12-20
956 reads
A tribute is an expression of gratitude or praise. As I head into this holiday season I wanted to express...
2011-12-20
525 reads
One task that often needs to be done when migrating a database to production for the first time is to...
2011-12-20
1,427 reads
Looking at 2011 and the planned events so far for 2012 it’s easy to see that SQLSaturday is starting to...
2011-12-20
663 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