CISL 1.5.0 is released
I am glad to share that the 1.5.0 release of the CISL (Columnstore Indexes Scripts Library) is finally released.
The biggest...
2017-09-04
371 reads
I am glad to share that the 1.5.0 release of the CISL (Columnstore Indexes Scripts Library) is finally released.
The biggest...
2017-09-04
371 reads
I’ve been using TRUNCATE TABLE to clear out some temporary tables in a database. It’s a very simple statement to...
2017-09-04
1,195 reads
On my day to day work I use Nagios monitoring software. I want to add some custom SQL Server scripts...
2017-09-04
1,832 reads
David has a talk that he delivers at SQL Saturdays, all about Kerberos authentication. What it is, how it works...
2017-09-04
801 reads
Back in March I did my first “feature length” presentation at SQL Saturday Iceland
At that point I’d done a few...
2017-09-04
279 reads
Dear All,In case you are wondering, title of the post is not a typo 🙂 DBCC CloneDatabase is going to be available for SQL Server 2012 :)For folks who...
2017-09-03
25 reads
Dear All,In case you are wondering, title of the post is not a typo 🙂 DBCC CloneDatabase is going to be available for SQL Server 2012 :)For folks who...
2017-09-03
623 reads
Dear All,
In case you are wondering, title of the post is not a typo 🙂 DBCC CloneDatabase is going to be...
2017-09-03
707 reads
At some point this weekend, the Microsoft Power BI folks turned on the drill-through feature in the Power BI service....
2017-09-03
1,793 reads
Hello!
One month ago I became a dad for the 3rd time. And so my spare time, which has always been...
2017-09-02
145 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