Sort of. A derived table attempt...

Cheers Jason.

Now that we know more about the requirements, it may be that partitioning is not a good solution. The requirement to build ONLINE would certainly have been a...

http://blogs.msdn.com/sqlserverstorageengine/archive/2006/05/17/Lock-escalation.aspx (5000 held locks, approximately)

tacy.highland (12/14/2009)

---

Hmmm. I've never used "except" before. But when I run that query, it says "Incorrect syntax near the keyword 'EXCEPT'." ...?

But, wouldn't this theoretically just pull up...

Liked the article thanks.

But, uh-oh, here we go again with the string-splitting debate...:laugh:

Like it or not, the overall best method ever is to use a CLR TVF. It just...

Similar to my own questions :laugh:

It's interesting because we have a NetApp box coming in the next few weeks - just to handle shared drives and such - so it's...

If you have a moment, run the following and post the results please.

select objtype,

count(*) as number_of_plans,

sum(cast(size_in_bytes as bigint))/1024/1024 as size_in_MBs,

avg(usecounts) as avg_use_count

from sys.dm_exec_cached_plans

group by objtype

It would also be...

You really need to analyse where the current bottlenecks are before embarking on such a bold project.

http://technet.microsoft.com/en-gb/library/cc966413.aspx

That White Paper is a great starting point. Depending on what your main...

One would tend to assume that lock contention was the issue, or maybe the waits are on log flushes? Hard to say without more information.

You will probably find the...

There are plenty of optimizations available here. The best solution will depend on your particular circumstances and priorities, but there's certainly no need to 'give up' and just put...

As Jason rightly points out, you can (usually) rebuild an index a partition at a time, or indeed for more than one partition in 2008. So long as no...

It has the distinct advantage of at least being documented ;-). xp_cmdshell...

NetApp DP, why it can be (allegedly) as fast as RAID 10, even though typical RAID 6 is always slower than RAID 5...

http://blogs.netapp.com/extensible_netapp/2009/03/understanding-wafl-performance-how-raid-changes-the-performance-game.html

http://blogs.netapp.com/extensible_netapp/2009/05/raid-dp-better-performance-with-less-hardware-and-more-availability.html

Yes - partitioning is an Enterprise-only feature. You could indeed consider using a partitioned view, but you should probably take a step back before making such a big change....

SELECT definition

FROM sys.sql_modules

WHERE definition LIKE '%[0-9].[0-9].[0-9].[0-9]%'

OR definition LIKE '%[0-9].[0-9].[0-9].[0-9][0-9]%'

OR definition LIKE '%[0-9].[0-9].[0-9].[0-9][0-9][0-9]%'

OR ...