https://github.com/seniuka/centraldb

I am really trying to update the scripts to support the newer SQL versions and modernize the code. I am slowly updating the reports to pretty them...

Hey this is a great tool for a security conscious DBA!

I have one suggestion, for the SA check could you maybe add an additional check to see if the...

You could always blame the storage or network teams, that seems to work well. 😀

I would like to point out that sometimes the dark art of query optimization is just...

I thought it was just decreasing the waitfor command by 2 or 3 seconds to gain performance. 😀 Just kidding.

Thanks Gail for the informative article.

Just wanted to bump this one up.

I also just had this happen and I am curious what the solution is, as I haven't found much on the internet about...

Thanks, didn't read that. 🙂

I get

Average Page Life Expectancy

NULL

SQL Server 2012 11.0.3339

odd...

SELECT

object_Id

, name

, ROW_NUMBER() OVER (PARTITION by schema_id ORDER BY object_id) as RowID

from

sys.objects

You will need to drop the database from the availability group then after renaming it add it back into the availability group. Make sure you go to the secondary server...

Mauve (11/14/2013)

---

I assign all of my SQL Server logins to the tempdb as the default database. NEVER master. This way no harm can be done by an application...

Excellent article, disk is cheap until you start factoring in the other costs and requirements.

My oldest version 2005 9.0.1399 gives me this error

Msg 1001, Level 15, State 1, Line 77

Line 77: Length or precision specification 0 is invalid.

Command(s) completed successfully. - I ran this on 10.50.4263, 10.50.2500, 10.50.4000 and 10.0.5826 with no issues...

What versions are you running we may have a fix applied in the most...

This ran fine on SQL 2008 and SQL 2008 R2.

This would be a great report to run on systems with a few parameters like date range and increment amount (aka...

Michael Meierruth (11/8/2012)

---

Adam,

There is something not right with your 'exec' statment with all those quotes and parenthesis. Can't quite grasp what it is.

But I definitely like this 'with TABLERESULTS' clause....