Viewing 15 posts - 301 through 315 (of 1,518 total)
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,...
__________________________________________________________________________________
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]
April 20, 2011 at 2:28 pm
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...
__________________________________________________________________________________
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]
April 20, 2011 at 1:41 pm
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...
__________________________________________________________________________________
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]
April 20, 2011 at 10:51 am
michael-753984 (4/20/2011)
Would just need to ajust it to execute a .sql file instead of inline sql and it would do 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]
April 20, 2011 at 10:20 am
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.
__________________________________________________________________________________
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]
April 19, 2011 at 2:08 pm
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...
__________________________________________________________________________________
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]
April 19, 2011 at 2:04 pm
You may need to upgrade to Cumulative Update 3 for SQL Server 2008 Service Pack 2:
http://support.microsoft.com/kb/2403218#appliesto
__________________________________________________________________________________
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]
April 18, 2011 at 2:17 pm
Ninja's_RGR'us (4/18/2011)
GilaMonster (4/16/2011)
Just one comment, if the session_id>50 is supposed to filter out system processes, remove it as it won't necessarily do...
__________________________________________________________________________________
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]
April 18, 2011 at 7:59 am
GilaMonster (4/16/2011)
Just one comment, if the session_id>50 is supposed to filter out system processes, remove it as it won't necessarily do what...
__________________________________________________________________________________
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]
April 16, 2011 at 4:34 pm
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,...
__________________________________________________________________________________
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]
April 16, 2011 at 5:48 am
isd83 (4/15/2011)
__________________________________________________________________________________
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]
April 16, 2011 at 5:25 am
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...
__________________________________________________________________________________
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]
April 15, 2011 at 7:44 am
Marios Philippopoulos (4/11/2011)
Craig Purnell (4/11/2011)
I think that's right.Thank you, we are developing some new FTS functionality and will test with the service down to see what happens.
The query below actually...
__________________________________________________________________________________
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]
April 13, 2011 at 8:39 am
Craig Purnell (4/11/2011)
I think that's right.
Thank you, we are developing some new FTS functionality and will test with the service down to see what happens.
__________________________________________________________________________________
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]
April 11, 2011 at 12:06 pm
Marios Philippopoulos (4/9/2011)
Craig Purnell (4/9/2011)
The Filter Daemon launches filter processes. Starting in SQL 2008, the Full Text engine is entirely within the SQL engine. See MSDN for more info:
Thank...
__________________________________________________________________________________
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]
April 11, 2011 at 11:59 am
Viewing 15 posts - 301 through 315 (of 1,518 total)