SQLAndy

This was fun to run through, nice to see MS adding features even if in my view they didn't quite...

2007-06-12

1,327 reads

Clustered Index Seek or Key Lookup

When I teach performance tuning I always remind students to be cautious about service packs because things you "know" may...

2007-06-04

1,760 reads

I'll be doing a spotlight session called 'Transactional Replication for Beginners' this year. I've been speaking at the Summit since...

2007-05-29

1,362 reads

I've got a new article running on SSC today with a few more book reviews: http://www.sqlservercentral.com/columnists/awarren/2998.asp.

2007-05-23

1,423 reads

When mirroring was first released for Azure SQL Database, it used Change Data Capture...

One of the things I’ve tried hard to do in database development situations if...

The T-SQL Tuesday topic this month comes James Serra. What career risks have you...

We have two "identical" instances of an ASP.NET web service (or so I have...

Comments posted to this topic are about the item OPENQUERY Flexibility

Comments posted to this topic are about the item A Full Shutdown

Which of these are valid OPENQUERY() uses?