Bah phoey Frank! But hey you do burn that midnight oil eh Glad my PC...

I am what I am.

But good to see you're online, Dave. Did I ever mention that my laptop has now 1GB RAM and...

Yes, it helps for some time, but then again...

Another advise you shouldn't take too serious, is to install client tools anew , but...

Hey Thomas,

it's not about you, me or anyone else here on this forum. This IS actually a community. Everyone makes mistakes, feels too brain dead to answer even the simplest question...

Oh yes, and DDL of your table?

Strange?

Can you post your statement?

True words, indeed !

I would only like to add, that having a full-time job, a family AND such a large site to maintain is more than I would ask...

1. I would use DATALENGTH

2. Your best bet is varchar(8000) or nvarchar(4000)

No, dynamic sql is executed with permissions of the current user, even if in stored procedures.

Yes, if you need to use dynamic sql, you should use sp_executesql. It allows for...

Welcome to the club.

At first I thought this in an issue with some service pack, because it disappeared with applying SP3. But after some time it happened again.

Well, the good...

I know, I know, I shouldn't clean up my archive

Is this what I can observe when subscribing to the newsletter on the homepage?

To steal Kenneth' phrase: 'It depends..'

I always look forward to have a reason to deal with the girls in our HR department. Guess why?  

Hm, not sure if it's the same in  VB.Net, but in VB6 you can use

Private Sub Form_Load()

oBorder.FlatBorder (lstServer.hWnd)

Set oSQLApplication = New SQLDMO.Application

Set oNameList = oSQLApplication.ListAvailableSQLServers

For i = 1 To...

I just mentioned it, because it comes to mind when dealing with such a number of rows. Not sure if it applies to your environment.

As a start, take a look...

Although I don't have experience with 50 million rows in a table, I would choose one schema and add the user_id to the primary key. With a proper design, smart...