PASS Business Analytics Conference: the ultimate networking
I went to the PASS Business Analytics Conference last week, and had an absolute blast. I presented two sessions, and...
2013-04-18
1,191 reads
I went to the PASS Business Analytics Conference last week, and had an absolute blast. I presented two sessions, and...
2013-04-18
1,191 reads
Introduction
A few months back, I was asked how long a particular nightly process took to run. It was a super...
2013-05-01 (first published: 2013-04-18)
6,554 reads
Populating default dates in SSRS can be helpful to save the user from having to constantly input the date range...
2013-04-18
111,269 reads
Copy and Paste the below content in Set-FindandReplaceString.PS1. Please read the instructions carefully. Try to do a dry run on some...
2013-04-17
715 reads
Each release of SQL Server is chalk full of new features and an assorted amount of bells and whistles. Some...
2013-05-03 (first published: 2013-04-17)
3,225 reads
This past Saturday I had the pleasure of speaking at one of the largest SQL Saturdays I have ever attended...
2013-04-17
579 reads
{Start Circus bumper music here} LADIES and GENTLEMEN; SQL SERVER
PROFESSIONALS of ALL AGES, Come one, come all!
Get ready for a...
2013-04-17
1,241 reads
I came across a cool open source tool called “SQL Space Map“.
The tool, written by Ryan McCauley, presents a visual representation...
2013-04-17
900 reads
The 12th cumulative update release for SQL Server 2008 R2 Service Pack 1 is now available for download at the...
2013-04-17
982 reads
WOW! This week I was featured on the ITCentralStation.com home page as their Reviewer of the Week with my review of...
2013-04-17
595 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
Comments posted to this topic are about the item Adding Bits I
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