Stefan Krzywicki (9/27/2011)

---

Sean Lange (9/27/2011)

---

Stefan Krzywicki (9/27/2011)

---

Sean Lange (9/27/2011)

---

GSquared (9/27/2011)

---

It's a pretty fair bet that some people would assume I'm a pretty rabid conservative. On...

Stefan Krzywicki (9/27/2011)

---

Sean Lange (9/27/2011)

---

GSquared (9/27/2011)

---

It's a pretty fair bet that some people would assume I'm a pretty rabid conservative. On the other hand, there...

They're the same speed.

The advantage to Select is you can assign values to multiple variables at the same time, and can include full Select statement functionality.

The advantage to Set is...

That'd be...

Sean Lange (9/26/2011)

---

/soapbox on

Boy I must be on of the few conservatives on here...the amazon article was thought provoking but I find the author's stance does not align with my...

Jack Corbett (9/26/2011)

---

So where is everybody? No messages over the weekend and only 2 today?

I know the Summit isn't for a few more weeks so that can't be the...

Elliott Berkihiser (9/26/2011)

---

Ah, I just found part of the answer. This org wants to have documented procedures for all kinds of things. And it seemed easier to have...

You're welcome.

You're welcome.

tfendt (9/26/2011)

---

...A lot of the articles I've read suggested setting the locked pages in memory permission and enabling awe on 2005 SQL Servers running on Server 2003 because of problems...

Well, I'd at least wait till it actually comes out.

But I've never been one of the "wait for SP1" people. If I like the new features, I'll test the...

The log backup is essentially useless in this case. They'd be better off with just putting the database in Simple Recovery mode and not backing up the log. ...

You'll need a 64-bit driver. Searching for "64 bit jdbc driver" in Bing gave some results. Not sure if they can be trusted or not, but should be...

In the properties for the file connection, build the Connection string to be dynamic using the Expressions option.

You can build the connection string using variables based on the current date,...

jared-709193 (9/26/2011)

---

So I think part of this "take home message" from both of you is that the following:

CREATE TABLE #TEMP (id INT, fruit VARCHAR(20))

INSERT INTO #TEMP

SELECT 3 AS id,'apple' AS...