Hello John,

Thank you very much for your assistance. I have already begun to configure the applications as such and all is look good.

Thanks

Neil.

Hello John,

Thank you for the detailed reply. Our DBA's are not permitted to have full access to the system overall, they are assigned a small section within either a...

Hello Samir,

It depends on your situation. Tables can potentially store many millions, in fact, billions of rows, however consider this:

If you had a table with a single 'int' column...

Hello Philip,

Thank you for your reply. It wasn't that I thought there was a problem, I was just interested to throw the issue to the internet community and see...

I'm part of a small group presently in the task of developing a database and application which has the ability to become and is projected to become a VLDB. ...

Hello, thank you for your reply.

Unfortunately, all data needs to be accessed all the time in the quickest time possible. When processing new data, a complete read of previous...

From an old graphic I had (thanks to search I have again )

Windows CEMENT!

I would have to say, back in the day it would have been Hackers when it was released it wasn't too bad.  Though today (excluding the Matrix) it would have...

Hello All,

Thank you very much for your valued comments. 

With the changes I wanted to perform, it was only to change the collation on the user db.  Not the server...

Again, thank you for your assistance.

I attempted their coding:

ALTER TABLE Table1 ALTER COLUMN Col1

            smallmoney COLLATE SQL_Latin1_General_CP1_CI_AS

But received this error:

Server: Msg 447, Level 16, State 1, Line 1

Expression type smallmoney is invalid...

Thank you for your welcome comments and suggestions thus far.

The strange part about this error is the fact that it's happening on computed columns.  Just to eliminate the chance anyway,...

Recently I have had to create an admin task that needs to be run on our 24gb database each day.  Unfortunately due to our company security I cannot show the...