You'd need to disable the index. But then of course you'd need to rebuild the index after your mulitple inserts.

Adding a fillfactor value to the index will minimize the...

This was an interesting article with an even more interesting discussion.

The thing I'd like to pick up on, that drew my attention, was your reasons for moving away from the...

Thanks for the link. I'll look at that.

It's been a long time since I've done this but if I remember correctly that's about right.

Check out this article: http://support.microsoft.com/kb/842425

Turns out that by repeatedly running GETDATE() as described in the article, all you're doing is measuring the clock ticks that the machine you're running on is capable of.

On some...

I get 3.3 ms here using your own code.

The worst part about it is you would have not given the job to someone who correctly responded with 3.3ms for GETDATE()...

When the procedure executes for the first time it's execution plan is stored in the procedure cache. Now, that execution plan is only really relevant for the parameters that...

Try this:

select email_address = case

when charindex('_QWER', email_address) > 0 then substring(email_address, 1, charindex('_QWER', email_address) - 1)

else email_address

end

from #tb

Each file is 30GB in size, which in total is probably twice the size that is ever allocated to tempdb so the files don't grow beyond their current size.

Generally speaking...

Generating scripts in SSMS will automatically be generated in the corrrect order.

Just right-click on the Database > Tasks > Generate Scripts.

I'm a little confused here as to what you're doing....

When you say

what recommendations are you actually talking about?

I see your dilemma - you want to spend all the money you've been given now.

Let's assume that you are going to go with RAID 10 for a minute. ...

select object_name(m.object_id) as ObjectName

from sys.sql_modules m

join sys.objects o on o.object_id = m.object_id

where definition like '% string to search for%'

and o.type in ('P', 'TR')

you can use sp_send_db_mail. You'll have to set up a database mail profile but once that's done it's pretty straight forward with sp_send_db_mail.

Not necessarily. Firstly, I've never really seen a case where RAID 10 for the OS and system drives are necessary- so RAID 1 should be sufficient. And if...