Viewing 15 posts - 2,026 through 2,040 (of 2,462 total)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 25, 2010 at 2:00 am
Post this information also
SET STATISTICS IO ON
Your Query
SET STATISTICS IO OFF
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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;-)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 24, 2010 at 7:53 am
SwissDeveloper (3/23/2010)this example should show the problem with auditing entity data.
How ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 24, 2010 at 7:47 am
shew (3/23/2010)
Actually, we tried that, but we got an error
post your error
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 23, 2010 at 7:41 am
try now the above links
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 23, 2010 at 6:37 am
And what about USER's mapping ?
How would you do that ?
And also try that whether SQL logins are working well(with transferred encrypted passwords ) ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 23, 2010 at 5:57 am
Viewing 15 posts - 2,026 through 2,040 (of 2,462 total)