T-SQL Tuesday #101 – Some Great SQL Server Tools
This month for T-SQL Tuesday #101 Jens Vestergaard asks us to blog about the essential tools in our SQL Toolbelt.
http://t-sql.dk/?p=1947
I’d...
2018-04-10
1,163 reads
This month for T-SQL Tuesday #101 Jens Vestergaard asks us to blog about the essential tools in our SQL Toolbelt.
http://t-sql.dk/?p=1947
I’d...
2018-04-10
1,163 reads
This month for T-SQL Tuesday #101 Jens Vestergaard asks us to blog about the essential tools in our SQL Toolbelt.
http://t-sql.dk/?p=1947
The...
2018-04-10
353 reads
This blog post is about how to change the default work folder _work that TFS agents use when building a...
2018-04-10
617 reads
Every year, I spend the Sunday after SQL Saturday Rochester scanning & processing raffle tickets for our wonderful sponsors. Here’s how the system works:
Attendees get tickets (one ticket per...
2018-04-10
20 reads
(last updated: 2019-01-05 @ 23:15 EST / 2019-01-06 @ 04:15 UTC )
Let’s say that you execute the following T-SQL:
SET CONTEXT_INFO 1234;
SELECT CONVERT(INT, CONTEXT_INFO());
The...
2018-04-09
1,142 reads
I’ve been away a bit in the last week with personal and family commitments. As a result, I feel a...
2018-04-09
927 reads
I’ve said it before, but it bears repeating, there is no cause for any kind of panic when it comes...
2018-04-20 (first published: 2018-04-09)
3,465 reads
I have come to understand the importance of using columnstore indexes when my queries are aggregating and scanning across many...
2018-04-19 (first published: 2018-04-09)
2,258 reads
# Not the GDPR News -t minus 10 days
There is ten days to go and there are still some seats left for...
2018-04-09
315 reads
(last updated: 2018-04-28)
Today we are going to take a look into an area that you probably are thinking has very...
2018-04-18 (first published: 2018-04-09)
2,974 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