Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2000   (RSS)

TOP, ORDER BY, and Non-Unique Columns

One of the comments I accidentally deleted earlier this afternoon posed the following question (paraphrased): I understand that TOP with ORDER BY makes no sense, but what about when I use different values for TOP and I ORDER BY a column that has duplicate

Ack! I Just Deleted Four Comments Accidentally!

If you've left a comment here since June 4th, please repost it with my thanks and apologies. I tried to do a bulk approval and I did a bulk deletion by mistake. One of them was a question about TOP with ORDER BY that I'll attempt to reproduce in a few

Database Programming: Operator Precedence in DTS is a Matter of Inheritance

This post will (hopefully) close a thread which runs here and here . When we last addressed this issue, I mentioned that an answer to the operator precedence question for DTS raised by Scott R. would depend on either my research or the kindness of others.

Database Programming: Operator Precedence In SSIS

This morning's post on Operator Precedence was a little misleading, as Scott pointed out in his comment: The example expression highlighted in green above (A <> 0 AND B / A > 1) is said to evaluate differently in SQL 2000 and SQL 2005, but I

Database Programming: Operator Precedence In SQL Server

[UPDATED 9 May 2008; the information presented doesn't exactly answer Greg's question. There's an update here ; and DTS is discussed here ] I received an inquiry yesterday from Greg Husemeier, who I met when he came to Redmond for the SQL Ranger program.

Tech·Ed North America 2008 Developers Update/See You Next Week

The last couple of days have certainly had a particular orientation.  In addition to booking my arrangement for tomorrow night's trip to New York, today I booked my trip and accommodations in Orlando, and I received my speaking schedule last week. 

See You At Microsoft Tech·Ed North America 2008 Developers!

Happy news this week that I'll be traveling to Orlando, Florida the first week of June to attend and present at Microsoft Tech·Ed North America 2008 Developers June 3-6 at the Orange County Convention Center . I'll be revisiting the three presentations

Another Word On For-Fee Aggregators

One more post before I turn in.. Blogging is about passion and community, which may well be two sides of the same coin.  Our passion makes us a community.  Even though I don't read the output of my fellows in the SQL Server blogosphere nearly

Yet Another Blog You Should Check Out

The comment space for yesterday's rant about the web site that's charging for access to MSDN and TechNet blog content is busier than any has been for awhile.  I also got this email via the contact mechanism on the blog: I was just about to ask you

Are You Paying To Read This Post? You Don't Have To!

In the age of the blog, it may well be that republishing is the sincerest form of flattery. The same RSS technology that many of you use to read the blog through wonderful rollers like this one also can be turned to far more nefarious purposes. I'm going

An Answer For Spazecaze: A Reasonable Method To Implement User Defined Fields

Spazecaze discovered a February, 2006 discussion of order of operations and poses the following question in its comment area : So how would you go about designing a database that allows for end user defined fields? For instance, a system is built to allow

What Do You Get When You Give A Community Builder An External Website?

I've asked to rhetorical questions such as this two times previously, each in reference to an event masterminded by Saleem Hakani, the persistent and determined gentleman behind the internal Microsoft SQL Server Community movement. Never one to leave

TechEd Developers 2007 Barcelona: Day 5

TechEd Developers 2007 is history, but not before an eventful last day. My day started with my last presentation of the conference, the Version-stamping of Database Objects talk. There were about twenty-five attendees, and they were very receptive to

TechEd Developers 2007 Barcelona: Day 4

Another busy day here in Barcelona. I started this morning by heading to La Rambla de Catalunya in the center of the old city. I wanted to visit La Font de Canaletes . Local legend has it that visitors that drink from this fountain will someday return

TechEd Developers 2007 Barcelona: Day 3

Today's affirmation: feedback is a gift. This was my busiest day of the conference from a presentation standpoint, as I made two today: the second offering of Set-Based Thinking , and the first of Database Design for OLTP Developers . The attendees here
More Posts Next page »
 
Page view tracker