The divide by percentage in the plans is a relative value. 75% isn't necessarily something to be concerned about. It depends on how "much" 100% is.

If 100% is "a...

I disagree with the notion that dirty reads is inherently evil - it's not. Also, doing it cannot corrupt data in any way - since it's a read op, not...

Hmmm... CPU at 100% you say... That's not 'normal'... Is it spiking to 100% on both occasions? Fast and slow runs? If only on the long runs, then perhaps what...

Basically, yes. Once the optimizer has decided upon a plan, it will be used.

Now, the interesting part is how a plan gets to be decided upon. Just because a certain...

Do you mean 'keys' as in 'declared primary keys'..?

If so, perhaps it's better to not bother about which tables are involved, just let sp_helpconstraint suffice. (look inside sp_helpconstraint and you'll...

If I read the posted problem correct, it was 'how to insert 100 rows with incrementing values in an "easy" way'..

Here's another variant I use whenever it's a one-time op (like...

..still curious I am....

anyways, it should work I guess, after some editing of the file.. I suppose that you don't want to count...

Though, using SELECT MAX() to find the next number isn't very scalable, and it's really aggressive on concurrency. If you get any significant number of rows in the table, you're...

If you do your own 'number-generator' the right way, then yes, it will be safe. Here's a thread where you can find a method how to increment and assign a...

The error started coming up because a reserved word was used, it's as simple as that.

By using reserved words, it's not a question of if, but rather when your code...

'It depends'

If.... it is ok by the business rules that the SELECT statment may show data that are in transit - ie 'logically'...

Just curious, why do you want to count the 'lines'..?

If you have two procs, with statements like these - are they to be considered the same # lines or not?

ummm.. are you really going to give away that kind of power to HR..?

imo one of the DBAs responsibilities is to be on top of the security regarding one's system(s).

Another,...

Yikes!

Yes, yes - Listen to Noel.

Do NOT place a printing operation inside a trigger! Never ever! Do not ever ever place anything inside...

Since there seems to be doubts about the format of names and such, you might consider another approach?

Maybe just print out all your users (sort how you see fit) and...