Viewing 15 posts - 36,976 through 36,990 (of 49,552 total)
russ (8/18/2009)
3)...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 18, 2009 at 12:16 pm
Also, where are the backups of all these databases?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 18, 2009 at 6:04 am
Check the script library here.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 18, 2009 at 5:55 am
Dup post
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 18, 2009 at 5:55 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 17, 2009 at 1:50 pm
Viewing 15 posts - 36,976 through 36,990 (of 49,552 total)