Viewing 15 posts - 27,301 through 27,315 (of 49,552 total)
Showcontig has nothing to do with index tuning. Index maintenance, yes, but not index tuning.
Tuning refers to creating and altering indexes to support the workload. Maintenance is rebuilding as necessary...
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
March 17, 2011 at 3:17 pm
SQL sure thinks it's replicated. If you are 100% sure it's not, try the following.
Create a transactional replication publication.
Publish a single table (a small one)
Stop the log reader
Run sp_repldone 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
March 17, 2011 at 11:40 am
Ninja's_RGR'us (3/17/2011)
simonjday (3/17/2011)
HiSql 2005 Ent Edition 32 bit latest SP
Normal Views
What's the point of creating normal views to tune the db????
DTA shouldn't create normal views. IT can create indexed views,...
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
March 17, 2011 at 11:29 am
Normal views won't appear in any of the index-related DMVs as they are just saved select statements. If they are normal views and the app has not been changed to...
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
March 17, 2011 at 11:22 am
There isn't a reliable, persistent one. You can query the index_usage DMVs, but that's only since the last database start.
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
March 17, 2011 at 11:17 am
Don't know about the noob part, but http://www.sqlservercentral.com/articles/books/65831
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
March 17, 2011 at 11:16 am
Normal views or indexed views? What edition of SQL?
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
March 17, 2011 at 11:15 am
Never heard of such a thing. What's the context?
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
March 17, 2011 at 11:14 am
Did you read the portion of that article that covered the replication wait?
No such thing as a 'dirty' vlf. SQL thinks it has replication in place, hence the log...
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
March 17, 2011 at 8:47 am
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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
March 17, 2011 at 8:15 am
Triggers in SQL are either Instead Of (replacing the statement) or After.
Why do you feel you need a before trigger? From what you have there, there should be no difference...
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
March 17, 2011 at 8:12 am
Order by is only permitted in the outer-most select statement unless there is a TOP. Order by on a subquery is only honoured if there is a row-limiting TOP (not...
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
March 17, 2011 at 6:20 am
Can't be done. If you put a database on a client's server, they have full and complete control over 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
March 17, 2011 at 6:18 am
Recovery model is only one of the reasons why a log might grow. See http://www.sqlservercentral.com/articles/Transaction+Log/72488/
I'll echo Grant. Do not shrink the log regularly. Only after some abnormal operation has resulted...
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
March 17, 2011 at 6:17 am
annasql (3/16/2011)
I still see there is a transaction log very big for one of the database.I would like to do a shrink log file.
Why?
Did the log grow abnormally large due...
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
March 17, 2011 at 6:05 am
Viewing 15 posts - 27,301 through 27,315 (of 49,552 total)