The stored procedure in the article uses WITH EXECUTE AS. Not sure what you are asking specifically or that you...

You can see how to use a certificate signed assembly on my article Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents[/url] to keep from having to...

Edogg (12/16/2009)

---

You can uninstall CU 6 for SP3 by going into Control Panel, Add or Remove Programs, check the "show updates" box at the top, find hotfix 4266 listed under...

GilaMonster (12/15/2009)

---

That's a problem. The heap can't be rebuilt, except by putting a cluster on it, and if there are pages partially used in the heap they'll stay partially used...

Is it possible that Ghost Cleanup just hasn't run yet?

Inside the Storage Engine: Ghost cleanup in depth

Look at Perry Whittle's articles on here:

http://www.sqlservercentral.com/articles/65994/

http://www.sqlservercentral.com/articles/66246/

He uses Virtual Server 2005 but the fundamentals of the cluster configuration are the same regardless of the virtual platform you are building it...

A few examples are on my blog post:

Getting log space usage without using DBCC SQLPERF

Make sure to read the comments section as well.

Microsoft provides a couple of stored procedures that can do this for you. Pick the appropriate version of their code from the following link:

Transfer Logins between Servers via Script

and...

Exactly my...

sbowell (12/10/2009)

---

Hi Jack,

I'm not using any COM objects in the SQLCLRManager.

Also worth noting is that this has been working fine for several weeks.

C# Screw,

That is exactly what its for....

Jack is correct here. The actual concurrent worker limit would be dependent on what platform you are running on. A 32bit installation would only have 256 workers, and...

Dean Jones-454305 (12/12/2009)

---

1) how many physical spindles underly your tempdb partition.

2 spindles for system DB's, as there is a seperate LUN for this, and the size needed is small,...

What is your PAGE_VERIFY set to currently? If you are on SQL Server 2005, CHECKSUM is the recommended best practice setting for this, which stamps each page with a...

One thing to keep in mind is that if you use Lock Pages in Memory, you won't see SQL Servers memory consumption in Task Manager. You have to track...

Not for servers that are dedicated to SQL Server, have a lot of RAM (more than 8GB), and have a proper configuration setting for max server memory.

Locking pages...