THeSqlGuru(4/26/2010)

---

Number of rows isn't the only issue that can kill you with Table Variables. The actual VALUES can cause issue too, since you can't have statistics on TVs. Thus...

Do you have triggers with it ? if not then go for simple INSERT statement ( better...

Grant Fritchey (4/26/2010)

---

In addition to simply moving the data, you'll need to maintain indexes. Large inserts can result in fragmentation, so you'll probably want to defrag the indexes after the...

this is not a heavy data migration , you can go with either batch appraoch(i posted above) or T-sql. do...

i think you should opt batch process , move data chunk wise ( says 5000 records on every execution ) and you can schedule this process in daily running job...

EXEC master..xp_CMDShell 'XCOPY d:\srvr1\MSSQL.1\MSSQL\Backup \\fs01\Backup\DBA02\srvr1\FINAL2\FULL /d/c/v/y'

i would suggest, rather playing with log/data files, spend some time to understand the log architecture how they grow how they work ; when/why they behave good or bad ?...

thava (4/24/2010)

---

you people are rocking here!

Recently i have some query which pickup the same result set :unsure: :unsure: :unsure:

i want to know which one is the best one and...

you can opt for C2 auditing although it is resource consuming as it's capturing all the database activity hence need to use only when high security is concern.

Some of...

Simple, if you are migratng/creating new databases , better transfer those logins and reset all passwords. 😉

just to see behaviour, i...

How do you get those alerts , sql server jobs ,or any sql tool or any third party...

Jeff Moden (4/24/2010)

---

Bhuvnesh (4/24/2010)

---

Why do you think that it could be view ? because of "Select...

ColdCoffee (4/24/2010)

---

Nice thread, imho!!

Me born in , une fois par le territoire français (once a french territory) PONDICHERRY, in INDIA! 😉

And now working in chennai (again in INDIA) for one...

Why do you want to put it in SIMPLE just for truncating...