Why shouldn’t I shrink my database data file?
A while back I did a post about why you shouldn’t shrink your data file. This one is going to...
2017-11-20
475 reads
A while back I did a post about why you shouldn’t shrink your data file. This one is going to...
2017-11-20
475 reads
If you know about DBCC CHECKDB then most likely you will know about DBCC CHECKTABLE. Quite simply this command performs...
2017-11-20
469 reads
Problem: I was working on getting a demo on how to setup Always On with SQL Server 2017 without the need of creating a windows cluster, I had my...
2017-11-20
97 reads
Back in August of 2011, an announcement from Microsoft started a wave of angst among those who build and support...
2017-11-20
365 reads
Problem: I was working on getting a demo on how to setup Always On with SQL Server 2017 without the...
2017-11-20
180 reads
Microsoft finally has launched most awaited tool – SQL Operation Studio (aka OpsStudio)!!!
SQL Operation studio is a lightweight open source...
2017-11-20
1,585 reads
I never had cause to give much consideration to storage when I was a SQL developer. The companies I worked...
2017-11-19
467 reads
(2017-Nov-19) I don't remember how I actually found this book "Small Data: The Tiny Clues that Uncover Huge Trends". Most...
2017-11-19
1,305 reads
In show #84 of the SQL Server Radio Hebrew Edition, Matan and I talked about how to calculate running totals in SQL...
2017-12-01 (first published: 2017-11-19)
2,912 reads
In the last couple of months, we sent our first customer satisfaction survey to all our customers. We collected the...
2017-11-18
532 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