It has been my experience that one of the most common ways un-informed SQL developers created temporary tables was to perform a SELECT <some data> INTO <some temp table> FROM...

try...

Ed Wagner (10/23/2013)

---

Revenant (10/22/2013)

---

Ed Wagner (10/22/2013)

---

crookj (10/22/2013)

---

"Be vewy vewy quiet, I'm...

Interesting comments... One thing that was not mentioned was if this process is a one-off or will be a part of a regular backup procedure. If it is a...

Luis Cazares (10/21/2013)

---

Kurt W. Zimmerman (10/21/2013)

---

Luis Cazares (10/21/2013)

---

Locks will happen on both updates. The difference might be the JOIN type which uses different standards. The first query uses ANSI-92 standard...

GilaMonster (10/21/2013)

---

You can do that, the row_version data type's great for that as you don't have to do manually update it. I've also seen people use a calculated column defined...

Luis Cazares (10/21/2013)

---

Locks will happen on both updates. The difference might be the JOIN type which uses different standards. The first query uses ANSI-92 standard and the second one uses...

Koen Verbeeck (10/21/2013)

---

Jeff Moden (10/20/2013)

---

jonysuise (10/20/2013)

---

Hi simonholzman 14059, and welcome to the forum 😀

To delete a large number of rows switch the recovery model of your database (in your development...

+1 You have no idea how many arguments I had with various...

OK, I see... as I reread all of the posts that is when...

I think Jeff has summed things up very nicely here. Bottom line here is the end result remains the same. The Wheres, How To's for where the data...

.... one more thought.... I saw a big performance hit when a new VM box was created with greater specs than the original box but performance suffered. Turned out...

I found this article on SQL Server requirements. It appears that STD version may see 64gb not 32gb. Maybe I misread it.

http://msdn.microsoft.com/en-us/library/ms143506(v=sql.105).aspx

None the less it is clear that...

I came across this white paper published by Microsoft:

http://technet.microsoft.com/en-us/library/cc990273(v=office.14).aspx

It looks like in order to get the full features of PerformancePoint you may be looking at the SS 2K8R2 Enterprise,

Kurt

+1 on this. CboValuesTranslations.cboValueTranslationName is not in your second SELECT....

Kurt