Microsoft Surface RT Review
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
Blog Posts
Monitor Blocking with Extented Events in SQL 2012
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
Virtualizing Your Business Critical SQL Servers Anthology
This week I completed a six-part blog series (more like five plus one) on the path to virtualizing your business-critical...
2012-10-29 (first published: 2012-10-24)
2,373 reads
Advanced TSQL training
Over the past few years, Ive had it on my to do list to write and deliver and full-scale SQLServer...
2012-10-28
1,044 reads
Countdown to PASS Summit 2012 – 9 to Go – My First Summit
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
[off topic] I crossed a milestone today
Hey everyone,
I have been nearing this goal for some time (a few times coming within fractions) so this is somewhat...
2012-10-26
811 reads
Database Mirroring Error
I have been setting up multi instance database mirroring for the last couple of days along with some other DR...
2012-10-26
665 reads
DBA Question of the Day: Statistic
http://www.flickr.com/photos/_barney/5177975707/Hello Dear Reader, yesterday I posed the question to you what are Statistics? We could get down and dirty of...
2012-10-26
1,076 reads
Decoding first, root, and FirstIAM in Sysindexes
Have you ever looked at the first, root, and FirstIAM columns in sysindexes and wondered…
“What do these values mean?”
Recently, I...
2012-10-26 (first published: 2012-10-23)
1,691 reads
How do I find all stored procedures or views that use a specific table?
Many years ago when I was still working on SQL 2000 I occasionally needed to find all stored procedures and views...
2012-10-26
15,153 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCP Rembang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
Layanan BCA KCP Blora Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
Question of the Day
Adding Bits I
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