Currys having apostrophe trouble
Before I start I just want to say that much of this post is mere speculation on my part and...
2014-04-08
634 reads
Before I start I just want to say that much of this post is mere speculation on my part and...
2014-04-08
634 reads
Update: 11th Sep 2016 - See comment that pricing tiers have been adjusted since this blog post
I've been aware of Pluralsight...
2014-03-25
1,362 reads
If you haven’t heard of the name before, you must have seen what it does at some point. FIGlet which...
2014-02-13
1,781 reads
Have you ever had that moment where you have gone "Geez.. I wish I'd learnt this stuff ages ago" after...
2014-02-04 (first published: 2014-01-27)
6,206 reads
I’ve been blogging for a couple of years now and although I’ve never been a prolific blogger (and never will!),...
2013-12-23
584 reads
EDIT: Please also see in depth comment from Brent Ozar on my main site which extends the query provided below...
2013-11-30
4,822 reads
This is a personal pet hate of mine.. Mixing HTML formatting tags directly with XML that aren’t escaped or contained...
2013-11-07 (first published: 2013-10-31)
3,989 reads
I feel rather flat today. I passed the 3rd entry level 2012 exam a few hours ago, data warehousing to...
2013-09-19
719 reads
Over the years with each release I’m often impressed by some of the features contained in SQL server but every...
2013-08-30
1,369 reads
Whilst doing some ad-hoc work on some data on a 2012 SP1 instance I came across an issue with the...
2013-07-25
1,387 reads
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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