Viewing 15 posts - 1,036 through 1,050 (of 2,008 total)
GilaMonster (12/7/2011)
Dev (12/7/2011)
Yes. But it will recompile only if number of rows cross Recompilation Threshold else NO.
And tell me, what are the recompilation thresholds for a temporary table?...
December 7, 2011 at 6:52 am
GilaMonster (12/7/2011)
Dev (12/7/2011)
Optimizer can create statistics on columns. Uses actual row count for generation execution plan.
Estimated row count, not actual. The optimiser doesn't go off and count the...
December 7, 2011 at 6:51 am
Ninja's_RGR'us (12/7/2011)
Did you read the article???
Yes. But it will recompile only if number of rows cross Recompilation Threshold else NO.
December 7, 2011 at 6:48 am
Ninja's_RGR'us (12/7/2011)
Dev (12/7/2011)
The only point of argument is the table is toooooo small i.e. 2 rows. I am not...
December 7, 2011 at 6:43 am
@Gail, @Remi & @Grant: All Agree on what you said.
The only point of argument is the table is toooooo small i.e. 2 rows. I am not a victim of myth...
December 7, 2011 at 6:32 am
Ninja's_RGR'us (12/7/2011)
Dev (12/7/2011)
Ninja's_RGR'us (12/7/2011)
Dev (12/7/2011)
Ninja's_RGR'us (12/7/2011)
WHERE Items.ItemCategoryCode IN (SELECT CategoryCode FROM @Cats)Convert to #tbl with PK to help the stats, search and replace to find the...
December 7, 2011 at 6:14 am
Ninja's_RGR'us (12/7/2011)
Dev (12/7/2011)
Ninja's_RGR'us (12/7/2011)
WHERE Items.ItemCategoryCode IN (SELECT CategoryCode FROM @Cats)Convert to #tbl with PK to help the stats, search and replace to find the 5-10 occurances and boom,...
December 7, 2011 at 6:03 am
ashkan siroos (12/7/2011)
Dear Dev,As you said it is Windows XP service, not sqlserver2005 job running on windows server 2008.
I'm shocked!
It's also there in W2K8... See below (not related to your...
December 7, 2011 at 6:00 am
Ninja's_RGR'us (12/7/2011)
WHERE Items.ItemCategoryCode IN (SELECT CategoryCode FROM @Cats)Convert to #tbl with PK to help the stats, search and replace to find the 5-10 occurances and boom, 98% reads improvements ;-)....
December 7, 2011 at 5:56 am
That's not stupid... :w00t:
A description of Svchost.exe in Windows XP Professional Edition
December 7, 2011 at 5:50 am
pallavi.unde (12/7/2011)
On the File menu, click New Trace, and connect to an instance of SQL Server.
in my MSSQL there...
December 7, 2011 at 4:47 am
I believe some application (third party / owned) is trying to insert this HTML.
I am not trying to help on your requirements here but I am trying to give you...
December 7, 2011 at 4:42 am
Perry Whittle (12/7/2011)
please accept my apologies 😉
On a side note the other thing that will commonly interrupt the log shipping is a manual transaction log backup that is not...
December 7, 2011 at 4:11 am
Bouben (12/7/2011)
December 7, 2011 at 4:09 am
sun37 (12/7/2011)
then the attribute isCountry (country_code, country_name)
Army (army_code, army_name, country_code)
Solders (name, ID, rank, country_code)
Don't you need to connect Army with Soldiers? Think on it... No hurry 🙂
Each...
December 7, 2011 at 3:51 am
Viewing 15 posts - 1,036 through 1,050 (of 2,008 total)