Eugene Elutin (5/14/2013)

---

William Gary Wright (5/14/2013)

---

I left the office last night being half way done writing a script to create a database with some data in it for you all...

William Gary Wright (5/14/2013)

---

I left the office last night being half way done writing a script to create a database with some data in it for you all to look...

EdVassie (5/14/2013)

---

It is worth looking at Ola Hallengren's index maintenance routines at http://ola.hallengren.com/.

This checks statistics so that only those indexes that need rebuilding get processed. This can...

Just remember that differential backups do not allow for point in time recovery, they only allow you to recover to that specific point in time that they were taken. ...

Does this give you what you are looking for?

Select

*

from

streets s

inner join streetranges sr

...

Have you read the articles she provided the links to below her answer? Those will...

JC-3113 (5/13/2013)

---

HI Bob

thanks for your input.

here is a followup then

should i be rebuilding my indexes before the full backup then ?

i thought i had read somewhere to do a full...

Eugene Elutin (5/13/2013)

---

michael.higgins (5/13/2013)

---

SELECT DISTINCT o.name, o.type_desc, p.name, p.type_desc

FROM sys.sql_dependencies d

INNER JOIN sys.objects o

ON d.object_id = o.object_id

INNER JOIN sys.objects p

ON d.referenced_major_id =...

Also, could you mock-up some sample data and provide a destination for the data? Could help figure out how to approach the problem.

tshad (5/12/2013)

---

I am not sure what you meant there about visibility.

A CTE only exists for the duration of the query with which is defined. You can't assign a value in...

This doesn't work either:

declare @TestVar int;

select

Mycol1,

@TestVar = MyCol2

from

dbo.MyTable

If you took my comment as to the visibility of the...

Which comes back to what are you trying to accomplish?

What problem are you trying to solve?

No, it can't.

A CTE only exists for the duration of the query with which is defined. You can't assign a value in a CTE to a variable for the...

I am too. Only thing I can come up with is indirect relationships. Makes it...

tshad (5/12/2013)

---

But you are not assigning the local variable from inside the CTE.

I know how to do it outside.

I am not really interested in how to get the monthly list....