You're going to run into that problem because of the rule for the floating point. How about converting to decimal(38,17) from real before trying to cast it out to a...

Technically speaking, they are the same.

However, you're asking the wrong question. Why do you need to know whether it's the same? What is it that you're trying to find out?

CrazyMan (7/1/2009)

---

Thanks,i am only using 2 Quires to retrieve all my reports, each table has 30 columns, and db sits on a file group,

I am not using Union...

SSMS isn't 64-bit as far as I know.

I built a VLDB in SQL 2008 which takes 17 billion rows per month (all numeric values), using good old fashioned INSERT INTO...

What version of SQL Server are you using?

There are far better ways to write this query. Your JOIN condition is on a non-equal value, which is the first problem.

Why are...

This is not an exhaustive list:

- Ensure the SP doesn't introduce fixes or features that will break the apps using your database.

- Create a backout/rollback plan in case you break...

You only need to ask this question once. I have answered this question in your other thread.

Are you sure you have version numbers correct?

SQL 2005 Express installs into its own instance anyway.

Why do you need to install SQL 2000? You can install 2005 Developer edition and...

Are there any differences between the behavior of a SQL Server 2000 database using simple recovery model and a SQL Server 2000 converted to 2005 (trought restore and changing the...

Max degree of parallelism: 2 sent CPU through the roof - 4 seems to be a much better setting, and CXPACKET wait is way down

Cost threshold for parallelism: 25 made...

Much obliged again, Gail.

Thanks, Eddie and Randy. I'll look into it during daylight hours tomorrow.

To be honest, I wouldn't be surprised if there's a lot of table scanning happening. Some of the big...

One more thing - the system is distributed between three cities and headoffice. I'm discussing the headoffice box specifically. I've taken into account various external factors (which also accounts for...

Hi Gail

I inherited it two weeks ago and I've made it go much faster with query optimisations, indexes, etc., but I'm now trying to squeeze a little bit more...

Dankie, Gail 🙂

I've read up on it before posting, so *theoretically* I know what it means. That said, your advice and suggestions are welcome. I've not seen the wait number...