SET Functions

Technical Article

RE: Upgrading to sp3

  • Reply

If they've installed the SQL Server client tools from the SQL Server CD, then you should apply SP3. These would be Enterprise Manager, SQL Profiler, Query Analyzer, etc. If the client computer doesn't have these tools, apply the MDAC.

You rated this post out of 5. Change rating

2004-08-05

Technical Article

RE: Decimal versus Money and division

  • Reply

A close reading of SQL Server Books Online strongly implies that MONEY and SMALLMONEY are stored as "bigint" and "int" datatypes with an implied decimal point. This means that (1) MONEY and SMALLMONEY will tend to be more compact on disk than DECIMAL, and (2) User a5xo3z1 is correct in stating that rounding errors will […]

You rated this post out of 5. Change rating

2003-06-10

2 reads

Blogs

SQL Saturday Boston 2024 Slides

By

Thanks to everyone that came to my talks. Slides are below. Best Practices for...

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers