Quick SQL Prompt Updates in a Pattern
I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things...
2017-10-17
1,160 reads
I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things...
2017-10-17
1,160 reads
There were so many good presentations at Microsoft Ignite, all of which can be viewed on-demand. I wanted to list...
2017-10-17
1,490 reads
Monitoring a SQL Server database is a critical component of database administration. Ninety percent of the organizations expect the number...
2017-10-17
922 reads
Starting from SQL Server 2016 Microsoft put a lot of effort into integrating various languages used in machine learning and...
2017-10-17
2,070 reads
Photo by Fischer Twins on UnsplashYou probably tune your queries for maximum performance. You take pride in knowing how to add indexes and...
2017-10-17
215 reads
Photo by Fischer Twins on Unsplash
You probably tune your queries for maximum performance. You take pride in knowing how to add indexes and refactor code in order to squeeze out every last...
2017-10-17
29 reads
As I was testing whether or not the new “Variation Selector Sensitive” ( _VSS ) Collations in SQL Server 2017 would assist...
2017-10-31 (first published: 2017-10-16)
2,658 reads
In this module you will learn how to use the Heat Streams Custom Visual. The Heat Streams visual allows you...
2017-10-16
843 reads
I’m proud to announce that I will be delivering two sessions at IT/Dev Connections in San Francisco! This is my second year at IT/Dev Connections, real content for IT...
2017-10-16
9 reads
I’m proud to announce that I will be delivering two sessions at IT/Dev Connections in San Francisco! This is my...
2017-10-16
348 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