cw.izatt (2/16/2012)

---

Jeff Moden (2/16/2012)

---

cw.izatt (2/16/2012)

---

After...

GilaMonster (2/16/2012)

---

So tell me then, how do you (not the database engine)...

Evil Kraig F (2/16/2012)

---

SQLKnowItAll (2/16/2012)

---

jake.mayher (2/16/2012)

---

I agree with Jeff, ETL is in no way specific to the dimensional data warehouse. I define ETL as any process which takes data from...

Doesn't look like it in 2008. http://connect.microsoft.com/SQLServer/feedback/details/428844/enable-disable-intellisense-in-mgmt-studio-with-keyboard-shortcut

jake.mayher (2/16/2012)

---

I agree with Jeff, ETL is in no way specific to the dimensional data warehouse. I define ETL as any process which takes data from one source into another...

I would start at the beginning... Open a command prompt and ping the server. If you can't then you have a connection issue. If you can, make sure that...

If you don't know the answer to this, you probably should not be interviewing for the job. Nevertheless, start here and learn about the different types of locks: http://msdn.microsoft.com/en-us/library/ms175519.aspx

And we use xp_cmdshell to WMI tools.

What exactly are you asking? Are you trying to create a lock for some reason? Teaching? Demonstration? Testing?

Yes, but what I am saying is that the actual data in the flat file is NOT 255. It is longer.

Jeff Moden (2/16/2012)

---

SQLKnowItAll (2/16/2012)

---

Why not? SQL is perfectly capable of handling it and if it is a dedicated...

Glad to help!

It means that the data in one of the columns is too long for the target table:

Run each statement separately.

CREATE TABLE #temp (integer int, characters varchar(5))

INSERT INTO #temp

SELECT 1, 'jared'...

Inquiring minds want to know... What was the issue and how did you solve it?

Brandie Tarvin (2/16/2012)

---

SQLKnowItAll (2/16/2012)

---

I would check on the credentials used to set up the UCP. @Brandie, UCP is a way to monitor several SQL Servers from 1 and set up...