#tsql2sday #60 – Something New Learned – Problem Step Recorder
What is T-SQL Tuesday?
T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party...
2014-11-11
2,423 reads
What is T-SQL Tuesday?
T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party...
2014-11-11
2,423 reads
It’s hard to believe it’s over. It felt like a whirlwind while I was in Seattle for my 7th PASS...
2014-11-10
478 reads
Suppose, sometimes you just need entry in the table with all the default values.
For example you have a Student...
2014-11-10
221 reads
This was one of those days I was waiting to happen. You might be wondering whats special? Yes, this day...
2014-11-10
863 reads
Just back from PASS Summit 2014 and I am feeling inspired about stepping it up a notch and starting to...
2014-11-10
489 reads
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-11-10
344 reads
After I wrote about creating tables that contain the results I expected, I wondered if I could do the same...
2014-11-10
743 reads
1. After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option. 2. Click Configure Security, Configure Database Mirroring Security...
2014-11-10
27 reads
1. After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.
2....
2014-11-10
4,030 reads
I recently did a presentation and discussed some techniques for monitoring the performance of your business intelligence stack. I will be doing...
2014-11-10
1,259 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...
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