Viewing 15 posts - 751 through 765 (of 1,518 total)
jesse.roberts (1/14/2009)
Hey mariosJust a followup the alert supression is working perfectly.
Jesse
Nice! I'm going to have to make use of this at some point - some of our users are starting...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
January 14, 2009 at 12:30 pm
Marios Philippopoulos (1/12/2009)
GSquared (1/12/2009)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
January 12, 2009 at 11:51 am
GSquared (1/12/2009)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
January 12, 2009 at 11:47 am
GSquared (1/12/2009)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
January 12, 2009 at 11:23 am
Thanks guys for your suggestions.
In the past, I remember running a sql script file on the same folder as the powershell script itself, and getting an error if I did...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
January 9, 2009 at 7:52 am
henrik staun poulsen (1/8/2009)
How do you tell the difference between mediocre and great Admin?
We have two people working with the SANs, but are they any good???
I would like...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
January 9, 2009 at 3:29 am
Nilesh Patel (1/8/2009)
Thanks to both Marios and SQLEngine... I think I am starting to understand how things are working now..
There is no substitute for experimentation. The best way to learn...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
January 8, 2009 at 5:45 pm
jesse.roberts (1/8/2009)
The SQL 2000 script is working there was an extra _ in one of the lines but no big deal
I have to test out the SQL 2005...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
January 8, 2009 at 1:55 pm
matt stockham (1/8/2009)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
January 8, 2009 at 11:40 am
TheSQLGuru (1/8/2009)
Marios Philippopoulos (1/8/2009)
TheSQLGuru (1/8/2009)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
January 8, 2009 at 11:24 am
Nilesh Patel (1/8/2009)
Great article. At last I found something that explains customizing SCOM monitoring from SQL. It seems that the tool is very powerful but hard to learn. I have...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
January 8, 2009 at 11:07 am
jesse.roberts (1/7/2009)
I've been looking for something like this for a while. We don't really want to store the data for future analysis on a seperate db. Is there anyway...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
January 8, 2009 at 10:53 am
Jeffrey Williams (1/8/2009)
Just wait till v2 - which includes full Try/Catch functionality.
That's cool.
What tool do you use to work with powershell scripts?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
January 8, 2009 at 10:43 am
Jeffrey Williams (1/8/2009)
Trap [Microsoft.SqlServer.Management.Common.ExecutionFailureException] {
Write-Output $("Exception: $($_.Exception.Message)");
Write-Output $("Base Exception: $($_.Exception.GetBaseException().Message)");
return;
}
In the above, I am trapping for a specific...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
January 8, 2009 at 10:29 am
Jeffrey Williams (1/8/2009)
Interesting - you probably have a character in the computer name that is causing a problem.
Actually, there was nothing wrong with the original code. Even taking the quotes...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
January 8, 2009 at 10:14 am
Viewing 15 posts - 751 through 765 (of 1,518 total)