You know everything about GROUP BY. Do you?
SQL is a stout language and SQL Server has so many features that it’s impossible to be an expert in...
2018-06-01 (first published: 2018-05-25)
5,859 reads
SQL is a stout language and SQL Server has so many features that it’s impossible to be an expert in...
2018-06-01 (first published: 2018-05-25)
5,859 reads
Locking is depends upon Isolation level and Storage Engine. MySQL uses table level locking (instead of page, row, or column...
2018-05-25
285 reads
Techorama 2018 is over, sadly enough. It was a great conference: lots of awesome speakers and sessions and very nicely...
2018-05-25
283 reads
Update:
Refer to this post instead
Hello!
One of the things I feel strongly about is that a build/release pipeline needs to be as complete as possible - that is all configuration...
2018-05-25
27 reads
Today we will discuss how setup a replication: Master – Slave Replication: Requirement: 2 (Linux) System (MasterServer and SlaveServer) MySQL Installed...
2018-05-24
298 reads
Sometimes people speak “SQL” and expect you know all the terminology. In recent a conversation about query plans I was...
2018-05-24
1,080 reads
Next week is Music City Tech, a three day conference consisting of Coding, Agile, and Data tracks, takes place in...
2018-05-24
728 reads
The following has been reposted with permission from Steve Howard a.k.a. @AngryAnalytics. I have made some formatting changes but the...
2018-05-24
464 reads
Now this is something that I’ve seen asked a few times and it’s always a question that gets a fair...
2018-05-24
2,584 reads
https://imgflip.com/i/2axp6yNo..not that Up (although it is awesome!)
--
As a remote service provider a common request is to follow up after a server...
2018-05-24
349 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...
This is my late response to T-SQL Tuesday #204. I almost always forget about...
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