Customize the Management Studio Toolbar
Management Studio is great tool with almost everything you need right at your fingertips. Notice I said "almost". I like...
2012-10-30
2,265 reads
Management Studio is great tool with almost everything you need right at your fingertips. Notice I said "almost". I like...
2012-10-30
2,265 reads
Here are a couple of quick database and table level queries that I have found useful lately.
How many rows in...
2012-10-30
1,633 reads
Last Friday, pretty much on impulse, I decided to go to the Microsoft Store in the Park Meadows Mall in...
2012-10-29
2,404 reads
Eight days to go. So after going to my first conference, I was surprised that I did not know more...
2012-10-29
1,217 reads
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-01 (first published: 2012-10-29)
3,321 reads
1. Set the "blocked process threshold (s)"
sp_configure 'show advanced options', 1 ;
GO
RECONFIGURE ;
GO
sp_configure 'blocked process threshold', 10 ;
GO
RECONFIGURE ;
GO
here we...
2012-10-29
2,657 reads
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out...
2012-10-29
658 reads
Today we await the arrival of a 100 year storm that threatens to surge New York harbor and the Long...
2012-10-29
1,112 reads
Amazon has released the latest version of it Kindle – the Kindle Fire HD.
It seems amazon are moving away from a...
2012-10-29
639 reads
We are less than ten days to the start of PASS Summit 2012. I thought it would be fun to...
2012-10-28
597 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. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
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