Yea...it seems to be a problem for us....the DB log in question is about 450 GB and with around 12000 vlf files..

Thank you, Gail.

Can you let me know of a SP instead of jobs?.....We use a tool for scheduling the sql server jobs in our environment...so, for security..SP job is...

Seaport, You don't patch specifically for SSMS ...you patch for SQL server and it takes care of the SSMS as well. So, in your case, as Dewayne said, you just...

Dear Seaport, What he meant was...you don't install patch to SSMS...your question itself is wrong.

Thanks for the reply.

Thanks for suggestions arnipetursson..Appreciate it.

Luis, I already tried creating a SSIS package (back & forth) but it threw an error saying versions differ...you can test it if u want.

Hi, Refresh needs to happen everyday..all tables are about 10GB....source instance is sql 2008 R2 and Destination sql instance is SQL 2012

Thanks batgirl, Jack n Luis. Appreciate your responses.

Thanks for the response Jack.

I don't think we can use third party tool on our PROD. Coming to using dmvs....with sys.dm_exec_sessions I was able to get only the current...

Hi,

Thanks everyone who replied. I actually looked at execution plans and compared on dev n Stg and found there were some indexes missing on Stg...created them now..looks okay..but what else...

Thank you all for the inputs...I was able to perform the test using BULK Insert

Ok Thank you. Thing is, I need to use BULK INSERT for some performance tests...so, am thinking I can create a file (text or csv) with all the records of...

Gail/Doug: As I mentioned, am pretty new to sql scripting....and am not sure what FROM 'data_file' in the statement listed. I don't have a file...I need to import rows from...

Thanks for the input doug...but do you think I posted the question without checking/searching this in msdn.microsoft?? 🙂

Thanks for all the replies/suggestions.

Megha: Thanks for the script....so in the script, are you referring ID as identity column...Coz...the table am using doesn't have an identity column...so I need to...