why would they use nvarchar?

if you are putting dates into a character column (not that you should) for whatever reason then why use nvarchar surely no dates...

dont waste time dropping indexes to save space on the copy, as you will need the space again when you recreate them.

The simple way to move a database is to...

to be honest this sounds like an 'ambulance at the bottom of the cliff' solution , you should look at finding...

why do your clients need to keep restarting SQL server?

what are the two values causing errors?

usually when i have this issues , dropping and re-creating the view seems to solve it.

unless the CTE is manipulating the column in some way it should have the same...

using the task in SSIS is slow and causes row-by-row operations to happen, also changes are difficult to implement. The one advantage is that it is easy to setup.

using t-sql...

but without the t-log backups you will lose a days worth of data if there is a disaster. since you do not have the ability to do PIT restores.

I think it was the advice that deletes were not logged in simple mode which is a major mis-assumption about simple mode, that caused the most concern..

in the connection manager at the bottom of the screen, click on your file connection and then check the box 'column names in the first data row'

you should never use them, unless you really really really know what you are doing and have exhausted every other possible method of tuning.

Thomas Abraham (6/30/2011)

---

Best idea so far! DBA's...

Nakul Vachhrajani (6/30/2011)

---

A new table may not be feasible in all cases. If you have triggers deployed by interfacing applications, then dropping and recreating the table will loose these triggers.

A...

depending on how much data you are deleting vs keeping, it can be quicker to make a new copy of the table and copy over the data that you...

have you accidently changed the extension to .txt ? so even bids thinks its a txt file.

maybe you have something like reportname.rdl.txt

turn on the...