Make partitions without enterprise edition by creating a view unioning tables on different file groups. These tables would all have the same identity increment, but different identity seeds so that...

I found it guys we dont have to worry!

http://en.wikipedia.org/wiki/Lucky_prime

http://en.wikipedia.org/wiki/Fortunate_number

http://en.wikipedia.org/wiki/Happy_prime

no, just stupid answer. they should all be right. expect anything!

there is no statistical proof that more bad things happen on friday the 13th. My answer was also: I expect a promotion and I expect a bonus. If you do...

The best thing for LINQ would be for it to work off views with instead of triggers. The dba can optimize the queries at the level of the view. Instead...

Here is what you do for databases. Deny decryption to the client login! Then force the client to use a stored procedure which itself is encrypted that executes as a...

I got the answer right, but i still think "i is less deep in the tree than j" is just as good an answer. I just figured theyd want to...

I believe by stating privileges you are further defining the definition of the data by being more specific about who or what can access that data. It is DDL!

One of the best things about identity is that it is SEQUENTIAL! So using it as your clustered (usually also your primary) index, will not cause any page splits on...

I would use all the extra money received to buy that same company's products, then tell them my bad! if they find out. But at least it looks good for...

The best practice is my question too, but ive thought about this question a long time ago. I believe the answer is to store user header information. Say you wanted...