Viewing 15 posts - 1,366 through 1,380 (of 2,462 total)
No, unless or until you are tracking it with DDL trigger
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 6, 2010 at 4:30 am
Defragmention doesnt work with small tables (1000 data pages).( my guess is your table is small) if dbcc sohwcontig is not working as you expected then it means that it...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 5, 2010 at 9:48 am
Using SSIS would be better
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 2, 2010 at 5:47 am
iqtedar (9/1/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 2, 2010 at 5:44 am
Ramji29 (9/1/2010)
Bhuvnesh (9/1/2010)
Ramji29 (9/1/2010)
Bhuvnesh (9/1/2010)
Twinsoft SME (8/31/2010)
Ordering always helps too...Not always
May be not always but if ordering is done properly then ... in almost all the cases....
Mostly Sql optimizer...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 2, 2010 at 12:10 am
Ramji29 (9/1/2010)
Bhuvnesh (9/1/2010)
Twinsoft SME (8/31/2010)
Ordering always helps too...Not always
May be not always but if ordering is done properly then ... in almost all the cases....
Mostly Sql optimizer do a...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 1, 2010 at 11:29 pm
i would say , remove the explicit transactions from INSERT code , i dont think it is required
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 1, 2010 at 10:29 pm
Twinsoft SME (8/31/2010)
Ordering always helps too...
Not always
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 1, 2010 at 10:14 pm
I also got the same kind of problem in one of my dev server,But no resolution till yet 😀
when do we get high spikes for "disk queue length".NO patch/SP/hardware...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 27, 2010 at 3:52 am
Additionally , you can also use BATCH wise insertion
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 27, 2010 at 2:21 am
insert solely depends on the selectivity of the select command how much data is being matched with the keys( specially clus key) of the destination table.
Post you r insert...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 27, 2010 at 2:17 am
GSquared (8/27/2010)
You'll be issuing Alter Database commands, and calling sp_detach_db. You can do that programmatically through any connection that has the rights.
Thanks But
What if any user or application...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 27, 2010 at 1:36 am
run your sql script/ SP manually on SSMS . Additionally if you see some badly design approach then you can use batch wise insertion/truncation of records.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 26, 2010 at 11:45 pm
Refer these links.it might have what you require
http://www.mssqltips.com/tip.asp?tip=1627
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 26, 2010 at 9:53 pm
TheSQLGuru (8/26/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 26, 2010 at 9:37 am
Viewing 15 posts - 1,366 through 1,380 (of 2,462 total)