Viewing 15 posts - 451 through 465 (of 2,038 total)
WayneS (7/1/2009)
Do you think that this poster is the same one we had earlier that deleted all of his posts?
Seems this becomes more and more a new trend to delete...
July 1, 2009 at 4:17 pm
hein,
didi you try SSIS as I mentioned? Maybe this will handle your problem.
Another tool you can try is Microsoft LogFile Parser
July 1, 2009 at 9:39 am
Nice article 🙂 and really well written.
Same idea as mine:
July 1, 2009 at 6:49 am
@Solomon Rutzky
Just want let you know, your article is referenced in current German SQL PASS newsletter! 😉
July 1, 2009 at 6:18 am
naresh.patel3386 (7/1/2009)
Use Batch Update if you are updating/inserting records from ASP.Net.
Way way slower than bulk insert. SQL Server 2008 offers great new features to handle this, but SQL Server 2005...
July 1, 2009 at 5:09 am
Just an extension to arun's fine approach. Use an OUTPUT statement to get the the handled IDs to INSERT the new data without joining the large destination table.
You should also...
July 1, 2009 at 4:28 am
WayneS (6/30/2009)
Florian Reischl (6/30/2009)
WayneS (6/30/2009)
Florian Reischl (6/30/2009)If you have any questions, feel free :-). .NET development is the main part of my job.
My sympathies are extended to you...
I'm not sure...
June 30, 2009 at 4:58 pm
That's a really sad execution plan here:
June 30, 2009 at 4:32 pm
WayneS (6/30/2009)
Florian Reischl (6/30/2009)If you have any questions, feel free :-). .NET development is the main part of my job.
My sympathies are extended to you...
I'm not sure if I got...
June 30, 2009 at 3:41 pm
Little hint for future posts. Use "[code]" instead of "<code>" to post source code. Hml-tags will be miss-interpreted. 😉
June 30, 2009 at 2:18 pm
lmu92 (6/30/2009)
GSquared (6/30/2009)
...ESL (English as a Second Language) ...
Now that's something I'd call a "Linguistic Freudian slip"!
ESL sounds very close to "Esel", which is German for donkey or jackass....
June 30, 2009 at 2:05 pm
r.pe (6/30/2009)
June 30, 2009 at 2:02 pm
paulselva_26 (6/26/2009)
113 sql3="create table ##t_abc(avg decimal(5,2),year int,month int,week int)"112 set rs=CCon.execute(sql3)
Do you use exactly and only this statement?
If you first check the tables existence before you create it, the table...
June 30, 2009 at 1:54 pm
Hi Elliott
Elliott (6/30/2009)
...but you could get HOST_NAME() ...
Be careful with HOST_NAME(). It can be manipulated by client connection-string. If you have any .NET environment you can try this connection string:
"Data...
June 30, 2009 at 1:47 pm
Or Jeff's really fine articles about cross-tabs
http://www.sqlservercentral.com/articles/T-SQL/63681/
and
June 30, 2009 at 1:32 pm
Viewing 15 posts - 451 through 465 (of 2,038 total)