SQL Server Storage best practices
Server storage is one of the most important things for SQL Server performance. Chances to utilize a lot of RAM and...
2015-07-09
3,494 reads
Server storage is one of the most important things for SQL Server performance. Chances to utilize a lot of RAM and...
2015-07-09
3,494 reads
What are exactly Database Managed Services?
The term is widely used and covers so many things simultaneously, so it is hard...
2015-07-07
1,059 reads
Managing SQL Server can be exhausting, so more and more companies today choose either to delegate this task to some...
2015-07-06
726 reads
If you`re using transactional replication on SQL Server platform on rather large and data intensive environment you may have faced...
2015-07-02
1,705 reads
It often happens that you need to disable or enable all jobs in SQL Server Agent in one shot. Script...
2015-06-22
2,523 reads
Databases today are the heart of any business. Holding literally tons of information they indirectly are responsible for managing personnel,...
2015-06-17
589 reads
Form the first glance it may seem to be complicated to calculate price of hosting your database on Azure SQL. We`re simplifying this...
2015-06-17
596 reads
Database design is a complex industry involving many technologies, software and specialists. The term “design” is a little bit misleading...
2015-06-11
470 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. Mahendradatta Selatan No. 99 AX, Padangsambian, Kec. Denpasar Bar., Kota Denpasar, Bali...
WhatsApp:0817819444 Jl. Raya Sesetan No.301, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80223
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