What's New In SQL Server 2017? at the March '18 Baton Rouge SQL Server User Group
Thanks to everyone to attended the BRSSUG meeting tonight at our sponsor's location at the Baton Rouge Alliance Safety Council...
2018-03-14
554 reads
Thanks to everyone to attended the BRSSUG meeting tonight at our sponsor's location at the Baton Rouge Alliance Safety Council...
2018-03-14
554 reads
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...
2018-03-14
772 reads
Enable dark-theme for SSMS Purpose Guide to enable dark-theme in SQL Server Management Studio(SSMS). Reading time +/- 10 minutes References www.sqlserver.info...
2018-03-14
155 reads
Enable dark-theme for SSMS Purpose Guide to enable dark-theme in SQL Server Management Studio(SSMS). Reading time +/- 10 minutes References www.sqlserver.info...
2018-03-14
479 reads
Update: Now with Object Explorer shortcuts! One of the most common things I do within SSMS is to change connection for...
2018-03-14
521 reads
Memory is one among the resources forming the performance triangle—CPU and storage being the other two. If one is hit,...
2018-03-14
657 reads
This May 18th, Redgate is putting on a SQL Privacy Summit for people that are looking for solutions to help...
2018-03-14
1,254 reads
This command only applies to Azure SQL Database, at a high level it empties the database authentication cache for logins...
2018-03-14
759 reads
As I spent last week attending my first MVP Summit in Seattle I thought I’d write this post about how...
2018-03-14
407 reads
Just a quick post here after the PASS Marathon Webinar during which I talked about the GDPR effects around the...
2018-03-13
1,123 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