Mark Gerschutz (7/24/2008)

---

I too have been involved with servers that we P2V'd (Physical to Virtual) them. The issue we would run into is the drivers from the physical machine...

This is an interesting topic I can talk to from personal experience. I'll start by saying, make sure you do it right in the first place. If the underlying infrastructure...

rbarryyoung (7/23/2008)

---

Well I don't have enough details to do anything exact, but assuming that they are only using 5 digits in that Varchar(12) field, then something like this ought to...

I caught that as well after posting. I'll have to let the person who sets up the tables...

ETL may be the best and only scenario but thinking of a particular table we have in our environment, I'm not sure that there would be any justification to disable...

Ray Laubert (7/17/2008)

---

I also wanted to point out that in this article, you start with a statement that you like to do everything yourself, then a few paragraphs later state...

Legal requirements for data storage and deletion certainly need to be considered first when looking at a potential solution. After legalities, we need to look at the business rules.

My former...

The documentation linked does not have an ALT+F1 combination listed. However, after trying it out as the feedback suggests, I can get it to work. What is the correct documentation...

D-Man (10/17/2007)

---

Am I missing something here??

SQL2K5 Maint. plans can most certainly have more than one schedule per plan - it can have one schedule per task (or subplan if you...

Just a guess: Do you have SSIS installed on this server? It is required to run maintenance plans.

Have you run DBCC CHECKDB to see what it reports? Did you run the upgrade advisor to see if it could identify any potential problems? Do you have any *=...

mtassin (7/8/2008)

---

I'm not sure this is true... my understanding is the actual query is pre-processed by the engine and converted via the optimizer prior to actual execution of the query...

orrego.cesar (7/8/2008)

---

thanks for your answer jim.powers... but i'm still not clear in this case.

I don't know if i have to ask in other topic (because i guess that is...

orrego.cesar (7/8/2008)

---

I have a big question (I guess that is big only for me), but... 'what is the real advantage of INNER JOIN??? why not to use WHERE condition to...

I haven't had any luck with fixed column files (as it sounds like you are trying to do). I was able to get all of my vendors at my previous...