Weekly Links – 05/04/2013
I’m starting a new tradition:
Before each weekend, I will post links to the best SQL Server stuff i’ve read, heard...
2013-04-05
1,041 reads
I’m starting a new tradition:
Before each weekend, I will post links to the best SQL Server stuff i’ve read, heard...
2013-04-05
1,041 reads
This should go without saying, because most of us have been on the receiving end of poor customer support. However,...
2013-04-05
1,042 reads
Just recently I was part of an online presentation in which the intended audience was unable to install any of...
2013-04-04
249 reads
As per Microsoft Books Online and SQL Server Security best practice white paper, it is recommended to periodically review privileges...
2013-04-04
4,902 reads
You can get backups of your WASD databases. But, if you want them to be transactionally consistent, you need to...
2013-04-04
928 reads
The bank holiday and work have put me a few days behind schedule, but here is the list out all of the...
2013-04-04
752 reads
Last week I took the final exam to acquire the MCSE – Business Intelligence certification. This blog post describes my preparation...
2013-04-04
18,513 reads
Ever wanted to know all there is to know about SQL Server, and afraid to ask? Have questions about how...
2013-04-04
1,222 reads
If you want to make you backup faster, you can try BUFFERCOUNT parameter with compression backup.
From Book Online description:
BUFFERCOUNT = { buffercount | @buffercount_variable...
2013-04-03
3,142 reads
I’m not sure what put this phrase in my head, though I think in part it came from various posts...
2013-04-03
726 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...
Telp/Wa 62817825533 Jl. Brigjen Jl. Slamet Riyadi No.3, Kauman, Kec. Ps. Kliwon, Kota Surakarta,...
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