Viewing 15 posts - 32,446 through 32,460 (of 49,552 total)
Please post new questions in a new 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
June 14, 2010 at 11:35 pm
Drop/create?
Create index ... with drop existing?
Alter index ... disable/rebuild?
What's the point? What are you trying to achieve?
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
June 14, 2010 at 11:35 pm
touchmeknot (6/14/2010)
Well, I have to shrink the files since there were huge number of inserts and deletes performed.
Why? SQL will reuse the space. Only shrink if the free space will...
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
June 14, 2010 at 11:34 pm
Not surprised in the slightest, that's exactly what I expected.
For reasons that have to do with the way the first few pages are allocated, there's virtually no point in rebuilding...
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
June 14, 2010 at 3:03 pm
Try this index to start:
SalesFact (h_IsActive) INCLUDE (sk_SalesFact,sk_BroadcastDate,sk_SpotScheduledStartTime,sk_SpotActualStartTime,sk_SpotStatus)
Date
You seem to have a cross join between the timepart table and date dimension. There's 20090 rows in the date dimension, after 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
June 14, 2010 at 3:01 pm
How big is the index in question? How many pages?
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
June 14, 2010 at 2:50 pm
It's generally not a good idea to rebuild all indexes on all tables on anything other than a tiny database. The log impact and the time required just become too...
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
June 14, 2010 at 2:41 pm
Temp tables are specific to a connection. One session cannot affect a temp table created by another session.
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
June 14, 2010 at 1:54 pm
Glad to hear it.
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
June 14, 2010 at 1:49 pm
doobya (6/14/2010)
was designed for old fashioned applications
that opened and held long lived connections and locks
they *had* to use high resolution locks or they...
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
June 14, 2010 at 1:48 pm
Shrinkdatabase shrinks all the files in the database, shrinkfile shrinks only the specified file.
Why do you want to shrink anyway? Databases tend to grow as more data gets put in...
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
June 14, 2010 at 12:13 pm
No, no, no, no! You misunderstand. The log reader MUST be running or the log space cannot be reused. Stop it and you'll be making things worse, not better.
If 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
June 14, 2010 at 12:04 pm
Ok, from the distributed and non-distributed this is clearly the publisher for some transactional replication. Check that the log reader is running.
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
June 14, 2010 at 10:57 am
Subscriber? Not publisher?
Can you post the output of the following please?
DBCC OPENTRAN
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
June 14, 2010 at 9:50 am
Forcing exclusive table locks may (and I say may) result in lower latency, but it's going to really suck for concurrency. There's a reason that, in general, you want 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
June 14, 2010 at 9:47 am
Viewing 15 posts - 32,446 through 32,460 (of 49,552 total)