Is a SELECT statement always executed?
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-08-22
209 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-08-22
209 reads
Last month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the IT/database...
2018-09-06 (first published: 2018-08-22)
1,668 reads
Sometimes the SQL logs and application logs provide some great info in regards to errors and issues. When building an...
2018-08-22
5,819 reads
JSON (JavaScript Object Notation) is a file format used to transmit data from various applications, very similar to XML, it...
2018-09-06 (first published: 2018-08-22)
3,747 reads
I’ve had a lot of people ask me for this over the past few months and its finally (mostly) ready!...
2018-09-03 (first published: 2018-08-21)
2,582 reads
This fall, in October, Redgate Software will be hosting three, live, in-person events. These events will take place in New...
2018-09-03 (first published: 2018-08-21)
1,485 reads
Hello Readers,
As per Previous article, i tried to explain configuration of Distributed Cache in SharePoint 2013 environment. Same follows for...
2018-08-21
1,150 reads
SQL server error 5123 occurs when users want to attach the database, which has been placed on different locations. This error is a kind of permission error that occurs...
2018-08-21
100 reads
SQL server error 5123 occurs when users want to attach the database, which has been placed on different locations. This...
2018-08-21
35,423 reads
Watch this week’s episode on YouTube.
Last week I needed to write a recursive common table expression. I’ve written them before,...
2018-09-07 (first published: 2018-08-21)
2,368 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