Happy New Year… Late:)
Yeah I know its new year and i am back from quite some time. during these days i was learning...
2018-01-13
321 reads
Yeah I know its new year and i am back from quite some time. during these days i was learning...
2018-01-13
321 reads
SQL Server is one of the finest database management system deployed by organizations for storing and retrieving their data. It...
2018-01-22 (first published: 2018-01-13)
51,503 reads
In yesterday’s tip, I showed an example of changing a block of text from upper case to lower case. However,...
2018-01-12
301 reads
Recently, I got to work with a client on something interesting. We implemented transactional replication to send data to an...
2018-01-22 (first published: 2018-01-12)
1,337 reads
In this module you will learn how to use the Image Grid Custom Visual. This visual is a unique way...
2018-01-23 (first published: 2018-01-12)
1,896 reads
Phew, what a week! Have been looking for a new flat to live so it’s been a bit mad. Have...
2018-01-12
324 reads
While Regular Expressions lets us work with text not cleanly formatted, if you are trying to work with text that...
2018-01-11
254 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
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-01-19 (first published: 2018-01-11)
1,144 reads
Thank you to everyone that took the time to write and contribute, I enjoyed reading about how you conquered your...
2018-01-11
592 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