T-SQL for Performance and Accuracy – Vern Rabe: A preconference essential for anyone using SQL Server
SQL Saturday Preconference: February 9th, 2018 in Redmond, WA Do you think you write T-SQL queries that perform well? Think...
2018-01-11
429 reads
SQL Saturday Preconference: February 9th, 2018 in Redmond, WA Do you think you write T-SQL queries that perform well? Think...
2018-01-11
429 reads
Since starting the Guy In A Cube series over three years ago, Adam Saxton has become the front man for...
2017-12-20
374 reads
Between sessions at the PASS Summit, I had the privilege of interviewing Alberto Ferrari and Marco Russo; SSAS Maestros and...
2017-12-03
442 reads
During the month of April, I will be delivering three full-day Power BI hands-On workshops. Each of these events will...
2017-03-02
376 reads
This is a different spin on the top three vendor rankings visualized in Power BI. According to the placement of...
2017-02-17
827 reads
This page is a table of contents for for several new and forthcoming posts. I’m posting a series of excerpts...
2017-01-22
538 reads
This just in from the Reporting Services product team: “Power BI reports in SQL Server Reporting Services: January 2017 Technical...
2017-01-17
690 reads
As I visit businesses, consulting clients and training classes, to teach data reporting and analytics; there is a recurring conversation. ...
2016-12-28 (first published: 2016-12-10)
1,575 reads
NEWS FLASH: Power BI reports can be deployed to SQL Server Reporting Services web portal. The production-ready release is targeted...
2016-12-16
461 reads
I recently needed to replicate all of the reports on one report server to a different server. I started downloading...
2016-12-04
1,454 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
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