SQL Server Database Mirroring Monitoring
SQL Server Database Mirroring keeps running all time to sync data between Principle & Mirror database. We need regular monitoring of...
2014-11-03
6,445 reads
SQL Server Database Mirroring keeps running all time to sync data between Principle & Mirror database. We need regular monitoring of...
2014-11-03
6,445 reads
November is not the right time to visit Seattle (Blame the rain!), but I kinda like November because that’s when...
2014-11-03
548 reads
Recently , one of my friends shared that some interviewer asked him a question “How to copy table structure only from...
2014-11-03
772 reads
Technical Round Database Interview Questions
1) What are the different types of Trace flags which we used for detecting the Deadlock?
2)...
2014-11-03
1,391 reads
PowerPivot data models in Excel is a great way to quickly pull data from various sources, build relationship between different...
2014-11-03
2,490 reads
I recently celebrated my 5 year anniversary at Pragmatic Works. Boy, how time flies by. It feels like just the...
2014-11-02
1,669 reads
I recently had the chance honour to spend twenty minutes talking to Boris Hristov about testing with Sql Server for his Google Hangouts series, catch the video here
One of...
2014-11-02
12 reads
I recently had the chance honour to spend twenty minutes talking to Boris Hristov about testing with Sql Server for...
2014-11-02
55 reads
I recently had the chance honour to spend twenty minutes talking to Boris Hristov about testing with Sql Server for...
2014-11-02
73 reads
This week, I’m attending two different summit events in the Seattle area. On Sunday through Tuesday, I’ll be participating in...
2014-11-02
765 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...
Comments posted to this topic are about the item Helping an English Student with...
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