Viewing 15 posts - 181 through 195 (of 372 total)
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...
October 25, 2013 at 8:30 am
NineIron (10/25/2013)
I've got two CTEs. CTE1 returns one record. CTE2 returns 12. Can I join the two so that, for each record in CTE2, it returns the record from CTE1?
try...
October 25, 2013 at 8:15 am
Ed Wagner (10/23/2013)
Revenant (10/22/2013)
Ed Wagner (10/22/2013)
crookj (10/22/2013)
Daniel Bowlin (10/22/2013)
jasona.work (10/22/2013)
Ed Wagner (10/22/2013)
crookj (10/21/2013)
jasona.work (10/21/2013)
Ed Wagner (10/21/2013)
Revenant (10/18/2013)
Ed Wagner (10/18/2013)
crookj (10/17/2013)
Ed Wagner (10/17/2013)
Daniel Bowlin (10/17/2013)
breviloquentsuccinct
laconic
terse
brief
boxer
Rocky
and Bullwinkle
Rabbit
season!
Elmer Fudd
"Be vewy vewy quiet, I'm...
October 23, 2013 at 8:12 am
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...
October 22, 2013 at 8:07 am
Luis Cazares (10/21/2013)
Kurt W. Zimmerman (10/21/2013)
Luis Cazares (10/21/2013)
October 21, 2013 at 9:35 am
GilaMonster (10/21/2013)
October 21, 2013 at 9:31 am
Luis Cazares (10/21/2013)
October 21, 2013 at 9:05 am
Koen Verbeeck (10/21/2013)
Jeff Moden (10/20/2013)
jonysuise (10/20/2013)
To delete a large number of rows switch the recovery model of your database (in your development...
October 21, 2013 at 8:35 am
GilaMonster (10/18/2013)
3)Show me a database with integrity enforced by the application, I'll show you bad data in it.
+1 You have no idea how many arguments I had with various...
October 18, 2013 at 8:16 am
Greg Edwards-268690 (10/17/2013)
SQL can only see as much as the OS.Look at the compare link on this page.
OK, I see... as I reread all of the posts that is when...
October 17, 2013 at 12:14 pm
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...
October 17, 2013 at 11:53 am
.... 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...
October 17, 2013 at 11:46 am
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...
October 17, 2013 at 11:41 am
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...
October 17, 2013 at 8:47 am
T.Ashish (10/16/2013)
ChangeORDER BY CboValuesTranslations.cboValueTranslationName Asc
with
ORDER BY Name Asc
+1 on this. CboValuesTranslations.cboValueTranslationName is not in your second SELECT....
Kurt
October 17, 2013 at 7:47 am
Viewing 15 posts - 181 through 195 (of 372 total)