No announcements
Found 2273993 threads
-
0 VotesUsing indexes across databases
Jim, It should be using indexes across databases on the same server. You ...Answered | 3 Replies | 4612 Views | Created by jdyoumans - Wednesday, September 24, 2008 4:58 PM | Last reply by Kalman Toth - Wednesday, September 24, 2008 5:31 PM
-
0 Votes
MOSS 2007 Database Fragmentation
On our SQL Server 2008 database server, we have a Maintenance Plan to rebuild indexes across several user-defined databases. We do this ...Answered | 1 Replies | 5519 Views | Created by yikesola41 - Saturday, June 25, 2011 1:27 PM | Last reply by Ivan Sanders - Tuesday, June 28, 2011 7:20 AM -
0 Votes
Altering table structure by comparing it to a MODEL table
Hi, I have an application which needs to use the MODEL database (This is created by me and it acts as a template) to synchronize the ...Answered | 1 Replies | 8731 Views | Created by harsh88 - Monday, August 28, 2006 7:22 AM | Last reply by harsh88 - Thursday, September 7, 2006 12:13 AM -
0 Votes
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
You can get a timeout like this for several reasons but most of the cases I have come across this error is because I am issuing a complicated query that just takes the server a long time toAnswered | 6 Replies | 5074 Views | Created by Yogesh Kumar Saini - Friday, March 28, 2008 8:08 AM | Last reply by Suprotim Agarwal - Friday, March 28, 2008 8:45 AM -
1 Votes
Need Checklist for migrating MS SQL 2005 SP2 to MS SQL 2012
+ databases using these across versions. Check this article for migration of SSRS. http://msdn.microsoft.com/enAnswered | 5 Replies | 1373 Views | Created by mahesh_ICR - Monday, July 14, 2014 11:17 AM | Last reply by mahesh_ICR - Tuesday, July 15, 2014 6:30 AM -
0 Votes
scripts to find out “Unused Indexes, Duplicate indexes and Recommended Indexes” for a server across all databases
-- Missing Indexes for all databases SELECT CONVERT(decimal(18,2), user_seeks * avg_total_user_cost * (avg_user_impact * 0.01)) AS ...Answered | 2 Replies | 1760 Views | Created by nrajeshkumars - Friday, June 17, 2016 9:06 AM | Last reply by PankajR - Friday, June 17, 2016 10:02 AM -
3 Votes
Creating indexes across servers
) the error message states that the object name contains more than the maximum number of prefixes, and that the maximum is two. is it possible to create ...Answered | 4 Replies | 2358 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
Joins across databases
Hi all Can I please have peoples opinions on performance impact of joining tables across databases (that reside on the same server instance, ie not ...Answered | 2 Replies | 3768 Views | Created by Rep Ronnie - Friday, July 9, 2010 11:26 AM | Last reply by Rep Ronnie - Friday, July 9, 2010 12:34 PM -
3 Votes
Rebuilding indexes for Biztalk Databases
Hi, You generally only need to rebuild the indexes on the BizTalk databases when the scan density of indexes is less than 30% because most indexes are ...Answered | 9 Replies | 11481 Views | Created by Garyreeds - Monday, October 26, 2009 1:42 AM | Last reply by Garyreeds - Saturday, November 14, 2009 12:12 AM -
0 Votes
RI Across Databases?
In addition, just consider backup and restore. Say you implemented RI (using triggers) and you have to restore a sligthly older version of one of the databases. Not good. If data is ...Answered | 2 Replies | 4139 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
transaction across multiple databases
I have the need to move data from 3 different databases on one server, to the equivalent 3 databases on a different server. After experimenting with starting a ...Answered | 1 Replies | 2545 Views | Created by shiftbit - Wednesday, June 26, 2013 5:56 PM | Last reply by shiftbit - Wednesday, June 26, 2013 6:41 PM -
0 Votes
Joining Tables across Databases
Hi I have to join almost five to six tables across databases. So I have created a different context andAnswered | 2 Replies | 4288 Views | Created by Ambrose Anandraj - Monday, June 16, 2008 11:03 AM | Last reply by Jim Wooley - Monday, June 16, 2008 5:06 PM -
0 Votes
Listing dependencies across databases
We have SQL Server 2005 SP2. I would like to list down all objects across databases that a given stored procedure depends on. sp_depends gives a list of ...Answered | 3 Replies | 6030 Views | Created by Yash Ganthe - Tuesday, January 6, 2009 1:21 PM | Last reply by Dan Cambridge - Thursday, July 26, 2012 9:32 AM -
1 Votes
Script Rebuild/Reoganize indexes of all databases
Hi Experts , I have been doing Rebuild or reorganize of Indexes using the scripts and also using maintenance plan sorting the results in temp ...Answered | 2 Replies | 1682 Views | Created by coolguy123SQL - Tuesday, October 16, 2012 6:59 PM | Last reply by Kalman Toth - Tuesday, October 16, 2012 8:03 PM -
0 Votes
Rebuilding Indexes on Replicated databases
have checked for number of VLF created using DBCCAnswered | 4 Replies | 6631 Views | Created by Sunil Gure - Monday, August 27, 2012 8:50 AM | Last reply by Hilary Cotter - Monday, August 27, 2012 4:57 PM -
1 Votes
Permissioning across three databases
databases are owned by an SQL login with no server-level permission whatsoever. The database must absolutely not be owned by sa. Also, an assumption is that a person who is ...Answered | 6 Replies | 748 Views | Created by lb483 - Tuesday, June 27, 2017 4:14 PM | Last reply by Erland Sommarskog - Tuesday, June 27, 2017 9:42 PM -
0 Votes
Querying data across two databases using Linq
-tips-and-tricks-3 Finally, you can always create two separate dbml files, retrieve the required data and combine results by using LINQ on in-memory ...Answered | 2 Replies | 7950 Views | Created by Grunners - Tuesday, October 5, 2010 10:49 AM | Last reply by Syed Mehroz Alam - Wednesday, October 6, 2010 6:56 AM -
0 Votes
Regarding MCDBA Certification
groups Monitor an instance using such tools as Profiler, Perfmon and DMVs Automate (setup, maintenance, monitoring) across multiple databases and multiple ...Answered | 2 Replies | 1192 Views | Created by Satish Reddy G - Thursday, February 27, 2014 11:25 AM | Last reply by Kalman Toth - Thursday, February 27, 2014 12:26 PM -
0 Votes
SP access across databases
procedure gets access across databases using the certificate rather than elevating the security of the user in the procedure. Only downside is that it won't work with ...Answered | 5 Replies | 3656 Views | Created by Russ Sparks - Monday, July 13, 2009 8:31 PM | Last reply by Russ Sparks - Tuesday, July 14, 2009 9:30 PM -
0 Votes
Sharing reports across multiple databases
reports must be shared across multiple databases. WinForms application will establish db connection and this connection must be passed to SSRS reports on the reports server. ...Answered | 2 Replies | 3978 Views | Created by LevP - Tuesday, December 1, 2009 3:34 PM | Last reply by Prasanna K J - Thursday, December 3, 2009 9:45 AM - Items 1 to 20 of 2273993 Next ›
No announcements
