GSquared (12/5/2008)

---

Replace all the Or and In statements with Union queries and the whole thing will probably speed up. Depends on your indexes, of course, but it can make...

Tables, indexes and execution plan please.

For the exec plan, right click on the plan (in management studio) select save as. Save it as a .sqlplan file. Zip that file and...

Don't change the where clause. You don't want to change what rows the query's returning (affected by the where clause), you want to change how the results are displayed (the...

Depends on the table, depends on the query, depends on the index.

e.g if the table has say 100 rows will it still use table scans despite there being indexes present...

I'm going to guess that the columns are varchar and there's an index on at least one of them. If you compare a varchar column to an nvarchar parameter, SQL...

I'm not even sure you can.

Maybe for a static reporting environment where all databases are static, but that's an odd case. SQL just doesn't scale out.

Yes, but it's not the same databases.

Active/active is two instances of SQL each with their own databases, one running on each node (hence each node is active) and set...

juancabrer (12/5/2008)

---

3. Open the transaction log that took place after data corruption took place, delete the transactions that corrupted the data, save the transaction log, and apply this new saved...

There's no way to have two active instances of SQL on two machines using the same database files (as you would have in a load balancing scenario). The way clustering...

Where are you going to put your backups?

Since Steve's post was after the edit, I imagine he's referring to the question as...

It should. No idea offhand why it isn't.

Whoever told you that is mistaken

if this is not so I would love to know...

Does this work?

select top 1 id

from tblname

where tblname.person = 'xxx-xxx...'

group by id order by max(dttm) desc

I see why.

It's the insert into A straight after the creation of the temp table. That forces a recompile of the entire proc (because the temp table didn't exist when...