Viewing 15 posts - 36,991 through 37,005 (of 49,566 total)
Also, where are the backups of all these databases?
August 18, 2009 at 6:20 am
It should be possible to attach the files. The 2005 replacement for sp_attach is CREATE DATABASE .... FOR ATTACH
August 18, 2009 at 6:04 am
Silverfox (8/18/2009)
consultants normally work for a consultancy or outsourcing companies 😉
Not necessarily. Especially in the US you'll find a lot of independent consultants. Not as common here though. While I...
August 18, 2009 at 5:47 am
Use a server-side trace rather than profiler, it's a lot less intensive. See the two articles that William mentioned (disclaimer, I wrote them)
August 18, 2009 at 3:56 am
If I may suggest, get a consultant in to help spec hardware and advise you on managing a DB that size. Make sure it's someone with experience on databases that...
August 18, 2009 at 2:25 am
Paul White (8/17/2009)Your posted examples were lists not sub-queries, so I don't really see what you are objecting to?
I posted one list as a quick way to show behaviour. All...
August 18, 2009 at 2:22 am
There's nothing wrong there.
The query is running in parallel, some of the threads finish faster thatn others and have to wait for those slower threads to catch up. This shows...
August 17, 2009 at 3:18 pm
If the CampusID filter is hard-coded and never changes, this filtered index should probably work better.
CREATE UNIQUE INDEX idx_Enrollment_CampusStudent
ON [dbo].[tblEnrollment] ([studentid])
INCLUDE (enrollid)
WHERE [campusid]='212905001'
Edit: After reading again, I...
August 17, 2009 at 3:08 pm
Execution plans please? (see this article on saving and posting - http://www.sqlservercentral.com/articles/SQLServerCentral/66909/)
Why are you doing a LIKE with no wildcard?
Looking at that, the most optimal index I think will be...
August 17, 2009 at 2:17 pm
A database restore will leave the database in exactly the same state that it was when it was backed up. Backup just copies data out bit by bit (or page...
August 17, 2009 at 2:06 pm
Also check the output of STATISTICS IO. SQL prefers query plans with lower IOs. If there's bookmark (key/RID lookups) the IOs may be very high
August 17, 2009 at 2:00 pm
John Burris (8/17/2009)
How do I determine which index is being used?
Look at the execution plan. On the management studio toolbar there's a button 'Include actual execution plan'
and how...
August 17, 2009 at 1:50 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic772119-147-1.aspx
August 17, 2009 at 1:49 pm
Viewing 15 posts - 36,991 through 37,005 (of 49,566 total)