Skip to Content

peter debetta (75 Posts)

RSS

Medians, Actual Query Cost, and Statistics

Posted December 20, 2006

By ,

In Performance, T-SQL, Uncategorized

I was going to comment on Adam’s post “Medians, ROW_NUMBERs, and performance” (which was a follow-up to Aaron’s post... more »
2

XML Data Type Methods and SSIS Package Variables

Posted December 18, 2006

By ,

In SSIS, T-SQL, Uncategorized, XML

This is a follow-up to a posting from several months ago (Using XML Data Type Methods to query SSIS Packages). I included a temp table (based on... more »
0

iPod and iTunes – Parsing the XML Library

Posted December 05, 2006

By ,

In iPod, T-SQL, Uncategorized, XML

So I was trying to figure out a way to get my iTunes/iPod music library into SQL Server. Unfortunately, the XML in the library is not the easiest with which to... more »
7

SQL Connections Slides and Demos & Other Sundries

Posted November 15, 2006

By ,

In demos, Uncategorized

Well, after a well-needed relaxing weekend with my family and another hectic start of the week, I have finally gotten all the slide decks and code ready... more »
2

Non-Technical: I’m now a father of two…

Posted September 29, 2006

By ,

In Uncategorized

My lovely wife, Claudia, delivered our new baby girl on Monday, 25 September at 2:49 PM CDT. Kate weighed 6 lbs, 5 oz and was 19 inches long. She joins her... more »
5

Another RegEx Trick for SSMS

Posted September 19, 2006

By ,

In Uncategorized

So I wanted to have some consistency in some T-SQL code for bracketed identifier use. Objects in the code had bracketed identifiers in some cases, and not in... more »
0

Accessors and Case-Sensitivity in T-SQL and CLR

Posted September 11, 2006

By ,

In Uncategorized

So in my preparation for the 2006 PASS Community Summit presentation that I will be giving on Managed Types in SQL Server 2005, I was mulling over the... more »
1

Replacing Quoted Identifiers with Bracketed Identifiers

Posted September 09, 2006

By ,

In Uncategorized

So I just generated a DDL script using Visio and it uses quoted identifiers for all object names. But I don’t like quoted identifiers and much more... more »
7

Really, what are your SQL Server “Worst Practices”

Posted August 01, 2006

By ,

In Uncategorized

Richard Hundhausen already posted about this topic on his blog Tales from the Doghouse, but I thought it be wise to post as well, if only to get more feedback.... more »
16

context connection=slow?

Posted July 21, 2006

By ,

In Uncategorized

The subject of this post may be a little misleading. When writing CLR code in SQL Server 2005 that requires querying the data, you should connection back... more »
6