Please join me for my PASS Summit Pre-Con with Melissa Coates
I’m excited to announce that I’m joining forces with Melissa Coates (aka SQL Chick) to do a full-day PASS Summit...
2018-04-12
678 reads
I’m excited to announce that I’m joining forces with Melissa Coates (aka SQL Chick) to do a full-day PASS Summit...
2018-04-12
678 reads
Come out Thursday, April 12 to learn how to leverage Microsoft Machine Learning Server. Machine Learning Server HopATopBikeShop BACPAC and Demo Scripts
2018-04-12
30 reads
I’m playing with SQL Operations Studio a bit to get a feel for what works and what doesn’t. So far,...
2018-04-12
2,024 reads
Initially, the main focus of this post was going to be quick and about using the latest version of SSMS...
2018-04-12
888 reads
I recently had the task of deleting a bit over a billion rows from a table. Now I could have...
2018-04-12
2,124 reads
Azure SQL Database has some great built-in features that are included in the price like automatic backups, high availability, auditing and threat detection, transparent data encryption. No matter how...
2018-04-12
50 reads
Azure SQL Database has some great built-in features that are included in the price like automatic backups, high availability, auditing...
2018-04-12
1,381 reads
WHAT: EXECUTION PLANS FOR BEGINNERS
WHEN: Tuesday, 04/17/18 - 11:00 am – 12:00 pm
WHO: Thomas LeBlanc
WHERE: https://attendee.gotowebinar.com/register/7086336336602188044
This will be a Beginners session highlighting the starting point for using the...
2018-04-12
26 reads
Recently, while reviewing one of the stored procedure performance, I suggested a couple of changes to a developer to improve...
2018-04-12
19,998 reads
PASS Summit is the largest conference for technical professionals who leverage the Microsoft Data Platform. PASS Summit 2018 is happening November...
2018-04-11
315 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