Viewing 15 posts - 271 through 285 (of 1,518 total)
Thanks for the link, I'll have a look.
Now that I have got this to work, I can get down to the business of automating some of the tasks 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]
June 17, 2011 at 12:53 pm
I got the script to work by launching powershell from Start --> Run and typing powershell, clicking OK.
However, when I launch powershell from SQL Server Management Studio (SQL-2008), I get...
__________________________________________________________________________________
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]
June 17, 2011 at 12:43 pm
Oh well, I guess I will open a PSS case with Microsoft... 😎
__________________________________________________________________________________
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]
June 16, 2011 at 9:04 am
Here is some more info on this, just to give everyone a better idea on what is going on.
Results from sp_helpfile (focusing on the PRIMARY and IDX filegroups of the...
__________________________________________________________________________________
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]
June 14, 2011 at 2:39 pm
Any more thoughts anyone? This is very bizarre...
__________________________________________________________________________________
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]
June 14, 2011 at 2:31 pm
Thank you, much appreciated!
__________________________________________________________________________________
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]
June 14, 2011 at 8:27 am
Here is what I get:
Major Minor Build Revision
----- ----- ----- --------
2 0 -1 ...
__________________________________________________________________________________
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]
June 10, 2011 at 3:14 pm
No, this database was never on SQL 2000. It started off as a SQL-2005 database.
__________________________________________________________________________________
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]
June 10, 2011 at 2:18 pm
I must admit I've always played around with the MAXDOP setting when I had high CXPACKET waits.
Grant's suggestion is something I had never considered before.
So, if I understand it...
__________________________________________________________________________________
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]
June 10, 2011 at 1:29 pm
I agree with Grant; best to first stop the SQL services and then restart the server, just to be on safe side.
You never know if by some bad stroke of...
__________________________________________________________________________________
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]
June 10, 2011 at 1:17 pm
I'm asking because I'm trying to gauge whether it makes sense to be polling this view at regular intervals (say once a day) and storing the results in a table...
__________________________________________________________________________________
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]
June 10, 2011 at 11:35 am
GilaMonster (6/9/2011)
Not too bad.Either there was some incredibly long-running transaction that had to be rolled back, or there was some IO contention (or both)
I'm sure about the 1st one, and...
__________________________________________________________________________________
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]
June 9, 2011 at 12:56 pm
Under which account is the full-text filter daemon launcher service running?
You need this service running if your application is using the Full-Text Search feature.
Also make sure that the Named Pipes...
__________________________________________________________________________________
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]
June 9, 2011 at 12:14 pm
Database finally recovered after about 2 hrs.
__________________________________________________________________________________
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]
June 9, 2011 at 12:07 pm
Thank you, I'll check.
__________________________________________________________________________________
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]
June 9, 2011 at 9:22 am
Viewing 15 posts - 271 through 285 (of 1,518 total)