Correlation

Technical Article

RE: Select only stand alone statistics to drop

  • Reply

I found the problem!!!!Article Id number 293177.The people who wrote our database program ran a lot of Index Tuning Wizards.  These temporary stats never left and are creating update loops on my server.  Guess how many...over 50!  It's those stats with the hind_% name.I want to thank you two. I have learned much today.

2005-03-02

Technical Article

RE: Any better Ideas that may speed this procedure up?

  • Reply

Try this SELECT T1.Param_ID, T1.Value, MAX(T1.[Date]) as DataDate, T2.DefaultOrder, T2.Order1, T2.Order2, T2.Order3, T3.DataType_ID AS Type FROM dbo.tblValues AS T1 INNER JOIN dbo.tblParam AS T2 ON T2.Param_ID = T1.Param_ID INNER JOIN dbo.tblSetupKey AS T3 ON T3.Key_ID = T1.Key_ID INNER JOIN dbo.tblKey AS T4 ON T4.ID2 = T1.KEY_ID AND ID1 = @ID1 AND ID2 = @ID2 AND […]

You rated this post out of 5. Change rating

2003-12-02

1 reads

Blogs

Enabling an Index: #SQLNewBlogger

By

I don’t do a lot of work with disabled index, but I learned how...

Back to Boston for SQL Saturday

By

I’m leaving again tomorrow for a trip. This time I head back to Boston...

T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?

By

Most of us who work with data have, at least a few times, been...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers