I wish I could use RedGate products outside of work, but unfortunately I don't have...

As I said I haven't used MERGE in any practical application so I haven't really read-up on the in's and out's of how it performs. I just assumed given...

Thanks, but I already looked at MERGE, and I don't think it'll work for me, at least not using a single statement. It might...

Technically FLOAT, REAL, MONEY and SMALLMONEY all have different ranges, but my standard is just to convert all numeric values of different types, especially values with currency, to Numeric(17,2), and...

Personally I really want to start working on some certifications, though I say this every year and it never happens :-/ Maybe this year since I've pretty much put...

hughesj23 (12/5/2012)

---

SQL Agent is running, along with all SQL services. I've stopped and restarted them.

My job schedules still are not firing. These jobs have been running fine, and...

Lowell (12/5/2012)

---

samalex (12/5/2012)

---

I found this earlier too, but it appears to be an outdated article since the Download URI goes to http://www.microsoft.com/en-us/download/default.aspx which...

If you've installed these updates recently you may be able to run EXEC Xp_readerrorlog # replacing # with however many historical logs your server retains. For example I just...

If only 30 tables could you write a manual process to sync them using Except? Here's an example:

IF EXISTS (SELECT name FROM sys.objects WHERE name = 'DataA') DROP TABLE...

I found this earlier too, but it appears to be an outdated article since the Download URI goes to http://www.microsoft.com/en-us/download/default.aspx which isn't valid....

Stefan Krzywicki (11/30/2012)

---

jasona.work (11/30/2012)

---

If our devs had used the patient ID value as the identity, it would have been a (10,10) seed. The way the current billing application handles...

Also I just found this which may do the trick - http://sqlwebadmin.codeplex.com/ - plus it appears to be open source, so even better 🙂

Would hosting SSMS on an RDP or Citrix server be an option? Both have web-based clients which could seamlessly share SSMS rather well if you have this infrastructure in...

I always have a Cleanup section at the end of my procedures to remove temp tables and the like, even if they will be disposed of automatically after the procedure...

Hi Grant,

Wow thanks for the reply, I'm a huge fan of your site and enjoyed your talks at SQL In The City in Austin earlier this year. Also which...