is "Optimize for AdHoc workloads" enabled? If so, try disable that option (server option, no restart necessary)

my 50 cents:

select cast(replace(replace(replace(replace(convert(varchar, current_timestamp,121),'-',''),':',''),' ',''),'.','') as bigint)

NOTE: This function works with SQL2008R2 SP1 and upwards. So if you're still having an RTM version, it's time to update! :hehe:

I already noticed the missing quote and fixed the code. However, the SQLServerCentral team first reviews every change before it's published so there's a slight delay before it's available. The...

We had an application which installed a database for every company defined in our organization. Each database had a postalcode table which was updated several times a year. So I...

The title is suggesting the most expensive, but you're actually reporting the most used SPs, which is not by default the most expensive. I suggest to rename the title

what's wrong with sp_udatestats ?

I advise you to have a look at http://www.sqlskills.com, which contains some excellent articles about index management.

A direct answer to your question: http://www.sqlskills.com/blogs/kimberly/ever-increasing-clustering-key-the-clustered-index-debate-again/

Good addition, thanks for your reply!

That's due to some charset issues when pasting the code into the editor.

If you copy the code to the clipboard and paste it in an editor like NotePad++, you'll...

** UPDATE **

I added support for SQL 2000, removed the Licensetype column (according to BOL, this always returns DISABLED) and added columns for Isclustered, FulltextInstalled and HadrStatus (which is a...

that's probably due to character settings. I suggest to copy the code into an editor and replace strange characters with a space. then it will work.

Here's a handy function which shows the current status of the exec_queue:

if exists (select 1 from sys.objects where name = 'udf_queue_status')

drop function dbo.udf_queue_status

go

create function dbo.udf_queue_status()

returns table

as

...

seems SSC adds something in front of it, copy/paste: http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/

aha, the never-ending question about multicolumn or single column indexes!

Again, check Gail's excellent articles about indexes:

http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/%5B/url%5D