Danny's SQL Server and Internals Viewer Blog - All Comments

Page compression - internals and examples

Danny's SQL Server and Internals Viewer Blog — Thu, 19 Jun 2008 21:42:37 GMT

First of all, apologies for the delay in writing this. I meant to blog about page compression as soon

Link Listing - February 24, 2008

Christopher Steen — Mon, 25 Feb 2008 06:08:41 GMT

ASP.NET DotNetOpenId 0.1.1 has been released [Via: David Christiansen ] UpdatePanel, Who? [Via: Ben...

re: Hello!

Christian — Tue, 12 Feb 2008 09:30:08 GMT

I LOVE this tool. Its great for testing and illustrating storage concepts and the effect of different trace flags on the storage structure. I've got some blog postings on my to do list that will be far more consumable to readers thanks to this tool!

re: New Product: Server Alert

Christian — Tue, 12 Feb 2008 09:23:51 GMT

We raised this idea with the SQL product group during the development of SQL 2005 but it never made it. Its amazing to see it implemented so simply with an add-in. Nice work!

SQL Shorts

SELECT IsUseless(blabber) from sys.innarwebs CROSS APPLY jmass(blog) — Tue, 05 Feb 2008 22:47:33 GMT

The big news of the week is Windows Server 2008 RTM'ing. Read more here. The storage engine team has begin a series on bulk insert. It is definitely recommended reading. Part 1, Part 2, Part 3. The ...

re: Scuffling with ‘String or binary data would be truncated’

Danny — Mon, 14 Jan 2008 18:38:50 GMT

Ok, ok, apologies for stating the obvious!

re: Scuffling with ‘String or binary data would be truncated’

AdamMachanic — Mon, 14 Jan 2008 16:12:30 GMT

The month as a single character story is great!! Unbelievable, yet oh so obviously (and sadly) true at the same time. Thanks for sharing...

re: Scuffling with ‘String or binary data would be truncated’

DamianMulvena — Mon, 14 Jan 2008 10:31:58 GMT

I love how you have to say "ANSI_WARNINGS OFF has drawbacks and it is better to correct a problem rather than ignore it."! I would have thought that was a given.

I worked on an application recently that stored the month as a single letter. Nobody picked up on the errors so we had a value range of J,F,M,A,S,O,N,D.

Тип данных TIME в SQL Server 2008

Александр Волок — Sat, 12 Jan 2008 10:04:51 GMT

Новый тип TIME содержит в себе значение времени, но уже с определенной пользователем точностью, которая

FOR XML и обратное преобразование

MSSQL — Wed, 09 Jan 2008 04:25:47 GMT

Очень полезная процедура для обратного преобразования результата FOR XML AUTO: CREATE PROC dbo.uSpShredTable...