Review: SQL Server Transaction Log Management
Book Details:
SQL Server Transaction Log Management
Davis, Tony and Shaw, Gail
Simple Talk Publishing, October 2012.
Free PDF download
Do I Recommend This Book?
Yes,...
2013-10-28
2,906 reads
Book Details:
SQL Server Transaction Log Management
Davis, Tony and Shaw, Gail
Simple Talk Publishing, October 2012.
Free PDF download
Do I Recommend This Book?
Yes,...
2013-10-28
2,906 reads
I had the honor to speak for the first time at this past PASS Summit 2013 in Charlotte, NC. It...
2013-10-27
880 reads
This year I was honored to sponsor and speak at IT Pro Camp Tampa 2013. Like always, it is a...
2013-10-27
913 reads
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-10-25
965 reads
The PIVOT function is very useful but not easily understood at first. I thank Itzik Ben-Gan, Dejan Sarka and Ron...
2013-10-25
3,117 reads
1. How to find the maximum no of connection allowed in SQL Server?
Select@@MAX_Connections
2. How to select top 2 rows without...
2013-10-24
1,105 reads
“Psssst….”
“Hey buddy! Yeah, you there in the propeller hat. You’re a SQL nerd, right? Can you help me tune this...
2013-10-24
933 reads
Microsoft has released SQL Server 2014 CTP2 (download):
What’s new in SQL Server 2014 CTP2?
New Mission Critical Capabilities and Enhancements
Enhanced In-Memory...
2013-10-24
1,835 reads
I was participating in a Twitter Chat looking at what suggestions and recommendations for developer on how to make the...
2013-10-24
5,051 reads
I came across Vincent Rainardi’s blog, and thought I’d share it with the readers.
Sherry Li and Tomislav’s 2012 MDX Cook...
2013-10-24
919 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Comments posted to this topic are about the item Pay for Performance, which is...
Jl. A. Yani No.25 B, Dusun Onggoprayan, Kepolorejo, Kec. Magetan, Kabupaten Magetan, Jawa Timur...
9G9F+FFC, Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132
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