I suspect that one of your records in the User_Master table has the created_by set to the same value as the user_id.

This sample works fine for me, but uncommenting the...

1. Kinda - Cadets for 2 years and they did cover most of the basic training.

2. Absolutely. But it shouldn't cover any particular flavour of database, including SQL.

I know that's...

So don't tell...

Good article covering a common situation. Indexes are created because we assume they will be the access path (as pointed out in the DateTime discussion) but because they either aren't...

Back when school was cool (and storage expensive!) they taught us not to store calculated information.

I suspect that all of the functions presented here are lower cost than a read.

My personal favourite

SELECT

DATEPART(dd, DATEADD(dd, DATEPART(dd, DATEADD(mm, 1, @day)) * -1, DATEADD(mm, 1, @day)))

I suspect you would be hard pressed to notice the difference between any...

Fair enough! I wasn't convinced this was a "good" approach.

So I'll turn this question around a little bit.

How do people quality check code pro-actively? What tools should we be using...

A good guide to the capabilities of the NoSQL environments is the diagram on Nathan Hurst's blog. http://blog.nahurst.com/visual-guide-to-nosql-systems

As I continue to work with computers and in the industry, the more...

Assuming SQL 2005+

It is theoretically possible that you could into trouble if you use the READ UNCOMMITTED transaction isolation level. You could potentially get dirty reads in the SELECT. That...

Not only do Microsoft offer a course in Licensing, you need to have a qualified staff member to be a Microsoft Partner.

The plethora of different versions of all the products...

Been a big fan of CONVERT since I discovered you could use it when converting strings back to dates as well!

For the ultra purist uses the fact that with date...

Learning new stuff - Always great 🙂

@Nils - I'm sure there is an article of Service Broker just waiting to come out and educate us all. Thanks for the info

I'd have to agree with that suggestion vehemently...

Second reason - Your still inside the transaction and locking thise resources. Someone else is waiting!

Edit: I know thats what Jeff said! I'm...

If you need to rebuild your indexes that often then I would suggest that you look at rebuilding with a lower fill-factor and pad-index.

For the log shipping, think about it...

I question this, but will bow to your experience....