Query analyzer with a great DBA 🙂

You'll have to use the profiler. When starting a trace you can add filters (in trace properties / filters) such as user name, appname, events, database, objects...

Just ask if...

The only thing I can think off is that the statistic were updated and that the execution plan changed after the reindex because a better index was found.

I ran into...

What you are looking for is :

Application.RefreshDatabaseWindow

Couldn't you simply do this? :

select Id1, Id2 from table1

Union

select Id1, Id2 from table2

May I ask why you cannot use any casting?... because if you can't do it in sql you're gonna have to do it on the client side... and I can't...

If you are wondering about scan vs seek :

seek will always be the faster than a scan if the index is selective enough (meaning that you have many different...

Just to give another possible situation :

Declare @TableName as varchar(256)

set @TableName = 'ObjSQL'

Select 'UPDATE ' + @TableName + ' SET ' + name + ' = NULL WHERE '...

Actually there is something that can help you in your task. Microsoft released its sql best pratices analyser found here :

http://www.microsoft.com/downloads/details.aspx?FamilyID=b352eb1f-d3ca-44ee-893e-9e07339c1f22&DisplayLang=en

it won't do everything you asked...

Wouldn't this be easier to just do select * from yourtable and table on te client side write the code to loop in the recordset and load the data in...

This solution is one step better. But it doesn't take in consideration that a trigger / constraint check or foreign key may be needing this column

SELECT ...

No there's no point involved in this forum... except maybe the number of postings we do and how well we performe in the Question of the day "contest".

if you are worried about performance you can use this :

exec sp_MsForEachTable 'Select ''?'' as TableName, max(rowcnt) as Total from dbo.sysindexes where id = object_id(''?'') and indid < 2'

This...

this is not the best way to do it but that would work :

CREATE FUNCTION [dbo].[fnGetEmpLanguages] (@EmpNo as int)

RETURNS varchar(4000) AS --can be more than that...

I may be completely off but I've had problems running update/delete statement on linked server with ADO when the table had no primary key (or unique constraint). Other than...