Yep. I'm looking forward to regular...

I like to think I have a fairly good grasp, yes.

...and the optimizer can create decent plans with the row...

UMG Developer (12/18/2010)

---

Will you have forgotten it again because you always specify the length and this isn't an issue? (Unless of course you are working on code written by somebody...

That's annoying. I did check at the time I made the change, and it did work - must...

Thanks, though the old twitter references will...

I took a stab at 1,30. So it was 1,*. Ha, very good. I'll have forgotten this again in half an hour, and I still won't care...

SanDroid (12/14/2010)

---

Nils Gustav Stråbø (12/14/2010)

---

I would not expect much change in SGAM pages...

I am slightly confused as to what is meant by a 'simply named' temporary table in the preceding discussion.

Strikes me this is a great reason to use table variables instead...

My first impressions of SQLcomplete are that it is quite usable, and annoying in different ways from standard IntelliSense.

It's a very new product, and will no doubt be much better...

SQL Server 2008 onwards adds ISO_WEEK to the range of acceptable DATEPARTs:

SELECT DATEPART(ISO_WEEK, CURRENT_TIMESTAMP);

SELECT DATEPART(WEEK, CURRENT_TIMESTAMP);

In 2005, you would have to write your own implementation.

More information: http://msdn.microsoft.com/en-us/library/ms174420(v=SQL.100).aspx

Gail was just giving a brief high-level overview in that link you posted.

Missed reads are possible at REPEATABLE READ, and a scan at READ UNCOMMITTED does not always use an...

SQLCLR

Cool avatar, much better than the last one IMVHO.

Okay, that explains why...

My problem with the Advanced Scan feature is that, like Gail, I have been unable to reproduce it....

Sure. That's was just a compact way to demo the issue. Pretty much any...