Viewing 15 posts - 1,726 through 1,740 (of 5,590 total)
SQLkiwi (3/7/2011)
Stefan Krzywicki (3/7/2011)
Just send him money! If he gets enough he may feel guilty and decide he has to write a book.An excellent suggestion. 🙂
If you were serious, you...
March 7, 2011 at 1:24 pm
SQLkiwi (3/4/2011)
Exciting day - just had my first Simple Talk article published:http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/
Two questions:
1. When I can pre-order your book?
2. When do you start working for sqlskills.com?
Man, this is some absolutely...
March 7, 2011 at 12:16 pm
Regarding the number of rows in a table variable before switching to a temporary table: I have seen issues with table variables with as few as 48 rows in the...
March 6, 2011 at 6:06 pm
burtsev (3/6/2011)
Temp tables can be processed in parallel. Table variables are not.
Select statements on table variables CAN be processed in parallel. Update, insert and delete statements - not so.
... But...
March 6, 2011 at 5:57 pm
MysteryJimbo (3/6/2011)
the benefit of using a table variable over the IO required to create a temporary table is quite significant.
Really? You seem to be implying that there is no...
March 6, 2011 at 5:49 pm
LutzM (3/6/2011)
The best article I came across so far: http://www.sqlservercentral.com/articles/Temporary+Tables/66720/
:blush:
Thanks Lutz!
March 6, 2011 at 5:45 pm
SQLkiwi (3/4/2011)
Ok, so the first part of my parallelism article went out a couple of days earlier than I expected :blush:Link: http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/
That is one fantastic article. When's the book coming...
March 4, 2011 at 9:16 pm
Jeff Moden (3/4/2011)
March 4, 2011 at 8:49 pm
LutzM (3/4/2011)
The only difference I see between the two UNIONed SELECTs is the value of free_runner. And this would be...
March 4, 2011 at 8:43 pm
SQLkiwi (3/4/2011)
SELECT CONVERT(VARCHAR(12), Emp.empno) + ' | ' +
STUFF(CA1.marks.value('./text()[1]', 'varchar(max)'), 1, 1,...
March 4, 2011 at 8:37 pm
Dave Ballantyne (3/4/2011)
Try this link http://www.sqlservercentral.com/articles/comma+separated+list/71700/
Thanks for the plug Dave.
March 4, 2011 at 8:36 pm
Rog Saber (3/3/2011)
March 3, 2011 at 8:59 pm
Rog Saber (3/3/2011)
I've attached the exec plan. Is there a way to do the indexes easily or do I have to do them 1 by one?
Try this index out:
USE [BUNGE_TEST]
GO
CREATE...
March 3, 2011 at 8:56 pm
lee rite (3/3/2011)
ColdCoffee (3/3/2011)
lee rite (3/3/2011)
Thanks again! I think I'm done! I really appreciate all the help!Will i be getting a Samsung Focus for this help , mate ?? :hehe:
I...
March 3, 2011 at 1:48 pm
ColdCoffee (3/3/2011)
Yes it will.. IF u could post sample data in a readily consumable foramt, we can work right away in providing a code for you..
And for help in getting...
March 3, 2011 at 1:07 pm
Viewing 15 posts - 1,726 through 1,740 (of 5,590 total)