SQL Rally: Don't Vote for my Sessions
So I found out on Friday that I am going to be a speaker at the Dallas SQL Rally, which...
2012-02-20
915 reads
So I found out on Friday that I am going to be a speaker at the Dallas SQL Rally, which...
2012-02-20
915 reads
I was excited to receive the email on Friday that I’d been selected to present at SQLRally #2 in Dallas...
2012-02-20
610 reads
So I found out on Friday that I am going to be a speaker at the Dallas SQL Rally, which...
2012-02-20
475 reads
Working with Powershell and Active Directory simplifies some complex tasks for the DBA.
Active Directory is LDAP compliant. This means the...
2012-02-20
1,287 reads
I was once asked in a job interview if I knew what a Cartesian/Cross Join was.
A more interesting question is:...
2012-02-19
2,753 reads
Isolation levels in SQL Server control the way locking works between transactions.
SQL Server 2008 supports the following isolation levels
Read Uncommitted...
2012-02-18
529 reads
Many thanks to all those that turned out to see my presentation on Thursday (16th of Feb) of “Cursors are...
2012-02-18
764 reads
Run the SQL Server Configuration Manager, expand SQL Server Network Configuration and select the protocols for appropriate instance. Double click...
2012-02-18
10,364 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-02-17
618 reads
Microsoft StreamInsight, first introduced in Microsoft SQL Server 2008 R2, is a way to effectively analyze large amounts of event...
2012-02-17
3,155 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