Viewing 15 posts - 316 through 330 (of 1,518 total)
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 you, so...
__________________________________________________________________________________
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 9, 2011 at 9:02 am
My advice: stick to the default settings for the install files.
We have had an issue with our cluster installations, where we were also installing on D:
The logship.exe file, used for...
__________________________________________________________________________________
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 8, 2011 at 3:01 pm
OK, I started a profiler trace and created an fts index on Management Studio. Turns out I was forgetting a pair of parentheses...
Should be:
USE AdventureWorks2008;
GO
CREATE FULLTEXT CATALOG ftCatalog;
GO
CREATE FULLTEXT INDEX...
__________________________________________________________________________________
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 8, 2011 at 11:25 am
That works great, thank you!
__________________________________________________________________________________
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 4, 2011 at 2:25 pm
I'm glad this is of potential use to you.
Go ahead and download the code, deploy it and please let me know of any bugs or anything I may 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]
April 1, 2011 at 7:10 am
Thank you all for your thoughts on this. At the moment I am sticking with daily backups/restores and databases in SIMPLE recovery.
I will need to test any changes to this...
__________________________________________________________________________________
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]
March 31, 2011 at 7:44 am
I just tested it, it works.
__________________________________________________________________________________
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]
March 25, 2011 at 3:12 am
Thanks both for the suggestions. For some reason I thought ALTER TABLE...ALTER COLUMN did not work for IDENTITY columns.
I must have been thinking of something else.
__________________________________________________________________________________
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]
March 25, 2011 at 2:57 am
UMG Developer (3/21/2011)
Marios Philippopoulos (3/19/2011)
In the Disk Usage by Top Tables report I see a few tables named with application-specific names, such as "dbo.#CustomerData", whereas...
__________________________________________________________________________________
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]
March 21, 2011 at 9:40 am
Check the "avg page life expectancy" counter.
If it is consistently lower than 300-500 sec, then you definitely have memory pressure.
__________________________________________________________________________________
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]
March 21, 2011 at 6:06 am
GilaMonster (3/20/2011)
Marios Philippopoulos (3/19/2011)
Can you elaborate on the latter two? "table parameters or cached temp table shells".
For table-type parameters see Books Online.
Since 2005 SQL can cache temp tables that are...
__________________________________________________________________________________
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]
March 20, 2011 at 5:39 am
I have a few questions for you:
Is your sql instance on 32- or 64-bit platform?
What is the RAM on the server?
Is the instance sharing resources with other applications or SQL...
__________________________________________________________________________________
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]
March 19, 2011 at 7:12 pm
GilaMonster (3/19/2011)
There's no way in SQL to link a temp table back to its session.The tables with hex names are table variables, table parameters or cached temp table shells.
Can you...
__________________________________________________________________________________
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]
March 19, 2011 at 7:09 pm
UMG Developer (3/18/2011)
* Expand Databases
* Expand...
__________________________________________________________________________________
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]
March 19, 2011 at 4:12 pm
Tara-1044200 (3/17/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]
March 18, 2011 at 5:50 pm
Viewing 15 posts - 316 through 330 (of 1,518 total)