Define "best".

Is this something that needs to be done once? If so, then run the queries for the months and copy and paste the results into Excel and be...

The Berkley DB (which is what Rel is based on) is not relational. It stores data as key-value pairs without relations. Yes, Rel may be "relational", but it's...

Formulating a set of ethical guidelines is a good thing. Yes, common sense needs to dictate basics, like "don't deliberately sabotage your employer because you're annoyed at your boss"....

Union should be avoided if Union All will do what you need, because Union has the additional step of removing duplicate rows. If there are a lot of rows...

I'm not sure if full text can do that. I know it can be done with a Like comparison, but I'm not sure if it can be done with...

Try replacing your inner joins with left outer joins and see if you get what you need that way.

It's not really designed to do that. Best bet is create the backup locally, then copy it.

Jeff Moden (2/4/2009)

---

Colin Lam (2/2/2009)

---

Jeff

How do you go about shrinking the tempdb through the GUI?

We don't know exactly what is causing the tempdb to grow so big, what we do...

Grant Fritchey (2/5/2009)

---

It's possible for the compile time to be outrageous. We had an 80 table JOIN, plus an extensive WHERE clause that took 45 seconds to compile but only...

You're welcome. Let me know if that fixes it for you, or at least puts you on the right track.

Gotta agree with that one. If it's being formatted for human-readability, it's better to do that in the presentation layer, not in the database.

I then also tested another function that was posted here, and killed it after 1 minute.

Inline functions just won't perform as well as a set-based update from a pre-calculated table.

As...

On the speed challenge:

create table dbo.Calendar (

Date datetime not null primary key,

constraint CK_DateOnly check (Date = dateadd(day, datediff(day, 0, Date), 0)),

IsBusinessDay bit not null default(1));

go

insert into dbo.Calendar (Date, IsBusinessDay)

select dateadd(day,...

Log shipping doesn't really apply to tempdb, since it is (by default) in simple recovery mode.

Most things in tempdb give up their disk space as soon as they are done...

Do you have something that defines when they should be in a column together and when they should not?