First question, are the backups being done to local resources (DASD or dedicated SAN storage)?

If you can show the code using the TVF and the code for the TVF would be helpful as well as the actual execution plans for both a fast and...

Make it easier for others:

http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/58a1ddf1-90f5-4528-916d-5beb820700dd/

Making it easier for others:

http://www.sqlservercentral.com/articles/JSON/68128/

znetznet (4/23/2013)

---

Trying to get a total of instances of events and assigning it an alias

(SELECT COUNT(id) from Finish f1 where PerfDate = '2013-04-18' and NoEvent = 'yes' )...

You really need to understand the first three normal forms. It is good to have an understanding of the others, but the first three are critical IMHO.

pdanes (4/23/2013)

---

GilaMonster (4/23/2013)

---

pdanes (4/23/2013)

---

So a backup is a 'snapshot' from the moment in time that the backup process was initiated? And operations performed during the backup process do not get...

pdanes (4/23/2013)

---

GilaMonster (4/23/2013)

---

pdanes (4/23/2013)

---

So a backup is a 'snapshot' from the moment in time that the backup process was initiated? And operations performed during the backup process do not get...

edward_hall76 (4/23/2013)

---

Can not figure out what I am doing wrong in table on I have FirstName and PhoneNumber and in the second table I have Carrier with @txt.***.Com etc. So...

timscronin (4/23/2013)

---

Looking at the 2 statements should they not return the same?

select *,'I' from pharmdb.pat.dbo.patients where PHPatid not in (select PHPatid from Patients)

select *,'I' from pharmdb.pat.dbo.patients where not exists (select...

Sol_Web_Solutions (4/22/2013)

---

End goal is >> show month by month breakout of resource costs.

We have resource costs that are displayed via 3 columns:

1. TotalCost

2. Start Date

3. FinishDate

I am...

What was it people kept telling me years ago? Oh yea, run away.

brian.battles (4/22/2013)

---

I asked for some ideas about this last week, but nothing quite suited my situation, which is kinda tricky...maybe if I explain it differently...

I need to run a query...

Ignore the post above this one of yours. I'm pretty sure it wasn't meant for you.

As Sean said earlier. please start your own thread to...

Anyone want to take this post?