253 reputation
312
bio website
location New York, NY
age 48
visits member for 3 years, 11 months
seen Jul 17 at 20:17
25 years in the field

ASM, C, C++, C#, VB, ASP.NET, TSQL +many more

Programmer, Architect, Team Lead, Director, CTO

MS Comp. Sci @ NYU '95

Contact: hoganlong at gmail.com
(Will code for work)

Sep
30
awarded  Explainer
Sep
24
awarded  Autobiographer
Dec
9
comment Microsoft Sql Server 2012. 100 000 000 rows table select/insert performance
Hardware is going to play a role -- what are you using on the hardware side. eg, do you expect to achieve this with 2 GB of memory on the server?
Nov
1
accepted Benefits of droping a temporary table
Oct
29
comment Benefits of droping a temporary table
OK, I'm convinced and gave you a +1, but I still think Martin has a more compelling case for an actual realized benefit.
Oct
28
comment Benefits of droping a temporary table
Aarons link does not back this up, when you drop a temp table it is just renamed, no resources are freed. "The temporary object is renamed to an internal form when DROP TABLE is executed, and renamed back to the same user-visible name when CREATE TABLE is encountered on the next execution." from sqlblog.com/blogs/paul_white/archive/2012/08/15/…
Oct
28
comment Benefits of droping a temporary table
Interesting, so your saying that a query batch could have an error in it which would be easier to find if you drop the table, of course if the last line of the query is the drop then this is not a benefit.
Oct
28
answered Benefits of droping a temporary table
Oct
28
asked Benefits of droping a temporary table
Jul
2
awarded  Notable Question
Jun
14
comment How to find memory usage by table?
msdn.microsoft.com/en-us/library/ms176018.aspx
May
24
revised Are individual queries faster than joins?
"teh" and "mor" are not words! Plus improve sentence structure.
May
24
suggested approved edit on Are individual queries faster than joins?
May
21
awarded  Caucus
May
21
awarded  Constituent
Sep
20
awarded  Popular Question
Jul
26
awarded  Yearling
Jul
26
answered Ordering of rows with different kinds of objects
Jul
26
answered Single query sending and retreiving duplicate data on MS SQL Server?
Jul
26
comment Ordering of rows with different kinds of objects
Would you ever be selecting more than one object type at the same time?