Blogging and when to keep your big mouth shut
I’ve been blogging for a while now. I’ve thought about blogging quite a bit. I’ve even done quite a few...
2018-05-14
501 reads
I’ve been blogging for a while now. I’ve thought about blogging quite a bit. I’ve even done quite a few...
2018-05-14
501 reads
Hello friends, Please check the below link for my new post on Microsoft Azure Mobile App. https://social.technet.microsoft.com/wiki/contents/articles/51525.microsoft-azure-mobile-app-is-available-now.aspx
2018-05-14
743 reads
If you’re seeing SSMS hang/lock timeouts when expanding nodes in the object explorer for a database it’s almost definitely caused...
2018-05-13
112 reads
performace_schema is a dynamic database created when you restart the mysql, all the data from performance_schema database will be clear....
2018-05-13
263 reads
In my previous blog, I discussed about “Which are the queries using a particular index or table?“. Today’s post, I am...
2018-05-13
3,150 reads
I wanted to document a couple of important tasks you should be doing as part of your SQL Server maintenance/backup...
2018-05-12
68 reads
Yesterday we discuss about mysql system database, today we will see “INFORMATION_SCHEMA” database, this we cannot call as database because...
2018-05-12
295 reads
Previous days we discuss Variables and configurations which are quite important for DBA to know. As stated earlier there are...
2018-05-11
234 reads
A recent announcement on the release of several SQL Server tools has raised expectations across various groups. Product requirements and business...
2018-05-11
908 reads
I’ve been busy getting the videos up on YouTube. If they’re helpful to you, please subscribe. Some point soon I’ll...
2018-05-11
237 reads
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...
This is my late response to T-SQL Tuesday #204. I almost always forget about...
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