Jack Corbett (10/15/2007)

---

and what's a bookmark lookup?".

[/quote-0]

I have to admit to not being confident on this one. I would define it by saying it occurs when SQL uses...

Maybe it's Rhode Island? But we ask these questions:

What's the difference between clustered & non-clustered index

What's the difference between blocks and deadlocks

What kind of recovery models does a database have...

I've been involved with hiring DBA's where I work for the last three years. It's been a frightful experience. We eliminate most candidates in a ten minute phone call. While...

I went through a period of swapping jobs quite a lot. It was those damned dot coms. Funny thing was, I took a pay cut each time I jumped because...

There is a difference between simply including a column and adding it to the index. You add a column to the index because it is part of sorts, searches, joins,...

No, not a simple equi-join, no. A simple outer join, yep.

http://www.sqlservercentral.com/articles/Advanced+Querying/outerjoinmystery/2382/

Can anyone show me a single instance of any individual walking through 1m records one at a time? Every time I've been given the requirement "we need to see all...

Maybe I'm confused, but you can't browse the transaction logs. The error logs, which you can browse, aren't going to show much from "activity" but rather from logged events, errors...

antony (10/15/2007)

---

Hi,

You can update you query in best way like below

Update TableA set a.col3=b.colc,a.col4=ColD,a.col5=ColE from TableA a, TableB b

Where b.ColA = a.Col1

Its similar like the join Query. Try This...

In the interest of completion. Here's the execution plan for the latest solution. I'd stick with the simple join statements:

Actually, I can add one more bit of info:

http://www.simple-talk.com/sql/performance/sql-server-performance-crib-sheet/

Jeff Moden (10/14/2007)

---

"This is the hammer that, I suspect, will be used to hammer in nails, screws, and 2x4s in projects [...] It will be overused. Don't let your...

Jeff Moden (10/13/2007)

---

Grant, I'm with you... I see no compelling reason for CLR's. My opinion, for the most part, for them being there is the same as DTS and...

No, we're not searching against it. We simply return it as XML. I have looked into using the XML indexes, but that nine times data storage that I keep reading...

We are using it in some places. The purpose is pretty much self-explanatory, we want to persist XML data and having an XML data type for storage ensures that we're...