I stated my question incorrectly. The date shows when a statistic was last updated, but that doesn't necessarily mean the statistics are not accurate. How do I determine...

Thanks. I just reviewed my original notes and the initial code I copied from Microsoft did reference dm_exec_sql_text and not fn_get_sql. Somewhere in my testing I swapped the...

I'll make the change to my code, but I found that if I substitute CROSS APPLY fn_get_sql (a.sql_handle) c with

CROSS APPLY sys.dm_exec_sql_text (a.sql_handle) c the original logic works. ...

I found a blog that pointed me in the right direction. Division by 2 is needed because the text data is stored by Microsoft as Unicode.

Thanks, ...

Thanks Bill. I'll make sure to ask the vendor.

Thanks Steve & Gail

It's a quantitative analysis application. Our only objection is that we are introducing a new RDBMS into the company and want to make sure there are no major risks...

Sounds like our DBA team won't be able to offer any arguments against it.

Thanks for the quick response.

Dave

No issues in the areas of performance and reliability?

We are going to call Microsoft for some assistance. The first line of MS support can be hit and miss so I'm not holding my breath. I'm guessing...

Thanks Grant. I read quite a few MS and other documents about parallelism last night. Most make sense, but a few were a bit too complicated for my...

I believe I found the option in BOL. Is it cost threshold for parallelism?

What does the threshold value control? How does it work?

Thanks

Thanks. I'm not familiar with how ADO works so we have to trust the developers have things setup correctly. Would the SQL provider chosen for the ADO connection...

Here is the syntax.

-- Not sure if 1204 is necessary in SQL 2005. I have read conflicting articles, but thought I would see for myself

DBCC TRACEON(1204, 1222, 3605, -1)

--...