Undercover TV – Sean McCown Joins Us For a Session on Beginning Powershell SMO
In this episode, Adrian looks at some of the new features of the Undercover Inspector1.3 and special guest, Sean McCown...
2019-02-26
249 reads
In this episode, Adrian looks at some of the new features of the Undercover Inspector1.3 and special guest, Sean McCown...
2019-02-26
249 reads
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough...
2019-02-26
110 reads
To add onto yesterday’s post about which cardinality estimator (CE) your query will use, there’s an additional complexity. This specifically...
2019-02-26
845 reads
Watch this week’s video on YouTubeComputed column indexes make querying JSON data fast and efficient, especially when the schema of...
2019-02-26
957 reads
Watch this week's video on YouTube
Computed column indexes make querying JSON data fast and efficient, especially when the schema of the JSON data is the same throughout a table.
It's...
2019-02-26
28 reads
Watch this week's video on YouTube
Computed column indexes make querying JSON data fast and efficient, especially when the schema of the JSON data is the same throughout a table.
It's...
2019-02-26
17 reads
You cannot enable trace flags (globally or by session) within Azure SQL Database but did you know that some global...
2019-02-26
623 reads
Here it is! The second article about Python! This time I have described how tou use simple conditional code in...
2019-02-26
843 reads
By now many of us have upgraded from SQL Server 2008R2 and we’re on the “regular Cumulative Updates” train now. For the rest, it’ll (hopefully) happen soon. And since...
2019-02-26
24 reads
I’ve been a champion of Red Gate’s tools for years. Quite simply, they help me get work done quicker. They...
2019-02-25
178 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