Viewing 15 posts - 2,026 through 2,040 (of 2,463 total)
Chan Wai Yin (3/24/2010)
Is there any harmful effect on setting this option or any important concern need to take care?
From any blog :
[font="Verdana"]It is necessary to have AUTO_UPDATE_STATISTICS enabled first...
March 25, 2010 at 2:13 am
If you set the option for AUTO_UPDATE_STATISTICS_ASYNC ON then the query will not wait for the update of the statistics but will execute with the current statistics and at...
March 25, 2010 at 2:09 am
Very valid and good approach you are going to adapt.
but before doing this how come you know that few indexes are not being used ?
Did you see any bottleneck/bad...
March 25, 2010 at 2:00 am
Post this information also
SET STATISTICS IO ON
Your Query
SET STATISTICS IO OFF
March 25, 2010 at 12:57 am
Interview Questions
http://www.techinterviews.com/sql-server-interview-questions
http://www.interviewqsn.com/dababase-interview-questions/sql-server-interview-questions/index.html
http://www.allinterview.com/Interview-Questions/SQL-Server.html
For more google it as i did;-)
March 25, 2010 at 12:50 am
ekknaveen (3/24/2010)
1. <>. > =. LIKE what is the order as per performance
Didnt get this , what you want here ?
2. select * from tab1 where lower(name)='name' is...
March 24, 2010 at 8:28 am
SQLDraggon (3/23/2010)
I told them there is no reason to do that for every column and every table ... but they insist.
in that case you can also ask them why...
March 24, 2010 at 8:23 am
You can refer this link http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/
March 24, 2010 at 7:53 am
SwissDeveloper (3/23/2010)this example should show the problem with auditing entity data.
How ?
March 24, 2010 at 7:47 am
shew (3/23/2010)
Actually, we tried that, but we got an error
post your error
March 24, 2010 at 7:43 am
pablavo (3/24/2010)
I should have added that the main table will be truncated before every import and the new data added to it.
NOw that makes sense that rebuilding indexes with...
March 24, 2010 at 7:38 am
The indexes will help on main table in reportting so rebuilding can be done after importing
but why do you want to rebuild indexes after very import?
And do you...
March 24, 2010 at 6:19 am
srinath.chai (3/17/2010)
I got the similar requirement but I am struggling to complete it
post it it new thread/topic and elaborate your problem
March 23, 2010 at 7:41 am
try now the above links
March 23, 2010 at 7:05 am
Full backups do not truncate the transaction log. Only a log backup truncates inactive log records and makes the space in the log available for reuse. Without transactionlog backups, the...
March 23, 2010 at 6:37 am
Viewing 15 posts - 2,026 through 2,040 (of 2,463 total)