I recommend keeping each application on its own database server with a unique SA password. Sharing hardware and SQL Server instances works, but makes identifying and isolating security as...

I'm having troubles too. This article is hard to follow and read.

It's not the size that matters, it's what you can do with it. 😀

I should have known it wasn't a trick.

I don't know how well this will work via copying this to the forum, but I put the following (we call it the BOMB) into my TXT or SQL files...

I think it is interesting how when push comes to shove you can sell a SQL Server application/solution to an Oracle shop, but there is no way you could sell...

Very informative example Eric. Thanks for your efforts.

Can I just say I hate NULL values!

Someone needs to write a good model for ISVs (Independent Software Vendors) and in-house developers to follow when building applications that fits into the standards for managing the databases security....

It has something to do with actually reading the data page from disk vs. returning a static value of 1. If all of the data is not within the...

TheSQLGuru (1/8/2008)

Good...

What is better, IN or EXISTS? Is it a preference, does it depend on existing indexes, or does it depends on data volumne?

I use IN with 98 million...

This example only returns a single row, not all rows in table1 that have a matching value...

Glad I could assist.

The following should return each po# in table1 that has at least one row in table2. It will only return each po# in table1 one time.

select po# from table1...

Sounds like a good way to hide something... 😎