Viewing 15 posts - 406 through 420 (of 2,462 total)
i will suggest to keep the TRIP_STATS table separate from main table TRIPS ans TRIP_DETAILS
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 24, 2013 at 11:12 pm
purushottam2 (1/24/2013)
So i want convert it from temp table to CTE, will it improve my performance ?
there is NO guarantee that performance will improve, CTE is basically used...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 24, 2013 at 11:07 pm
check with sp_who2 , which spid is locking that table
then for all fetched do dbcc inputbuffer(sp_id), see what kind of transaction is there
then decide which spid you can...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 24, 2013 at 4:19 am
just came to know that this is duplicate post.
it wastes poeple time , dont cross post.
original post http://www.sqlservercentral.com/Forums/Topic1411020-391-1.aspx#bm1411043
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 24, 2013 at 4:18 am
check with sp_who2 , which spid is locking that table
then for all fetched do dbcc inputbuffer(sp_id), see what kind of transaction is there
then decide which spid...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 24, 2013 at 4:17 am
Since there is no complete table definition will be not accurate suggestion from us.plus no idea either you have clustered index on tables or not ?
anyways
Order table will...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 24, 2013 at 3:59 am
Zeal-DBA (1/24/2013)
thanks for reply, how a DDL trigger will work on it can please elaborate?
see this http://www.mssqltips.com/sqlservertip/2085/sql-server-ddl-triggers-to-track-all-database-changes/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 24, 2013 at 2:53 am
DDL trigger , extended event , profiler trace. etc.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 24, 2013 at 2:36 am
subbareddy542 (1/24/2013)
adv of nolock it is removing dead lock.for live data nolock option don't use.
if you normailly not live data that time nolock will more useful.
this is...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 24, 2013 at 2:34 am
Yes
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 24, 2013 at 1:30 am
nishantshende-532951 (1/24/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 24, 2013 at 1:27 am
thbaig1 (1/23/2013)
e.g. Prod1 with ProductId 1 removed from tblProduct, can I DELETE ONly...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 24, 2013 at 1:00 am
Koen Verbeeck (1/24/2013)
Do not disable foreign keys
Any other reference ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 24, 2013 at 12:56 am
do FK are with "on cascade delete" option ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 24, 2013 at 12:35 am
still you havent posted what all i asked
anyways
i will suggest you to take batch approach for "Deletion" . and i dont think "periodic statistics updation will help you...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 24, 2013 at 12:34 am
Viewing 15 posts - 406 through 420 (of 2,462 total)