Viewing 15 posts - 676 through 690 (of 1,518 total)
scotta_miller (3/23/2009)
I followed the doc included in the zip file. In reporting services The servernames Dataset returns the correct server...
__________________________________________________________________________________
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 23, 2009 at 12:46 pm
scotta_miller (3/23/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]
March 23, 2009 at 12:26 pm
Steve Jones - Editor (3/23/2009)
symmetric keys to encrypt dataasymmetric keys to encrypt the symmetric key.
Thank you for the info!
__________________________________________________________________________________
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 23, 2009 at 10:19 am
Leo (3/22/2009)
1. What about detach the database in 2000 and reattach in 2008? It should be okay, isn't it?
There are 3 steps you need to follow after you re-attach...
__________________________________________________________________________________
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 22, 2009 at 5:42 pm
The 4-volume series titled "INSIDE MICROSOFT SQL SERVER 2005" by Kalen Delaney et al. is probably one of the better publications out there. I have learned and I'm still learning...
__________________________________________________________________________________
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 22, 2009 at 6:13 am
mishaluba (3/21/2009)
Thank you for the article and detailed solution. I had no idea that RS reports could be made so interactive using "Actions". Learning something every day!
Thanks! 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]
March 22, 2009 at 5:40 am
Rick Romack (3/16/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]
March 16, 2009 at 5:12 pm
Unfortunately, some of the figures are not clear enough. I will make sure I make them larger for the next article. 🙂
Please have a look at the supp. material, 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]
March 16, 2009 at 5:23 am
Thanks both, it seems I need to brush up on my knowledge of query-plan operators... 🙂
I'm still puzzled on this though:
where do the scans reported on the OID-based indexes...
__________________________________________________________________________________
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 5, 2009 at 2:19 pm
Bruce W Cassidy (3/5/2009)
Marios Philippopoulos (3/5/2009)
Actually, ID columns can be used a lot in queries. Not in the WHERE clause of course, but, certainly when they are in join clauses.
[font="Verdana"]Er......
__________________________________________________________________________________
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 5, 2009 at 2:06 pm
GilaMonster (3/5/2009) Not necessarily. A common query on customer records is surname LIKE @Param +'%', which is a range query, but that doesn't mean that a cluster on surname 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]
March 5, 2009 at 1:51 pm
Bruce W Cassidy (3/5/2009)[font="Verdana"]Agreed. How often do you do range queries on IDs though? Generally (in my experience) range queries result from dates and (also from my experience)...
__________________________________________________________________________________
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 5, 2009 at 1:47 pm
Bruce W Cassidy (3/5/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]
March 5, 2009 at 1:30 pm
GilaMonster (3/5/2009)
Marios Philippopoulos (3/5/2009)
Based on the above info, should I be making the last index, UC_tblName_col1, clustered?
I would not look at usage to decide on a clustered index. There 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 5, 2009 at 1:17 pm
t berry (2/18/2009)
exec _getStuff%
No single quotes or anything else 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]
February 26, 2009 at 12:17 pm
Viewing 15 posts - 676 through 690 (of 1,518 total)