Viewing 15 posts - 34,006 through 34,020 (of 49,552 total)
Roughly, because there's no table def or sample data that I can use to test...
SELECT Odometer, RPTUTCDATE, UnitNumber, MedicNumber
FROM (
SELECT Odometer,
RPTUTCDATE,
...
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
February 15, 2010 at 11:20 am
Why can you not create an index? Are you getting an error? If so what error?
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
February 15, 2010 at 10:08 am
Foreign keys can sometimes help the optimiser to come up with a better plan. The existence of a foreign key constraint gives the optimiser information about the data and 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
February 15, 2010 at 10:08 am
It's since the last time SQL Server started.
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
February 15, 2010 at 8:20 am
vky3 (2/15/2010)
If You are rebuilding the indexes ,then You need not update the statistics.
Not precisely true. Rebuilding indexes will update the stats associated with those indexes, but there's still the...
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
February 15, 2010 at 8:16 am
5000 rows a day is not many inserts, that's extremely low activity. If the index is needed, create it and test impact (in a dev environment)
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
February 15, 2010 at 8:14 am
For those of us who don't have high speed internet, please just the execution plans and indexes, zipped.
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
February 15, 2010 at 8:11 am
Colin Betteley (2/15/2010)
Understood. But if that server bursts into flames.......
Scripts of logins, jobs, etc.
Bear in mind that the master DB has stuff in it specific to the server it was...
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
February 15, 2010 at 2:32 am
Colin Betteley (2/15/2010)
I was looking to restore Master amd msdb to a server with a different disk structure.
To be quite honest, moving the system DBs from one server to another...
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
February 15, 2010 at 2:19 am
It goes back to an index scan because all the key lookups are more expensive than the scan is. A seek is not always the fastest thing and when you...
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
February 15, 2010 at 1:37 am
Yes
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
February 15, 2010 at 12:31 am
Why are you using index hints? Are you really, 100%, absolutely sure that you know better than the query optimiser what index is best for this query with this set...
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
February 15, 2010 at 12:18 am
http://technet.microsoft.com/en-us/library/dd197454%28WS.10%29.aspx
also
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
February 15, 2010 at 12:14 am
Generally nothing.
Locking is a normal part of DB activity and is essential for ensuring data consistency across the database. There's nothing wrong with locks.
Blocking's also normal. Means that one process...
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
February 15, 2010 at 12:12 am
Please post new questions in a new thread rather than hijacking an existing, active thread. Thanks.
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
February 15, 2010 at 12:07 am
Viewing 15 posts - 34,006 through 34,020 (of 49,552 total)