It doesn't perform well usually since use of the function forces an index scan instead of a seek (assuming a...

Tony Fountain (9/14/2009)

---

We had one of our RAID drives recreated so the partitions were aligned. I'm seeing a significant improvement in read/write times as well as the average disk...

Hey Tony,

It's not a silly question.

Without AWE enabled...

select WORKERNAME from workers for xml path(''), ROOT('row');

edit: Sorry Lutz - I missed your post :blush:

After EXISTS. That would be...

Dude, it's a myth. Metadata is never checked for COUNT(*) or EXISTS(SELECT *...a quick Google will provide you with testimony to that fact from Itsik Ben-Gan, Erland Sommarskog, Joe...

Marios Philippopoulos (9/14/2009)

---

You don't need to restart the instance to fix this. All you need to do is run "DBCC FREEPROCCACHE; DBCC DROPCLEANBUFFERS". Granted, it is not the ideal solution,...

Just for the record then:

Laptop - yes, to a first approximation

Desktop - nope

SQL Books - 5

Driver's Licence - 2

Proof of SQL ability - none whatsoever

Paul

It's showing up for me.

But thanks for introducing me to a new site...

You or the code? :blink:

No, seriously, have you considered using the right-click on object, script as SELECT to...option in Management Studio?

Paul

P.S. Matt...

Oh no you di'int!!!

I'm off before Celko gets here.

Surrogate keys rock.

😀

OK. If the two things happened at EXACTLY the same moment (the database was set up so that the INSERT didn't block the SELECT or vice-versa...)

You would get 5...

What is the result of running SELECT @@VERSION please?

...and I am assuming you have sysadmin permissions to the SQL Server, is that correct?

We always install client tools and Books Online. I may go in tomorrow and install pubs, Northwind, AdventureWorks, and AdventureWorksDW just to annoy you all.

:laugh:

Paul

SQL Server protects you against worrying about such considerations.

Internal synchronization mechanisms exist to ensure that the scenario you are worrying about will never occur.

The answer is therefore as Dave B...