Elliott Whitlow (5/23/2012)

---

Oliiii (5/23/2012)

---

Where i work, when you fix something you have to usually show why it was like that, what you did to fix it and why the dude...

This article may help, http://www.sqlservercentral.com/articles/T-SQL/67898/.

jswong05 (5/23/2012)

---

You can find the documentation on SQLServer2008R2 BOL.

This is one of the stupid design.

Imagine old days, you go to library asking for a book for a page you need....

Your query:

select

*

from

T1 TT

where

exists (select

...

ken.willekens (5/23/2012)

---

I have to agree that the safest way to verify a backup is by actually restoring it somewhere. If this is not possible or you are looking for a...

What are the rules for determining the date range in question?

For example:

If @FromDate date is Set date between this range from '2012-05-01' to '2012-05-14'

it should display only data which...

dwain.c (5/23/2012)

---

I was curious how a TVF would compare performance-wise to a SVF for this solution, so I built the following two functions cobbled together from examples provided. Sorry...

Not sure if this will work, but here is a shot:

CREATE FUNCTION dbo.itvfn_UpdatedProcedureLocation

(

@Additional_Procedure as varchar(max),

@Additional_Procedure_Location as varchar(max)

)

RETURNS TABLE WITH SCHEMABINDING

AS RETURN (

SELECT STUFF((SELECT ',' +

...

Gianluca Sartori (5/22/2012)

---

Thanks everyone for the suggestions and opinions.

If everything goes well, I won't be working as a trainer any more.

I'm negotiating a contract as DBA/DBD. It's going to be...

Gianluca Sartori (5/22/2012)

---

Lynn Pettis (5/22/2012)

---

Gianluca Sartori (5/22/2012)

---

L' Eomot Inversé (5/22/2012)

---

Gianluca Sartori (5/22/2012)

---

2 - In every class there's at least one smartass that thinks he knows better than the instructor. So,...

I'm not a SMTP person but it sounds like the SMTP server isn't properly configured to act a relay for DatabaseMail.

Gianluca Sartori (5/22/2012)

---

L' Eomot Inversé (5/22/2012)

---

Gianluca Sartori (5/22/2012)

---

2 - In every class there's at least one smartass that thinks he knows better than the instructor. So, let me ask, why...

ericb1 (5/22/2012)

---

I'm sure this is simple, I'm just missing something here. I have a table of data, and I want to always select the last 13 weeks. That...

Do you know what caused the backups to fail?

Yes. As Gail said earlier, don't even worry about fragmentation until you hit about 1000 pages in the table.