Yes, because SANS are set up in different ways and also have different hardware. Some SANS have 1 disk controller, others have multiples. Also, it depends on how the LUNS...

I think your scenario highlights a very real problem with Full-Text.

The searches are based on words, and variations of words, that SQL "knows." Because you are using proper names,...

You could always use the RIGHT and LEFT functions.

Declare @MyVar char(6);

Set @MyVar = 'abcdef';

Select @MyVar = LEFT(RIGHT(@MyVar,5),4);

Select @MyVar;

UPDATE import_table

SET cost_code=@MyVar;

I agree with everything everyone said so far. I would just like to add that it may be easier for you to draw things out before you start physically designing...

DBA in Unit 7 (7/25/2011)

---

with the SQL 2008 instance: I added the domain group COM\DBA to the sysadmin server role on the SQL 2008 instance, and default database as MASTER;...

If the domains don't trust each other, I don't think any amount of SQL perms verification will help. Check with your domain admin to make sure that A) the domains...

You have to turn the whole statement into a dynamic SQL statement. You can't just assign variables to the various bits of it. Do you know how to do dynamic...

Have you compared execution plans between the regular SELECT and the SELECT...INTO queries?

mtillman-921105 (7/25/2011)

---

Too many of these posters don't realize the level of expertise that they are getting here. Maybe you all need more intimidating titles like "Grand Intergalactic SQL Master"...

halifaxdal (7/25/2011)

---

Brandie Tarvin (7/25/2011)

---

What sort of problems are you having with it? If you post detailed problem descriptions / error messages, we...

What sort of problems are you having with it? If you post detailed problem descriptions / error messages, we might be able...

Movie title. "Despicable Me."

zapouk (7/22/2011)

---

Sorry, haven't got access to my sql code at the moment but the example I've given matches it. The only nullable column is A and it's a one-to-one relationship...

I love chapter 2, The First Programmer was a Lady.

Me