Monthly Archives: July 2009

SQLCMD (Simple Example)

    Download example HERE. (<< Right-click. "Save (Target) As" usually works best). If I haven’t mentioned it before, thank you Microsoft for the sqlcmd.exe utility. If you are new to sqlcmd or new to the concept of repeatability, below … Continue reading

Posted in Software Development | 2 Comments

Update TOP (N) (ORDER BY) Example

  We all know a SELECT TOP(N) (ORDER BY) statement will work.   Use NorthwindGOselect top(10) * from dbo.Orders ORDER BY CustomerID , OrderDateGO However, if you’ve tried to do a:   Update TOP (10) …… ORDER BY X   … Continue reading

Posted in Software Development | Leave a comment

System.Threading.Tasks.Task

Threads are now (or soon will be) very "Old School".   Well, that statement may be a little strong, but there will soon be a new option.   http://msdn.microsoft.com/en-us/library/system.threading.tasks(VS.100).aspx   I attended a local user group and was pleased to learn about … Continue reading

Posted in Software Development | Leave a comment

Did I inspire a Sql Server 2008 feature?

  Did I inspire a Sql Server 2008 feature? You be the judge: Go here: http://blogs.msdn.com/sqlcat/archive/2006/02/17/Partition-Elimination-in-SQL-Server-2005.aspx#5276553 And find this post dated on:October 4, 2007 1:50 PM (Note, the post I wrote is above this date stamp)..   Now go here … Continue reading

Posted in Software Development | Leave a comment