Hang on!! How can I get in on this and sell tickets?? I'll even give 75% of the proceeds to SSC!

Just for S & G's, I added another select statement to my test code. In it you will see that I use a case in the join. If...

Jeff Moden (11/14/2008)

---

Also, I never suggested making a Tally table on the fly... a permanent Tally table is really the way to go, in most cases. Exception to that...

Jeff,

Just gotta know, has anyone every called you an anti-rbar fanatic? This seems to be the main area you really become "excited" about. And NOT that it is...

I find separating the join criteria from the filter criteria makes working with multiple table queries easier. Also, I would rewrite your current query using a CTE to replace...

Mani (11/14/2008)

---

hi,

Iam using the below procedure to Backup system Databases. It is taking the backups of master,model msdb in all instances except one instance it is not taking msdb backup?...

I'd say by looking at what types of queries are being run against the database. You can als look at the missing index data management views and see what...

What is the error??

kent.kester (11/14/2008)

---

I need some advice. I'll lay out my current backup plan (that I inherited) then what I'm wanting to move to.

Currently:

*Full Backups Daily at 6AM: ...

This code handles the values provided by Seth.

DECLARE @test-2 TABLE

(ID INT, TXT VARCHAR (MAX))

INSERT INTO @test-2

SELECT 1,'A'

UNION ALL

SELECT 2,'A'

UNION ALL

SELECT 2,'B'

UNION ALL

SELECT 3,'A'

UNION ALL

SELECT 3,'B'

UNION ALL

SELECT 3,'C'

UNION ALL

SELECT 4,'This...

I wouldn't use a case statement either. Here is what i would do (and some of this you should have done, ie the create table and insert statements)

create table...

That may be a good primary key, but remember that doesn't mean it should necessarily be the clustered index.

timscronin (11/13/2008)

---

is it possible to do a case statement in a join. I have an order table which needs to join to a location table. It can join...

homebrew01 (11/14/2008)

---

I'm trying to restore a large DB temporarily to retrieve a table, in a less than ideal situation, but it's my only option right now. The database is 700...

Just one thing to think about. The Primary Key isn't always the one that should be the Clustered Index. As you look at the processing that occurs, you...