Create a slipstream installer for SQL Server on Windows
Since the release of SQL Server 2008 Service Pack 1 in April 2009, it has been possible to install SQL...
2018-10-24
250 reads
Since the release of SQL Server 2008 Service Pack 1 in April 2009, it has been possible to install SQL...
2018-10-24
250 reads
One of the areas that Redgate is working on is making data classification easier. Microsoft added some capabilities to SSMS...
2018-11-09 (first published: 2018-10-24)
3,233 reads
Wow! The last five years of my career have been amazing. I went from attending a SQLSaturday a couple of...
2018-10-24
258 reads
Statistics are the magic ingredient that helps the query optimizer create its best guess for generating an execution plan. Keeping...
2018-11-01 (first published: 2018-10-24)
3,237 reads
A while back a friend of mine, Malathi Mahadevan (b/t), asked me if I’d like to do an interview for...
2018-10-24
240 reads
How often have you felt like you need an extra pair of hands? When you’re planning a party? Maybe. When...
2018-11-01 (first published: 2018-10-24)
2,511 reads
I have finally uploaded my Azure SQL Database presentation, apologies for the delay. I am already working on an improved...
2018-10-24
824 reads
Coeo is a partner with Redgate Software. Tomorrow they are hosting a webinar on what your position will be if...
2018-10-23
399 reads
I used to use ALT+X to execute queries in SSMS. I spent years with this shortcut, but as I started...
2018-11-05 (first published: 2018-10-23)
2,246 reads
If you attended either of my presentations for this past IT/Dev Connections, here are the promised slides and scripts.
As I...
2018-10-23
257 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
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