Already listed among other entries, however I believe it should be mentioned separately:

TCP 445 - named pipes.

dstemate (5/13/2009)

---

...and the doctor told me:

if you are on your 40+ you wake up and your body does not bother you (any kind of pain every now and then) then...

Can't find 'sp_reassign_dtspackageowner'

Can't find sp_reassign_dtspackageowner

Also you can't hide/show query results. There is a button for that in QA.

"Recently I came across a highly transactional DB with no FK's! The data integrity was managed by the front-end application."

Another reason for this happening is that vendors try to hide...

Assuming your application is using ADO to insert data, make sure inserts are done with disconnected recordsets. I've had cases where developer would just open a table and insert...

did this couple of years ago (EN-Canada to EN-US).  If I remember correctly, make sure regional settings of your operating system match SQL collation settings (otherwise full-text won't work).  This...

Long lines are very difficult to read.

Please wrap the lines.

These guys have a freeware tool that creates a basic dictionary. Maybe it'll do for you.

http://www.cobbinfosys.com/

And if you choose to use nvarchar, be extremely careful with data types mixing and matching. We use nvarchar for some columns as we anticipate porting parts of our application...

I apologize if I came across rude, but that was my reflex after seeing your little add in sqlcentral newsletter.

Your experience really made me think again about backup...

Hi Steve,

is this article the reason you've lost your job?