No announcements
Found 3533730 threads
-
3 VotesCreating indexes across servers
No, just use schemaName.TableName.Answered | 4 Replies | 2472 Views | Created by Albeart Leaon - Friday, January 4, 2013 7:20 PM | Last reply by Erland Sommarskog - Saturday, January 5, 2013 8:54 PM
-
0 Votes
scripts to find out “Unused Indexes, Duplicate indexes and Recommended Indexes” for a server across all databases
Hope its helps http://blog.sqlauthority.com/2011/01/04/sql-server-2008-unused-index-script-download/ -- Missing Indexes for ...Answered | 2 Replies | 1899 Views | Created by nrajeshkumars - Friday, June 17, 2016 9:06 AM | Last reply by PankajR - Friday, June 17, 2016 10:02 AM -
3 Votes
using database indexes with lightswitch
You can use the SQL Server Profiler and the Database Engine Tuning Advisor to watch how your database is used (the queries that are run on it) ...Answered | 5 Replies | 1832 Views | Created by Hessc - Thursday, September 4, 2014 12:28 PM | Last reply by Simon Jones [MSDL] - Thursday, September 11, 2014 3:48 PM -
6 Votes
Handling scoring and priority with search across multiple indexes
Regarding schema for a combined index, it's much easier to take the union of all fields rather than try to multiplex fields across different types.Answered | 9 Replies | 2004 Views | Created by TrevorBL - Wednesday, March 1, 2017 8:32 PM | Last reply by Bruce Johnston - MSFT - Friday, March 3, 2017 8:10 PM -
3 Votes
Database across multiple drives
Will this effect the database, or will it automatically start using the other drives??Answered | 21 Replies | 9006 Views | Created by RubSay - Thursday, March 18, 2010 12:34 PM | Last reply by RubSay - Thursday, March 25, 2010 12:44 PM -
4 Votes
Database Index
https://www.codeproject.com/articles/359654/important-database-designing-rules-which-i-fo https://support.office.com/en-us/article/Create-and-Answered | 5 Replies | 940 Views | Created by AI2012 - Friday, April 27, 2018 12:20 AM | Last reply by Uri Dimant - Sunday, April 29, 2018 6:35 AM -
1 Votes
database indexing
>I have been creating indexes manually in the database and only on those tables on which requires But I have to check it daily.Answered | 6 Replies | 1378 Views | Created by Manoj Kumar Mahto - Friday, May 2, 2014 11:24 AM | Last reply by Shanky_621 - Saturday, May 3, 2014 10:18 AM -
0 Votes
RI Across Databases?
Say you implemented RI (using triggers) and you have to restore a sligthly older version of one of the databases.Answered | 2 Replies | 4250 Views | Created by Randy Minder - Tuesday, June 9, 2009 7:34 PM | Last reply by TiborK - Wednesday, June 10, 2009 5:02 AM -
0 Votes
database engine not using the proper index
I would like to recommend you have a look at Paul’s blog elaborated on this scenario: Which index will SQL Server use to count all rows.Answered | 12 Replies | 2936 Views | Created by Chaithanya Reddy - Monday, October 10, 2011 7:02 AM | Last reply by Stephanie Lv - Wednesday, October 12, 2011 7:36 AM -
0 Votes
copy database files across
Just to make it perfectly clear: No, you can't just copy the database files while the database is in use.Answered | 10 Replies | 4179 Views | Created by neophytenik - Tuesday, August 25, 2009 4:07 PM | Last reply by Borndba - Wednesday, August 26, 2009 8:00 AM -
0 Votes
what is database re indexing
For partitioned indexes built on a partition scheme, you can use either of these methods on a complete index or a single partition of an index.Answered | 3 Replies | 9571 Views | Created by adilahmed - Wednesday, March 5, 2014 8:15 AM | Last reply by Kalman Toth - Thursday, March 6, 2014 12:02 PM -
0 Votes
Database Engine Tuning advisor dropping indexes
Hello Burt, The DTA creates hypothetical Indexes so that the database engine can create execution plan for the workload considering this index to see if ...Answered | 3 Replies | 997 Views | Created by burt_king - Tuesday, June 7, 2016 8:31 PM | Last reply by Olaf Helper - Wednesday, June 8, 2016 5:16 PM -
1 Votes
Removing redundant indexes on the database.
this might help you http://www.sqlservercentral.com/articles/Indexing/68079/ Cheers!!!Answered | 1 Replies | 8240 Views | Created by MrFlinstone - Tuesday, February 16, 2010 4:02 PM | Last reply by Ahmad Osama - Thursday, February 18, 2010 7:37 AM -
0 Votes
Rebuilding BizTak database's Indexes
Thanks,If this answers your question, please use the "Answer" button to say so | Ben ClineAnswered | 2 Replies | 6535 Views | Created by Mstanford - Monday, February 15, 2010 5:44 PM | Last reply by Ben Cline1 - Tuesday, February 16, 2010 4:14 PM -
0 Votes
index corruption in the database
If you repeatedly get corruptions in your database, then you should address the root cause.Answered | 3 Replies | 2551 Views | Created by Chandu_Soft - Tuesday, October 1, 2013 11:12 AM | Last reply by TiborK - Wednesday, October 2, 2013 5:31 AM -
0 Votes
Adaptive Indexing In Crowd Databases?
Maybe you need to post to a MSDN Database forum.Answered | 3 Replies | 1125 Views | Created by cpluspro - Sunday, May 8, 2016 6:46 PM | Last reply by Lydia Zhang - Monday, May 9, 2016 3:12 AM -
3 Votes
Service Broker across database versions
This blog describes how to setup Secure SQL Server Service Broker across databases in less than 10 ...Answered | 2 Replies | 5202 Views | Created by Shival Mathur - Wednesday, October 17, 2012 6:19 AM | Last reply by Iric Wen - Thursday, October 18, 2012 7:44 AM -
1 Votes
How to Properly Index a Database
I've never seen the use of cell mentioned in databases.Answered | 15 Replies | 3902 Views | Created by Matt Demakos - Sunday, July 10, 2011 1:39 PM | Last reply by Tony Toews 0 - Sunday, July 10, 2011 10:29 PM -
0 Votes
Listing dependencies across databases
So using sp_msforeachdb, you first load database and object names into a single table (basically a globallised version of sysobjects).Answered | 3 Replies | 6156 Views | Created by Yash Ganthe - Tuesday, January 6, 2009 1:21 PM | Last reply by Dan Cambridge - Thursday, July 26, 2012 9:32 AM -
5 Votes
Unique Index across multiple Columns with Where
Hi Ryan, Thanks for your reply.Answered | 7 Replies | 1031 Views | Created by Ryan0827 - Friday, November 2, 2018 9:42 PM | Last reply by Rachel_Wang - Thursday, November 8, 2018 8:35 AM - Items 1 to 20 of 3533730 Next ›
No announcements
