Viewing 15 posts - 736 through 750 (of 1,518 total)
Grant Fritchey (1/27/2009)
Marios Philippopoulos (1/27/2009)
What does that entail? Is it done transparently by the tool or is there anything manual that needs to be done?
When I read...
__________________________________________________________________________________
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 27, 2009 at 12:06 pm
Grant Fritchey (1/27/2009)
Yeah, I used it at a lab at the Microsoft Technology Center to test the upgrade of one of our databases. I blogged about it here[/url].
Restoring the system...
__________________________________________________________________________________
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 27, 2009 at 11:44 am
Grant Fritchey (1/27/2009)
Yeah, I used it at a lab at the Microsoft Technology Center to test the upgrade of one of our databases. I blogged about it here[/url].
Thanks! I will...
__________________________________________________________________________________
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 27, 2009 at 11:37 am
from http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx#EUVAE:
On both 32- and 64-bit platforms, memory that is allocated through the AWE mechanism cannot be paged out. This can be beneficial to the application. (This is one 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]
January 27, 2009 at 10:36 am
I found the fix: 🙂
Select “reset window layout” under Window menu drop-down:
__________________________________________________________________________________
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 27, 2009 at 10:30 am
Steve Jones - Editor (1/25/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 26, 2009 at 8:08 am
sun256 (1/23/2009)
I am in the process of migrating sql server 7.0 to sql server 2005..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 24, 2009 at 6:07 am
GSquared (1/23/2009)
And don't worry too much about a server-side trace (the kind I'm talking about) taking a lot of server resources 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]
January 24, 2009 at 5:56 am
GilaMonster (1/23/2009)
Marios Philippopoulos (1/23/2009)
There is a risk that the data from the DMV dm_exec_query_stats is regularly flushed from memory if there is memory pressure in your system.
There's a couple...
__________________________________________________________________________________
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 24, 2009 at 5:50 am
We use filegroups to - ideally - split the database I/O among several independent disks (spindles) for better performance. Disk I/O is the largest bottleneck in terms of database performance.
Access...
__________________________________________________________________________________
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 23, 2009 at 2:26 pm
You can run a trace, but it's so... 20th century! 🙂
Use this query to capture your most frequently-run SQL statements (modify per your requirements):
SELECT TOP 10 *
,[Individual Query] =...
__________________________________________________________________________________
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 23, 2009 at 2:13 pm
Mike Levan (1/23/2009)
select distinct e.code,startdate,enddate
into #f
from exams e
inner join
...
__________________________________________________________________________________
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 23, 2009 at 1:14 pm
Carolyn Richardson (1/22/2009)
Down load a trial of SQL Sentry if a deadlock fires it should give you the items that are in the chain of events. http://sqlsentry.net/sql-performance
Thank you, my main...
__________________________________________________________________________________
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 22, 2009 at 12:30 pm
Jason Crider (1/22/2009)
We have 16GB of RAM and I currently have AWE enabled with Max and Min Memory...
__________________________________________________________________________________
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 22, 2009 at 8:14 am
george sibbald (1/21/2009)
the article mentioned that VM streamlines the DR process, but for that to be fully...
__________________________________________________________________________________
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 21, 2009 at 7:42 am
Viewing 15 posts - 736 through 750 (of 1,518 total)