"Too many joins" is when either (a) it gets the wrong results, (b) you're pulling data you don't actually need and it impacts performance.

I have a query that uses 18...

There are books on the subject that will get you off to a very good start. Check out the Books section on this site. Also check Red Gate's...

Makes sense. In that case, yeah, your process should be fine. Test it on a dev/test copy of the database, make sure it does exactly what you want,...

If someone were to mine SSC for this kind of thing, I'm going to guess that would determine that a fair number of people are experts on Star Wars. ...

I've usually found two things are more than adequate to tell me exactly what's slowing things down. The Activity Monitor in Management Studio, and a server-side trace on all...

If you're outputing the XML (query result) to "Results to text", there's a 255-character default limit to that. Doesn't change what SQL Server is doing in the background, but...

george sibbald (5/1/2009)

---

GSquared (5/1/2009)

---

I think I'd go with something at the beginning of the loop in the proc that checks the log and backs it up as needed.

That way, you...

Hate to be contrarian here .... nah, honestly, I enjoy being contrarian .... but I like Excel. It's useful and gets the job done.

If there's anything to hate on...

RBarryYoung (5/1/2009)

---

Luke L (5/1/2009)

---

I never knew about it until today when the question was asked. I started playing around with the thread navigation buttons and I found it. ...

I use Select, because I often assign multiple at the same time, and I don't like having one practice for that and another for something else. Just makes it...

Since I haven't tried that, I really can't say one way or the other.

If I were you, I'd set up a test environment and try it out.

Not sure if that can be done with a constraint. Pretty easy to do with a trigger.

I just ran this:

create table #Region (

ID int identity primary key,

Code varchar(10),

Title varchar(20));

insert into #Region (Code, Title)

select left(newid(), 10), left(newid(), 20)

from dbo.Numbers

where Number between 1 and 100;

select 'Region' as Type,...

Check out the "Alter Database" command in Books Online. You can set a database to single-user, restricted, or multiple user.

I think I'd go with something at the beginning of the loop in the proc that checks the log and backs it up as needed.

That way, you don't have the...