Viewing 15 posts - 1,276 through 1,290 (of 2,463 total)
post table and index definition along with exec plan.See only the query cant give good/appropriate hint/suggestion
September 23, 2010 at 3:48 am
i am also interested in table/index definition
September 23, 2010 at 3:47 am
vwilliams (9/22/2010)
Can anyone see what is wrong with this statement?
what kind of error you are getting ?
September 23, 2010 at 3:38 am
grkanth81 (9/23/2010)
I am using SQL SERVER 2005.
I havent used any trigger till now in my job. So I am facing a slight problem in understanding and writing the code.....
I...
September 23, 2010 at 3:35 am
patrick.blais (9/22/2010)
I am frequently taking a backup of production database (on a production Domain) and restore them on a DEV sql server (on a DEV domain).
you can also go...
September 23, 2010 at 2:01 am
Study the execution plan before and after the index ( suggested by gail) and see what got improved ?
September 23, 2010 at 1:54 am
GilaMonster (9/22/2010)
Stats shouldn't generate that much log data (unless you have millions of them). Index rebuilds will.
informative
September 23, 2010 at 1:50 am
Exec plan shows index scan and key lookup on BusinessData.
so create non clus index on BusinessData
(
[NAICS Code],
[Business name],
CityState)
But one concern , bdf.* in select , Do you really need...
September 22, 2010 at 11:25 pm
abcim (9/22/2010)
It takes 40 Seconds.But when I remove, and ind.industryname like 'Franchising%',
It takes 0.01 Seconds.
Because the column IndustryName doesnt have any index , create an index on this column,...
September 22, 2010 at 11:08 pm
Jack Corbett (9/22/2010)
Foreign Keys are not indexes
but i think, by default it gives non-clustered index.
September 22, 2010 at 10:04 pm
iqtedar (9/22/2010)
recycling ONLY the dbmail worked..thnaks
Recycling .how ?
September 22, 2010 at 9:45 pm
Thanks grant, can you brief about the execution plan difference between these two. can we have the different plan for a view and query ( included into the view )...
September 22, 2010 at 6:42 am
first of all JOIN sequence
in fast : persexprByquarter table with employeeHistory ( 4502 records) and then EmployeeGroups table
in Slow : employeeHistory with EmployeeGroups (9048 records)...
September 22, 2010 at 3:22 am
Did anybody unmark the "database mail" option from sql server configuration area ?
September 22, 2010 at 1:46 am
Tara-1044200 (9/21/2010)
the execution plans are choosen differently.
No , view has same exec plan as it has for inner incorporated query.sql optmizer treats both view and query same while analyzing the...
September 22, 2010 at 1:38 am
Viewing 15 posts - 1,276 through 1,290 (of 2,463 total)