Look at the execution plan....

I think you mean Archive Tables.

These are tables where you can transfer data to that is not immidiately required.

Say you have a transaction table where you insert several thousands of...

Ahmad Osama (4/17/2008)

It works:)

What if I have varchar column...

You can also use the Bitwise NOT function (~) by using a query like:

UPDATE inventory SET iLease = ~ iLease

Regards,

Hans

Besides the different tools available, you can also set alerts on various things you want to monitor.

You can get an alert when a SQL-job fails, when space drops below a...

It looks like you haven't defined an Operator yet. Look in SSMS under 'SQL Server Agent' and 'Operators'. You probably have to use a group mail to notify multiple persons...

Rafal S. created a script to get the job done.

See this link: http://www.sqlservercentral.com/scripts/Miscellaneous/62115/

Sorry, my mistake...

In SSMS you open the query. There you have to right click the query and then choose "analyse query in DTA"

Hi Bob,

Assuming there will be only one value in eacht column (per task_ID) you can use it with the GROUP BY clause.

The query will be like this:

SELECT TASK_ID, MAX(APPL_ID), MAX(QTIME),...

Hi,

You have to open the query in Management Server. From there you can select option "Database Engine Tuning Advisor" from the menu "Tools". This will pars the query to the...

Hi,

I quess you should use the UNION for this.

SELECT Column1, Column2 FROM Table1 WHERE Column1='cat' OR Column2='cat'

UNION ALL

SELECT Column1, Column2 FROM Table2 WHERE Column1='cat' OR Column2='cat'

UNION ALL

SELECT Column1, Column2 FROM...

Hi again,

On this website http://msdn2.microsoft.com/en-us/library/ms130828.aspx is a better explanation on what to use (and when to use it).

Hi,

SQLOLEDB is the best way to go.

On the MSDN website http://msdn2.microsoft.com/en-us/library/ms130978.aspx Microsoft states the following:

"If you are developing a new application it is recommended that you consider using ADO.NET and...