Interview questions: What’s the first thing you would do if a user reports slowness.
We’ve been doing a fair amount of interviewing recently and one of our big questions is What do you do...
2018-06-08 (first published: 2018-05-28)
4,105 reads
We’ve been doing a fair amount of interviewing recently and one of our big questions is What do you do...
2018-06-08 (first published: 2018-05-28)
4,105 reads
It always seems that when I give a talk on performance there are 100+ people packed in the room but...
2018-05-28
277 reads
in my last post I showed how you can save the results of dbachecks to a database and created a...
2018-06-07 (first published: 2018-05-28)
1,877 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-06-06 (first published: 2018-05-28)
2,221 reads
(2018-May-27) With recent Hawaiian volcano activity, it would be interesting to see how other similar events have shaped our Earth planet....
2018-06-06 (first published: 2018-05-27)
2,511 reads
Color is a powerful attribute in data visualization. In a good visualization, it can focus attention and enhance meaning and...
2018-06-05 (first published: 2018-05-27)
2,678 reads
Unless you have been living under a rock lately, you have not heard about GDPR. This has been hot topic...
2018-05-25
153 reads
Maybe some of you don't know this, but to view Report Definition Language reports (RDL) , you aren't forced to use...
2018-05-25
634 reads
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2018-06-01 (first published: 2018-05-25)
2,447 reads
Cloning things is all the rage these days…..even Storm Troopers.
Anyway, by now, you probably have seen documentation on Query Store...
2018-06-04 (first published: 2018-05-25)
1,786 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