It really depends on how your inserts are being called. Are different stored procedures inserting the same data? Are your getdate() sometimes being stored in a temp table before...

I wouldn't worry about the identity column causing "overhead." I think that is the best way to accomplish what you are looking for. That being said... It is possible for...

Personally, I would add a column to the original table denoting the shift. Make it an INT NOT NULL. Maybe even make it a calculated column based on...

I'm not sure that this is exactly what you are looking for... but sp_spaceused may be your best bet.

Thanks,

Jared

I think this is a trick question 🙂 FILLFACTOR specifies a percentage that indicates how much the Database Engine should fill each index page during index creation or rebuild. Therefore,...

Right-click on Computer and go to properties. Scroll down to ythe secion with the computer name and such. Is the Domain name correct? Just a double-check 🙂

Thanks,

Jared

Dev @ +91 973 913 6683 (10/17/2011)

---

It's my checklist. Please feel free to add your points.

•Create a FULL backup of database.

•Create scripts for relevant Jobs, Logins etc

•Take database offline, for...

Try making sure that your alphanumeric is in the first row. When importing the excel file, it only scans so many rows before determining what the data type and length...

Dev @ +91 973 913 6683 (10/17/2011)

---

I would recommend you to consult with your System Administrators / IT Dept and verify UPLOAD (write)/ DOWNLOAD (read) quota on network.

Try it with...

Sounds like a potential domain issue with your machine. I have seen this happen when people do not shutdown their machine from their home network, and then connect directly to...

Also, are the connections between the instances in all of your scenarios EXACTLY the same? Your network connections could be the issue, even in the same room if they are...

Do you have compression enabled on the SQL 2008 instance? Writing to another server with compression could be what is slowing this down...

Thanks,

Jared

Roust_m (10/16/2011)

---

I don't want to backup them, so to avoid any performance impact, so I want to script them out and in case of any failure restore the databases from...

You must make sure it is DATA compare. They also have one that is just COMPARE which does schemas. IF you have the DATA compare, it only compares and...

Have you tried pasting "All using source theme" or "Keep Source Formatting" (depending on where you paste from)?

Thanks,

Jared