I have had the same question for some time and just did a test.

Created a SQL-CLR assembly from a dll file, then moved the dll to another location.

Restarted the instance,...

According to the following link, I don't need to do anything on the full-text indexes on the mirror side (following failover), if auto-change tracking was already on in the principal...

Have a look at this link, it's for SQL 2005, but also applies to SQL 2008:

http://technet.microsoft.com/en-us/library/cc966401.aspx

"...Consistently low average page life expectancy. See Average Page Life Expectancy Counter which is in...

michael-753984 (4/20/2011)

---

Didn't think about PowerShell actually, anything is possible with it.

Would just need to ajust it to execute a .sql file instead of inline sql and it would do the...

Did you change the comp level to 100 before updating stats?

Dumb question, but I have made that mistake a few times in the past.

Not sure if this is what you need, but here is a simple powershell script that performs an example query on any number of SQL instances and returns the result:

#Variables

$Computers...

You may need to upgrade to Cumulative Update 3 for SQL Server 2008 Service Pack 2:

http://support.microsoft.com/kb/2403218#appliesto

Ninja's_RGR'us (4/18/2011)

---

GilaMonster (4/16/2011)

---

Yup, that's pretty much what I was thinking about.

Just one comment, if the session_id>50 is supposed to filter out system processes, remove it as it won't necessarily do...

GilaMonster (4/16/2011)

---

Yup, that's pretty much what I was thinking about.

Just one comment, if the session_id>50 is supposed to filter out system processes, remove it as it won't necessarily do what...

I wrote an article some time ago that suggests a way of tracking tempdb utilization using reporting services:

http://www.sqlservercentral.com/articles/tempdb+utilization/65149/

(unfortunately, some of the figures are a bit too small to see clearly,...

isd83 (4/15/2011)

---

I am doing the same 4 nodes sql cluster installation too. My question is on MSDTC. I know this requirs disk drive and ip address. Do I need just...

Hmm, the problem with sys.fulltext_index_columns is that I didn't know about that catalog view... 😛

Now I do, thank you!

Here is the revised query:

SELECT

t.name AS TableName,

c.name AS FTCatalogName...

The query below actually...

Thank you, we are developing some new FTS functionality and will test with the service down to see what happens.

Marios Philippopoulos (4/9/2011)

---

Thank...