Viewing 15 posts - 1,441 through 1,455 (of 1,518 total)
Christopher Ford (2/19/2008)
ISBN: 0735623139
That will help you tremendously in getting up to speed on SQL 2005 as well as...
__________________________________________________________________________________
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]
February 19, 2008 at 11:37 am
I don't have anything specifically on SAN or clustered environments, but here are some links to get you started. I have found them, especially the 1st one, to be very...
__________________________________________________________________________________
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]
February 19, 2008 at 11:16 am
CoetzeeW (2/8/2008)
3:
How to I determine the total cost of a query in sql server profiler ?
By no means the only way, but I tend to focus on the reads...
__________________________________________________________________________________
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]
February 19, 2008 at 10:12 am
fred (2/18/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]
February 19, 2008 at 9:48 am
page allocations for a table without a clustered index (heap) never result in a page split
Sweet! Thanks for the info and link, that's great!
__________________________________________________________________________________
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]
February 19, 2008 at 9:29 am
I would put the UDFs in the model database, then create a SYNONYM in each of the user databases ("dbname" is the name of such a database in the following...
__________________________________________________________________________________
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]
February 19, 2008 at 9:16 am
Matt, I completely agree with most of your points, but are you sure about the last one?
Heaps don't have page splits.
An update of a VARCHAR column 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]
February 19, 2008 at 8:53 am
If a row is in a page, and its varchar column is updated from holding 20 characters to 5000 characters, then it's going to cause a page split if...
__________________________________________________________________________________
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]
February 19, 2008 at 8:20 am
You also may want to consider making your primary key ID column non-clustered and define your clustered index on a more suitable column, eg. a record timestamp.
Queries involving a *range*...
__________________________________________________________________________________
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]
February 19, 2008 at 1:59 am
To retrospectively figure it out, as I wrote earlier:
To get a feel on whether a 90% fill factor is adequate for your index, you can monitor
sys.dm_db_index_physical_stats.avg_page_space_used_in_percent over a period...
__________________________________________________________________________________
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]
February 18, 2008 at 10:59 pm
shipleyv (2/18/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]
February 18, 2008 at 12:09 pm
I know little about this topic, but isn't Notification Services canned in SQL Server 2008?
If so, you might have a problem if and when you decide to upgrade to a...
__________________________________________________________________________________
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]
February 18, 2008 at 1:08 am
Also, you may want to consider
Inside Microsoft® SQL Server™ 2005: The Storage Engine
by
Kalen Delaney (Solid Quality Learning)
(http://www.microsoft.com/MSPress/books/7436.aspx)
__________________________________________________________________________________
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]
February 18, 2008 at 12:48 am
As Jeff mentions, start from here:
http://msdn2.microsoft.com/en-us/library/ms130214.aspx
__________________________________________________________________________________
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]
February 18, 2008 at 12:35 am
Is there a possibility that the user1 would have records with Id 1, 3, 4, 6, 7 and user2 with Ids- 2,5,8,9,10? (overlapping Id's)
If the example you quote here 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]
February 18, 2008 at 12:17 am
Viewing 15 posts - 1,441 through 1,455 (of 1,518 total)