Viewing 15 posts - 2,041 through 2,055 (of 2,462 total)
You can do the insertion in batches like 10000 rows in every insert/execution
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 23, 2010 at 5:52 am
1. once the session is rolled back compeltely does the log released by itself or do i have to truncate it or how does check poiint work to clear the...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 23, 2010 at 5:50 am
Which method did you use for it ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 23, 2010 at 4:38 am
Tara-1044200 (3/22/2010)
I am doing a heavy dataload on a database which is running from 18hrs
can you post the query/script you are using to insert data ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 23, 2010 at 4:36 am
you can try below link but i am not quite sure that it can give you required help
http://blogs.solidq.com/EN/rdyess/Lists/Posts/Post.aspx?ID=16
http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/e5c0af6e-763e-460b-818b-0e9df6572f12
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 23, 2010 at 4:32 am
conor.devlin (3/19/2010)
I would like a copy of the .bak file ftp'd to a reporting server and then restored there nightly.
i guess you can use database mirroring to accomplish this...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 23, 2010 at 3:59 am
Kingston Dhasian (3/22/2010)
But i have spoken to thousands of U.S citizens without going out of India even once. Guess how???
Clients interaction 🙂 ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 23, 2010 at 12:14 am
i think NY has many places whose names are taken from cities of INDIA like Chandni chawk
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 22, 2010 at 11:22 pm
Kingston Dhasian (3/22/2010)
WHEREDAY( DATEADD( DAY, 1, dt ) ) != 1 i am agree with dhasian but if we talk about heavy/large table definitely above code would kill seek operation.By...-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 22, 2010 at 7:24 am
Hey I am from Delhi ( India); Southern part of ASIA.Delhi is the place where COMMON WEALTH GAMES 2010 will be heldin October 2010.
Very happening city.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 22, 2010 at 6:06 am
First of all read this post http://www.sql-server-performance.com/tips/stored_procedures_p1.aspx
Additionally read the execution plan, what are the hot spot areas. you can post exec plan along with table and index defintion here ,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 22, 2010 at 3:54 am
calyansubscriptions-592368 (3/22/2010)
Is there any way to get this thing using T-SQL Programming
Try this but before that test it somewhere, its working on my side./**************************************Script to generate all the Jobs...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 22, 2010 at 3:26 am
Written by Paul White NZ for not dropping indexes
As far as the wider point is concerned, don't be too keen to drop apparently under-used indexes. Be absolutely sure you know...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 22, 2010 at 3:10 am
How did you resolve it ? Did you drop indexes ? i dont think you did that
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 21, 2010 at 11:16 pm
and dont forget to set SET @@ROWCOUNT 0 after deletion
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 19, 2010 at 9:14 am
Viewing 15 posts - 2,041 through 2,055 (of 2,462 total)