Adi Cohn-120898 (11/22/2011)

---

The log backup logged the alter database statement and also modifications to the system’s metadata tables that reflect the database’s modification. It didn't have to copy/backup the...

Thanks for the awesome testing! Seems that the rownumber solution is a fair bit quicker than the tally table solution for larger numbers where the missing value is high...

Phil Parkin (11/15/2011)

---

Script component is what you mean, I think.

Well done on taking the time to find a solution to your problem.

I still have concerns over the potential performance...

Get a copy of SQL Virtual Restore from Red Gate. Based on the incredible Hyperbac technology you can mount READ/WRITE compressed backup files as databases!! Just amazing what...

Can someone please do a test where there are 1M rows (or 10M or more) and the MIN missing value is one from the highest number in the range (i.e....

And does it very nicely too - and it can generate sync scripts too, among other things.

SQL Kiwi (11/14/2011)

---

TheSQLGuru (11/14/2011)

---

Sorry Paul - I don't think your solution is applicable to the OPs situation. Your scenario is for ONE number that gets updated. OP has...

SQL Kiwi (11/6/2011)

---

We've always been able to do it safely and...

1) I am not sure SSIS is the way to go here. I am about 90% certain (given nebulous descriptions of problem and no sample data with expected outputs)...

http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

Note there are 2 additional parts to this blog series.

Very STRONG agreement here Gail! Anything that is marked as "huge emergency" OR...

Dev (11/9/2011)

---

Actually I don’t want it to happen that I get an opportunity to talk or have lunch with an MVP & I couldn’t recognize him / her....

Gangadhara MS (11/9/2011)

---

Dear Experts,

We are migrating the Production database from one SQL server 2005 to shared SQL server 2008 environment by backing up and restoring technique.

For this purpose i...

Your issue may have been resolved but there is something that no one has pointed out yet. Do NOT do this, as it is work for no purpose:

--Inserting into...

PaulB-TheOneAndOnly (11/8/2011)

---

TheSQLGuru (10/3/2011)

---

Partitioning is an ADVANCED feature and you will very likely get yourself into unfortunate situations/scenarios if you ask for a few pointers on a forum, read a blog...