T-SQL Tuesday #93–Interviewing Patterns
It’s time for T-SQL Tuesday, and this is a good topic. Not too close to T-SQL, but certainly something many...
2017-08-08
452 reads
It’s time for T-SQL Tuesday, and this is a good topic. Not too close to T-SQL, but certainly something many...
2017-08-08
452 reads
Problem
Sometimes users may have numerous of databases in their SQL Server. However, while managing their database sometimes by mistake their records are deleted due to which they face a...
2017-08-08
20 reads
Problem
Sometimes users may have numerous of databases in their SQL Server. However, while managing their database sometimes by mistake their...
2017-08-08
5,249 reads
Continuing my series on SQL Server and Oracle, I thought I’d highlight a function that has been in Oracle from...
2017-08-08
314 reads
My previous post on interviews and a number of conversations this year inspired me to write this post. I am...
2017-08-08
455 reads
In my previous post I answer the first of the regular questions I usually get in regards of the MCSA certification,...
2017-08-08
284 reads
InfluxDb & Grafana Series
Running InfluxDb As A Service in WindowsSetting Up InfluxDb, Chronograf, and Grafana for the SqlServer Dev
InfluxDB And AnnotationsCapturing...
2017-08-08
805 reads
[2017-Aug-08] Support for XML structured files as a data source has been available in Excel, then was introduced into the Power...
2017-08-08
12,789 reads
Setting up Telegraf to Capture Metrics I had a lot of issues with getting the GO enviroment setup in windows, this time and previous times. For using telegraf, I'd...
2017-08-08
55 reads
Data Analytics/Business Intelligence Expert Strengths: Passion, great with people, loves to learn and teach Weaknesses: Chocolate, fast cars, death Inquire...
2017-08-07
518 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
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