My blog has moved! It now lives at http://del.icious.info . The focus of the new blog will no longer be SQL Server topics, but a broader discussion of issues encountered when building scalable internet services. -Aakash

I've always been confused about how operator new works. Finally, I found this article which clarifies how the compiler generates code when it encounters new. C++ Language Reference How new Works The allocation-expression — the expression containing the...

I have gotten a number of emails from people through my blog, asking various questions about SQL Server 2000 and SQL Server 2005. While I appreciate getting these questions, please note that the best place for SQL Server support is the SQL Server newsgroups...

Datetime and smalldatetime data types can be confusing at times. For example, consider the following select statement: create table t1(c1 datetime) go insert t1 values('20010101') go select c1 + '1/1/3' from t1 go If you expected '1/1/3' to represent...

I'd like to get a feel of how many of you out there are using Browse mode (appending FOR BROWSE to your SELECT statements, and then using the additional key column metadata returned in order to update the table) directly in your applications in SQL 2000...

Hi all, My name is Aakash Kambuj, and I'm a developer on the SQL Server team, working on SQL Server 2005. Over the next few weeks, I'm going to be writing about some of the more esoteric features of SQL Server and Transact-SQL, like FOR BROWSE and Bulk...