DAT283

TechEd AU this week. I'm giving a talk on "T-SQL Tips n Techniques: Improving Your T-SQL Arsenal" on Friday morning. The slides are available from CommNet for people registered, but the scripts are here as well. Come along to the talk to see how I use the scripts, but do grab these if you want to be trying them out on your data while I present. They all work on SQL Server 2005, and they use the AdventureWorks database.

I'll also try to do a series of blog posts about some of the tips, but as well as that, many of them are part of the Advanced T-SQL course that I put together earlier in the year.

Published Wed, Sep 3 2008 7:49 by Rob Farley
Filed under: , ,

Comments

Tuesday, September 02, 2008 8:18 PM by Thomas Williams

# re: DAT283

Hey Rob, I downloaded your scripts for a sqizz (thanks!), and found something in your "14-binarylike.sql" script where you cast a number as VARCHAR(4), which means that numbers after 9,999 appear as *: "...This is my *th long string, right?..."

Not sure if this is what you intended!

Good luck with your presentations :-)

Thomas

Tuesday, September 02, 2008 9:49 PM by Rob Farley

# re: DAT283

Ah, true... I had originally been inserting 8000 rows, but then extended it to more. I should change it and make the '4' bigger.

It's a tip that I got from Ward Pond's similar presentation at TechEd US.

Thanks for the heads-up

Rob

Sunday, September 14, 2008 10:02 PM by Thomas Williams Tech Blog

# OT: Improving my T-SQL What?

OT: Improving my T-SQL What?

Wednesday, September 17, 2008 6:37 PM by IT

# re: DAT283

Hi Rob

Just want to say thanks for the TechED AU DAT 283, It was one of the best time spent learning all the tips.

Great Job and Well done :-)

Cheers

IT

Wednesday, September 17, 2008 10:54 PM by Rob Farley

# re: DAT283

Glad you enjoyed it. There's a link to the slides here:

msmvps.com/.../improving-your-t-sql-arsenal-slides.aspx

(these are user-group slides, without the TechEd branding)

Rob

Friday, October 03, 2008 7:08 PM by Rob Farley

# OUTPUT clause - knowing what goes in, and what you've accidentally taken out

The OUTPUT clause has to be one of the best T-SQL features out there. It was new in SQL Server 2005,

Leave a Comment

(required) 
(required) 
(optional)
(required)