If you want to be able to ignore the file group backup in your backup chain - look at running that backup with COPY_ONLY.

When you reference a column in one of the unpreserved tables of an outer join, that join will in effect be turned into an inner join.

Example:

SELECT [columns]

FROM table1...

pete.trudell (8/20/2008)

---

I appreciate your information, however I don't understand any of it. What is CTE? That is why I came in under Novice as I have never used...

Jeff Moden (8/19/2008)Yeap... 'bout six weeks ago if I recall correctly... the only thing missing for me was doing those bloody dual Pivots...

Do you happen to have the...

ruben ruvalcaba (8/19/2008)

---

Great Article! pivots are great because it exposes the same information in many ways very usefull ....

In your sample you build a pivot when you already now...

pete.trudell (8/19/2008)

---

Sorry, nine year of Access, 3 mos. of SQL.

Here's my most recent attempt to create a computer column from several computed columns.

EMonth = DATEPART(m,dbo.employee.LGD)

EDay=DATEPART(d,dbo.employee.LGD)

These work...

So, if the time is a datetime - is it the actual datetime? In other words, is the time column something like: 1900-01-01 hh:mm:ss.xxx. Or is it the...

I missed one piece of this:

declare @start datetime, @end datetime

set @start = '01/01/2007'

set @end = '08/14/2008'

/* the above is defined in the procedure */

declare @start_year_month int, @end_year_month int;

set @start_year_month...

Hey Jeff, good article - reminds me of a fairly recent discussion we had on this forum 😀

Nice to see that you put what we learned in that discussion into...

I am doing very well - thanks for asking.

So, to summarize this issue - we found that WMI was having problems and this caused the service pack to not be...

Just to confirm - you reviewed the view with the unions and used only what you actually needed in the stored procedure? Just curious what approach you used to...

Changing the memory settings does not require a restart. Just make sure you do not set the min server memory equal to the max (I recommend at least 1GB...

You might be running up against parameter sniffing, but I think you can get around that by changing you query to:

declare @start datetime, @end datetime

set @start = '01/01/2007'

set @end =...

If the job is not scheduled, then either of the following has happened.

1) Someone removed the schedule in the maintenance plan

a) Open the...

I would recommend reviewing the view that...