Multi Script Removes 25 Database Limit
I woke up to a Slack message that alerted me to a post in one of our channels. An engineer...
2017-09-22 (first published: 2017-09-14)
2,445 reads
I woke up to a Slack message that alerted me to a post in one of our channels. An engineer...
2017-09-22 (first published: 2017-09-14)
2,445 reads
The schedule for SQL Saturday #682 Minnesota 2017 is out, and I will be giving my talk on Extended Events:
--
Getting...
2017-09-14
543 reads
This year I decided to take “someday” to heart and do something that has been on my mind for awhile...
2017-09-21 (first published: 2017-09-14)
1,686 reads
Thanks to everyone at a joint meeting of the Baton Rouge .NET and SQL Server User Groups who joined my...
2017-09-14
448 reads
If you know me by now I like rebuilding indexes and that is no different in Azure. Now we have...
2017-09-14
1,384 reads
Said no one ever. Well, maybe. I have had occasions where I needed a brief pause in the middle of...
2017-09-20 (first published: 2017-09-14)
3,258 reads
Hello friends, Please find the link of my new article – https://social.technet.microsoft.com/wiki/contents/articles/40102.microsoft-azure-how-to-check-the-available-extensions-for-a-virtual-machine-using-powershell.aspx
2017-09-14
609 reads
I’m working on a environment where I have to deal with multiple domains. The user’s password needs to be updated each 40/45 days (it depends on the domain).
Because I...
2017-09-14
23 reads
Joe Obbish wrote an epic post a few weeks ago about loading a trillion rows into a non-partitioned table in...
2017-09-13
462 reads
Just a reminder. Redgate is doing research into data governance, and we have a small survey we’d love to get...
2017-09-13
868 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