Veterans at PASS Summit 2017
Hello all!
This year at PASS Summit, I wanted to do something different. In the past Summit’s that I have attended,...
2017-10-28
221 reads
Hello all!
This year at PASS Summit, I wanted to do something different. In the past Summit’s that I have attended,...
2017-10-28
221 reads
Next week is PASS Summit 2017, and I’m excited to be a part of it. One of the sessions in...
2017-10-28
383 reads
In this blog post we’re going to cover systemd, process exit codes and highlight how systemd reacts in certain exit conditions from SQL Server on Linux. My friend and...
2017-10-28
24 reads
In this blog post we’re going to cover systemd, process exit codes and highlight how systemd reacts in certain exit...
2017-10-28
1,328 reads
Situation In SQL Server Availability Groups (AG), Logins must have the same SID (Security identifier) on all the nodes where...
2017-10-28
389 reads
Some (or maybe most?) languages and operating system command shells allow for breaking up long lines into multiple lines (i.e....
2017-11-08 (first published: 2017-10-27)
11,649 reads
In case you missed, I started a new blog series several weeks ago called 5 Tips for Friday on SQL...
2017-10-27
502 reads
An often under utilized or maybe even mis-utilized feature of SQL Server is a database object schema. In the event of the latter, there is an occasional requirement for change.
Related...
2017-10-27
32 reads
An often under utilized or maybe even mis-utilized feature of SQL Server is a database object schema. In the event of...
2017-11-09 (first published: 2017-10-27)
2,291 reads
The 1st cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site.
CU#1 KB Article: https://support.microsoft.com/en-us/help/4038634/cumulative-update-1-for-sql-server-2017
Microsoft® SQL Server® 2017 RTM Latest Cumulative Update: https://www.microsoft.com/download/details.aspx?id=56128
2017-10-27
21 reads
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...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
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