Hi, see this above script It is clearaly mention "Print command"

PRINT 'SQL Server and SQL Server Agent both are running'

If using print command in sql statement, result set disply...

Thanks for reply... this is very usefull script for identified execution plan on graphical style. once again thanks.

Here i have attached execution plan for xml query plan, please find this...

Just I checked as below script for query using Most IO process.

SELECT TOP 100

(total_logical_reads + total_logical_writes) / qs.execution_count AS average_IO,

...

yes, It is correct & working fine

Thanks

ananda

Thanks for reply & help, I understood why system process waiting long time.

Could you give me, Script for receiving email alert which are user process staying long wait time, suspended,...

Hi,

Thanks for this script for monitor head blocker session, it is very useful.

I checked this script and display system process are suspended, please tell me, Is there any issues?

I think...

No one can run rebuilding index..,

Query life cycle

Running - a query which is...

GilaMonster (7/28/2011)

---

They're waiting for locks. Hence you have some blocking.

You should never just kill something unless you know what impact is will have. What if it's something critically important.

Check what...

Thanks for reply...

I checked wait_type column as below, too much wait stats and display related Query and stored procedure, Program name (.Net...

No sir, still i am waiting for approval from Application & Business Owner,

Please tell me, Is there any issue for Install Ingress ODBC Driver on SQLSERVER 2008 machine?

Thanks

ananda

Mr.Lowell,

thanks for reply..

In SQL server 2008 server machine Not available Ingress ODBC driver 3.0 or 9.2 etc.. I think Ingress odbc driver required in Ingress machine only. Not in SQL...

Thanks for reply......

Please tell me, how to transfer table and data to SQL 2008 from INgres database.?

Does SQL 2008 DTS can able import table and data?

Thanks

ananda

Panders (7/21/2011)

---

As far as im aware you cant break it down into a per day basis.

If you run your script each day then store the results you will be able...

Thanks for reply....

As per Microsoft SQL Server Migration Assistant (SSMA) makes it easy to migrate data from Oracle, Microsoft Access,...

Yes, I got it, If I mention fullscan option - all the row in table gathering the statistics. If...