Viewing 15 posts - 1 through 15 (of 52 total)
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...
November 20, 2018 at 2:22 pm
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...
February 2, 2016 at 1:36 pm
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...
September 23, 2014 at 10:49 am
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.
September 22, 2014 at 1:36 pm
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...
June 12, 2014 at 10:53 am
I get
Average Page Life Expectancy
NULL
SQL Server 2012 11.0.3339
odd...
May 13, 2014 at 2:27 pm
SELECT
object_Id
, name
, ROW_NUMBER() OVER (PARTITION by schema_id ORDER BY object_id) as RowID
from
sys.objects
December 5, 2013 at 8:01 am
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...
November 28, 2013 at 12:31 pm
Mauve (11/14/2013)
November 14, 2013 at 9:19 am
Excellent article, disk is cheap until you start factoring in the other costs and requirements.
October 30, 2013 at 10:47 am
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.
January 29, 2013 at 7:44 am
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...
January 29, 2013 at 7:40 am
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...
January 29, 2013 at 7:10 am
Michael Meierruth (11/8/2012)
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....
November 8, 2012 at 9:54 am
Viewing 15 posts - 1 through 15 (of 52 total)