I hate to say it with Michael Jackson, but 'You are not alone'.

It seems like a pingpong game. For some hours I do receive mails, then again not a single...

Yes, Mark is correct on this.

Because ordering is of less or no importance in a RDBMS, the only reliable way to force SQL Server to order your resultset is to...

Why is the sequence important anyway? It only becomes important when retrieving the data. Then you can always use ORDER BY.

Or am I missing something?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

AFAIK, all banking calculations are done with at least five decimal places.

There are strict rules on how to do calculations, roundings, storing...

In case of uncertainty I would always look...

I guess the easiest way to move objects to a different filegroup would be to use Enterprise Manager.

Look at BOL for filegroups -> switching filegroup for table

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Hi Chris,

glad to see, you didn't get me wrong !!!!

Let me give an realworld example.

At the beginning of last year my company decided we need a...

sp_rename uses utilizes DBCC RENAMECOLUMN. As this command is undocumented, I guess there is no direct way with T-SQL.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

The only reason I can imagine why you should use float or real is when you deal with very large numbers like in astronomy.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Yes, Gabor is right.

Access uses a data type named 'OLE something',which also interprets the stored data.

However you'll notice that this sometimes nice feature has its price in a massive...

quote:

---

Ok article, not sure what I got from it though 🙂 Codd and co had his day, and the pioneer work...

quote:

---

But I think you're mistakenly mixing data atomicity into Codd's Information Rule. I didn't check your sources, but decomposition is a...

Do you think it really matters how much post one has. It says nothing about the quality of the posts. There are certain members here around (I won't name them,...

Do you mean my homepages?

Sorry, I am from Germany, but the SQL Server FAQ on InsideSQL.de should work also in english

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Search the forums for a thread named 'Help me beat EXCEL' or something like that. Must have been activ in April. Can't help you with the actual thread ID, for...

Hey, Jonathan, that's a new way!

Not the typical 'how to pass an array' stuff

Frank

http://www.insidesql.de

http://www.familienzirkus.de