That's a job for SQL Server Integration Services, SSIS. You can do a search for SSIS & Interbase to find lots of information on how to integrate between the two....

You can only do that if you have the tail log backup of that time. Based on what you said, you don't. So you can only restore to the last...

Continuing my role as the harbinger of death, Ziggy Stardust is no more.

One of my favorite songs. Although Bauhaus actually did it better.

Eirikur Eiriksson (1/10/2016)

---

Grant, the link to your article doesn't...

Here's an article by Kathi Kellenberger[/url]. Here's one I wrote[/url]. Either or both should satisfy exactly what you're looking for.

Steve Jones - SSC Editor (1/8/2016)

---

BTW, apparently the quality of my writing has also gone down. Got this lovely note today

Your article today compels me to seek your “Unsubscribe”...

I'm with Kevin, this is probably a very involved situation.

However, to at least get you started, I'd look at sys.dm_os_wait_stats to understand what is causing the system to run slow....

Yeah, I too thought the keys were stored at the leaf level. I'm positive Gail knows that. It must be a misstatement or misinterpretation of what she said.

That's not something I've seen, so I don't have an explanation for it. Have you patched your SSMS installation? Assuming SSMS is running locally, even if you've regularly patched the...

I'm with Hugo and Lowell. I'll just offer an alternative to using Ola's scripts (nothing wrong with them, I just like choices). You could check out MinionWare[/url]. They have a...

You can absolutely do it on your own. Performance Monitor, perfmon.exe, is the first thing to start with. You can capture system and SQL Server specific metrics from that. Next...

I can also strongly support using Minion Reindex. It's free from MinionWare[/url]. It does an excellent job of managing indexes & statistics.

Roughly the same execution plans really translates as, different execution plans. As Gail says, look to the row estimates to understand where the differences are coming from.

It really depends on what you're doing with that data. If you're doing any kind of filtering or joining against it, then the table variable structure that the table valued...

In addition to what's already mentioned, I'll add Itzik Ben Gan's book, Inside T-SQL Querying.

Additionally, because taking multiple approaches to learning is always best, I'd suggest tracking down your local...