Resource Governor in SQL Server 2008

This article describes how Database Administrators can manage SQL Server workload and critical system resource consumption using Resource Governor in SQL Server 2008

Resource Governor

This article is about Resource Governor. A new feature introduced in SQL Server 2008. Special focus is placed on the T-SQL implementation of the new feature.

Resource Governer

Resource Governer

Resource Governor

RE: Exists Vs IN

Gr8 explnations  Kenneth.

RE: How to get column value as column name

Hey Rajiv, u will get it very clear with following query.It's same as above but slight change. SELECT MIN(CASE Description WHEN 'Tiering' THEN Value ELSE NULL END) AS Tiering,  MIN(CASE Description WHEN 'Strategic Overview' THEN Value ELSE NULL END) AS StrategicOverview,  MIN(CASE Description WHEN 'Tier Pricing Report' THEN Value ELSE NULL END) AS TierPricing, MIN(CASE Description […]

RE: Update Query

Thanks John,This is alot more concise and does use the strength of a relational DB instead of the repetitive looping of simplistic code.I appreciate your response.

Corrupt Disk Nightmares ... Help!

Wrun SQL Server 2000 Enterprise Manager on Windows 2000 and Windows 2003.  The last month has been a nightmare as local and EMC remote disks have gone corrupt on us.   We do data warehousing so our DB is over 500 Gig.  When we load we load MBs.  Is there a virus or issues that could […]

RE: PRimary key & Performance dilemma!!

I've heard of modelling tools, but then I've heard of unicorns and phoenixes as wellTo me Key = Index.