Viewing 15 posts - 39,916 through 39,930 (of 49,571 total)
Ken Simmons (4/7/2009)
You would have to clear it for each plan handle that had the table name in the plan.
That feature was only added in SQL 2008. In SQL 2005,...
April 7, 2009 at 3:45 pm
run sp_recompile and pass it the table name as a parameter. This will mark all plans based on that table as invalid and force them to recompile the next time...
April 7, 2009 at 3:42 pm
rodney.williams (4/7/2009)
Cancel that. It did work. Thanks again.
Pleasure
How do I give you points.
You don't. Points on this forum are given 1 for each post that a person...
April 7, 2009 at 1:25 pm
rodney.williams (4/7/2009)
and despite the fact that someone called my code B.R.A.B, or B.A.B.S, or B.U.R.P
RBAR = Row by agonising row. The point being that SQL is a set-based language...
April 7, 2009 at 1:22 pm
rodney.williams (4/7/2009)
I did receive the 1 row(s) was affected message.
That wouldn't have been from the trigger. Because NOCOUNT is on, it won't return the n rows affected message.
1)...
April 7, 2009 at 12:15 pm
Michael Valentine Jones (4/7/2009)
April 7, 2009 at 11:58 am
Well, multiple redundant indexes give you no additional read benefit over having just one index, however when the data is changed all of those indexes have to be updated.
April 7, 2009 at 11:38 am
Sometime between 7am and 8am there's a job running that either switches the DB to simple recovery and back to full or executes a BACKUP LOG ... WITH TRUNCATE ONLY.
My...
April 7, 2009 at 11:22 am
Jeff Moden (4/7/2009)
I sometimes have a similar problem with age... most young folks look at my white beard and chuckle about what Santa Clause might know about databases.
Similar...
April 7, 2009 at 11:19 am
It's multiple choice, but some of the questions are so long that they're almost case studies by themselves.
April 7, 2009 at 9:34 am
You do need to be familiar with the new 2008 features. Whether Transcender's good enough, I can't say. Never seen their test exam.
Check the requirements list on the MS website...
April 7, 2009 at 9:23 am
Here you go. This will work no matter whether you update one row or one thousand rows.
I don't know how well unpivot works on larger row sets, but it...
April 7, 2009 at 9:14 am
It has to be done by an admin. Use the Report button and request that the thread be moved.
April 7, 2009 at 8:55 am
So you do need a join between users and usersubscriptions, which you did not have in your initial query and which my rewritten one did.
Still, you know the data, you...
April 7, 2009 at 8:27 am
Viewing 15 posts - 39,916 through 39,930 (of 49,571 total)