SQL Server Memory Usage - Task Manager
Another question I have answered 100s of times to Non SQL folks. "SQLServr.Exe is consuming 80% of memory. Can you...
2012-05-20
1,482 reads
Promised Links from SQL Saturday 119 Presentations
If you attended one of the sessions I promised to post the links we discussed here. I have done my...
2012-05-19
1,161 reads
Denali – Day 19: Programmability Feature -T-Sql
Denali – Day 19: Programmability Feature -T-Sql
ORDER BY .. OFFSET and FETCH :mysql LIMIT (srno ):
OFFSET is a location of the rows...
2012-05-19
1,037 reads
SQL Server 2012 Upgrade Technical Guide is available
The SQL Server 2012 upgrade white paper is now available from Microsoft. I’m proud to have made a contribution and...
2012-05-18
1,726 reads
Rocky Mountain Tech Trifecta 2012
My fourth visit to the Rocky Mountain Tech Trifecta will be tomorrow where I’ll deliver two talks:
Branding Yourself for a...
2012-05-18
1,125 reads
The Brain Dump Blog
I was chatting with a friend recently and he said he could never blog the way I do. Which way...
2012-05-18
591 reads
Expectations-The Big Disconnect
One of the things I’ve learned from running events is to set expectations. If you’re going to provide coffee don’t...
2012-05-18
590 reads
SQLSat 142 – Waltham
Wow – have I ever been dark and silent this past couple of months. Nothing like the present to reverse that trend. I do have a good excuse for...
2012-05-18
12 reads
SQLSat 142 – Waltham
Wow – have I ever been dark and silent this past couple of months. Nothing like the present to reverse that...
2012-05-18
873 reads
Build a Little Free Library
I saw this on the Boing Boing feed yesterday, Little Free Library is a project to try to build 2500...
2012-05-18
850 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 Mahendradata Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Mahendradatta Selatan No. 99 AX, Padangsambian, Kec. Denpasar Bar., Kota Denpasar, Bali...
Alamat Telp BCA KCP Sesetan Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Raya Sesetan No.301, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80223
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