Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » TSQL   (RSS)
Saturday, October 03, 2009 7:57 PM

Review: Programming MS SQL Server 2008 – Holistic coverage for an App Developer

Following on from my review of my library. This week, Programming Microsoft SQL Server 2008. Summary: It appears to me that the authors started this book with the premise “There is a lot in SQL2008 that can dramatically change the way you architect solutions.
Posted by davele | 0 Comments
Saturday, September 26, 2009 11:14 PM

Review: MS SQL Server 2008 Internals – Core knowledge for all DBA’s

Following on from my review of my library. This week, Microsoft SQL Server 2008 Internals. Summary: This is not as the title might suggest, “special” information for elite DBA’s. It contains the base knowledge that all DBA’s need in order to understand
Posted by davele | 0 Comments
Wednesday, September 23, 2009 1:26 PM

Tip: Avoiding REALLY hard to reproduce bugs in Production

If everything is bug free in Development, Testing, User Acceptance Testing (UAT) how can it possibly go wrong in Production? The following post looks at how that can occur… Intermittently. Recommendation: Ensure that the Server Names & SQL Instance
Posted by davele | 0 Comments
Filed under: ,
Tuesday, September 22, 2009 1:16 AM

Tip SSMS: How to quickly find the line with the Syntax error

When executing code in SQL Server Management Studio. Occasionally people make errors. If you find yourself counting thru your TSQL Batch up to “LINE 231” where your error is supposed to be, then this tip is for you.   Tip: Double Click on the Error
Posted by davele | 1 Comments
Wednesday, September 16, 2009 11:55 PM

Review: MS SQL Server 2008 T-SQL Fundamentals – a must have for most people.

At Tech-Ed Aust last week I had an interesting evening with a few people chatting about finding information & how hard it is to judge the value of textbooks when you are looking online. As I am an avid reader & have a huge library a few of my
Posted by davele | 0 Comments
Saturday, September 12, 2009 2:29 PM

TSQL Tips: The correct way to write your Scripts – ALTER PROC, don’t DROP & CREATE PROC

SQL Management Studio has a very nice Scripting feature that generates scripts to DROP & CREATE your stored procedures, tables & other objects. This is handy, but not good for production systems. Most people use it, … to their peril. This post
Posted by davele | 0 Comments
Filed under: ,
Saturday, August 22, 2009 3:23 PM

Using TSQL Variables: Subtle BUG when assigning values to Variables via a Query

I’m unsure if this is a BUG or “By Design” but for me it is unexpected & likely to cause your application to hang if you aren’t aware of it. So one more article in my “TSQL Best Practise” or “Good TSQL Coding Standards” posts. Summary: If you assign
Posted by davele | 3 Comments
Tuesday, April 07, 2009 1:10 AM

Tip: Make your Identity Keys go Further

It is extremely common to use computer generated Primary Keys in a table. eg: OrderID INT PRIMARY KEY CLUSTERED IDENTITY ( 1 , 1 ) NOT NULL Most people set the seed to 1. I don’t know why. Perhaps because it is the default value, maybe they display their
Posted by davele | 4 Comments
Filed under: ,
Monday, April 06, 2009 10:40 AM

SQL Server NOLOCK Hint & other poor ideas.

Frequently I see production code, created by professional development teams, peppered with NOLOCK & other TSQL Hints. While totally understandable, as it is a common recommendation by many internet posts & often found in their sample code, this
Posted by davele | 5 Comments
Filed under: ,
Friday, November 14, 2008 7:47 AM

SQL Spatial - How to get Spatial data. (FREE Maps 'n Demographics)

This post lists ways to get spatial maps, some of them are Free. If you are in a hurry jump to the last link, it is so cool. Then check out the Free Map sites. Overview There are 3 ways to get the spatial data for your application:- Buy it Download it
Posted by davele | 3 Comments
Tuesday, November 04, 2008 2:06 PM

SQL Spatial - Tips on Storage

This post talks about ways to Store Spatial Reference data in SQL in order to improve performance of your map displays. Overview : There are two broad categories of Spatial Data. Spatial Reference data , the "stuff" you draw maps with; Geo-Political
Posted by davele | 2 Comments
Saturday, November 01, 2008 3:40 PM

SQL 2008 Spatial Samples, Part 1 of 9 - How to Learn SQL Spatial

This post covers how to get started with SQL Spatial methods & the best way to test things for yourself. One of the goals in this series of articles is to give you code you can cut, paste & try. I hope you find this handy. Overview Visual Studio
Posted by davele | 8 Comments
Saturday, November 01, 2008 3:34 PM

SQL 2008 Spatial Samples, Part 2 of 9 - Background on Spatial Types & Well Known Text (WKT)

This post covers all the Methods to enter data in WKT, WKB & XML(GML) as well as functions to view the in Human Readable form. It also covers MakeValid, STIsValid & STSrid.   Summary of Methods to convert Geometric Formats The following table
Posted by davele | 3 Comments
Wednesday, October 29, 2008 3:45 PM

SQL 2008 Spatial Sample, Part 4 of 9 - Methods for Drawing Spatial Shapes

This post covers the following methods: STDimension, STGeometryType, STNumGeometries, STGeometryN, STNumPoints, STPointN, STNumInteriorRing / NumRings, STInteriorRingN / RingN, STExteriorRing, STX / Long, STY / Lat, Z & M (measure). Note: Unless otherwise
Posted by davele | 3 Comments
Monday, October 27, 2008 1:03 PM

SQL 2008 Spatial Samples, Part 5 of 9 - Performance Improvement Methods

This post covers the following methods: Reduce, STEnvelope, EnvelopeCenter, EnvelopeAngle, STConvexHull. Note: Unless otherwise stated. All code samples are designed to be Cut n Pasted directly into SQL Server Management Studio (SSMS) & run. Sometimes
Posted by davele | 1 Comments
More Posts Next page »
 
Page view tracker