How to Write a Better T-SQL Code
Here are some basic guidelines that are good to consider when writing T-SQL (Transact SQL). These tips and hints are aimed for the beginner-level T-SQL developers. Always Use a...
2018-11-17
55 reads
Here are some basic guidelines that are good to consider when writing T-SQL (Transact SQL). These tips and hints are aimed for the beginner-level T-SQL developers. Always Use a...
2018-11-17
55 reads
Here are some basic guidelines that are good to consider when writing T-SQL (Transact SQL). These tips and hints are...
2018-11-28 (first published: 2018-11-16)
4,528 reads
Have you ever been in a meeting where the attendees seemed to go down one rabbit trail after another? At...
2018-11-30 (first published: 2018-11-16)
1,845 reads
Be sure to subscript to our RSS feed to keep up with the latest SQL Server news and tips!
http://vitamindba.com/feed/
The post...
2018-11-16
314 reads
“Power BI is just growing and growing and getting better and better at an amazing rate.” Who said that? Watch...
2018-11-16
214 reads
AdvertisementsSQL server error log load to a table
There are cases, we need a SQL server error log load to a table...
2018-11-16
390 reads
At PASS Summit, I presented a session called “Do Your Data Visualizations Need a Makeover?”. In my session I explained...
2018-11-27 (first published: 2018-11-15)
2,751 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-11-30 (first published: 2018-11-15)
1,903 reads
Have you ever imagine you can determine the version of SQL Server from a bak or a MDF file? I...
2018-11-26 (first published: 2018-11-15)
18,533 reads
Hopefully, a database being taken offline is a known event and not a surprise. Occasionally there are gremlins, in the form of users with too many permissions, that tend...
2018-11-15
143 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...
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