Viewing 15 posts - 811 through 825 (of 1,518 total)
I would define the clustered index on one of the columns used in the ORDER BY clause. The USER_NAME or LOG_DATE_TIME columns might be good candidates.
__________________________________________________________________________________
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]
December 18, 2008 at 3:35 am
GilaMonster (12/17/2008)
Since you're on 2005, join to sys.tables. Only user tables appear in that view.sysobjects is deprecated in 2005 and above and will be removed in a future version.
Good point,...
__________________________________________________________________________________
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]
December 17, 2008 at 1:32 pm
george sibbald (12/17/2008)
join to the sysobjects table, sytem tables have an XTYPE = 'S'
Thank you sir!
__________________________________________________________________________________
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]
December 17, 2008 at 12:49 pm
If multiple processors being used by your system's workload is a problem, it might be indicative of badly written queries and/or missing indexes.
On the other hand, if your system functions...
__________________________________________________________________________________
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]
December 17, 2008 at 11:17 am
Brian, thanks for taking the time to write about this. It's so important and, at the same time, such a pain to understand and implement properly.
I have recently come across...
__________________________________________________________________________________
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]
December 11, 2008 at 7:48 am
Nick1234 (12/8/2008)
Perhaps check your accounts under Reporting Services Configuration Manager under "Database Setup" and "Execution Account". Have you changed a password recently?
This seems to be an issue with Kerberos...
__________________________________________________________________________________
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]
December 8, 2008 at 2:33 pm
Grant Fritchey (12/5/2008)
__________________________________________________________________________________
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]
December 5, 2008 at 12:25 pm
Grant Fritchey (12/5/2008)
It's 4,5,and 6 that we're going for, paying for them with 1,2 and 3 and the other things already mentioned on this thread because, after all, TANSTAAFL.
What is...
__________________________________________________________________________________
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]
December 5, 2008 at 11:53 am
A few more things to consider with any isolation level that uses the version store (BTW, the following points are taken from INSIDE MICROSOFT SQL SERVER 2005: THE STORAGE ENGINE...
__________________________________________________________________________________
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]
December 4, 2008 at 1:51 pm
Grant Fritchey (12/4/2008)
__________________________________________________________________________________
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]
December 4, 2008 at 12:46 pm
Grant Fritchey (12/4/2008)
__________________________________________________________________________________
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]
December 4, 2008 at 12:29 pm
Jonathan Kehayias (11/24/2008)
My appologies, I didn't see that you had previously responded. Your problem is that you are running SQL Server on a 32 bit server, and it has...
__________________________________________________________________________________
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]
November 24, 2008 at 1:06 pm
Hey guys, any ideas?
I'm still getting this error:
Msg 50000, Level 16, State 1, Procedure ..., Line ...
An error occurred in the Microsoft .NET Framework while trying to load assembly id...
__________________________________________________________________________________
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]
November 24, 2008 at 9:15 am
kingshukbagchi (11/19/2008)
This has actually worked for me... have you done "alter database [database name] set enable_broker"?Kingshuk
yes
__________________________________________________________________________________
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]
November 20, 2008 at 7:47 am
Steve Jones - Editor (11/19/2008)
__________________________________________________________________________________
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]
November 19, 2008 at 6:21 pm
Viewing 15 posts - 811 through 825 (of 1,518 total)