Viewing 15 posts - 1,651 through 1,665 (of 8,416 total)
Grant Fritchey (9/28/2011)
Jack Corbett (9/28/2011)
Hey can an execution plan expert (Grant?) take a look at this thread, http://www.sqlservercentral.com/Forums/Topic1181619-338-1.aspx. Interesting behavior noted in execution plan properties with SET ANSI NULLS.
I...
September 28, 2011 at 7:51 am
e-ghetto (9/27/2011)
I'm setting the ANSI_NULLS setting for a query explicitely to "ON". But execution plan properties show "FALSE" for this setting. Is this a bug?
Almost certainly a bug in the...
September 28, 2011 at 7:41 am
GSquared (9/28/2011)
SQL Kiwi (9/28/2011)
WayneS (9/27/2011)
• ...
September 28, 2011 at 6:49 am
WayneS (9/27/2011)
• SQL...
September 28, 2011 at 5:30 am
codebyo (9/24/2011)
I'm currently starting a new SQL blog(it's very basic now and in Portugues)...
Looks good! I am also a fan of Fabiano Amorim by the way.
September 24, 2011 at 9:01 am
codebyo (9/23/2011)
SQL Kiwi (9/23/2011)
http://sqlblog.com/blogs/paul_white/archive/2010/08/05/iterators-query-plans-and-why-they-run-backwards.aspx
I have been following your blog for some time now but I hadn't found that article before. I have much to learn and I appreciate those links....
September 23, 2011 at 10:47 pm
R.P.Rozema (9/23/2011)
September 23, 2011 at 9:42 am
R.P.Rozema (9/23/2011)
September 23, 2011 at 8:49 am
krishna.vanne (9/22/2011)
My question is which one is apt or works better.
It's a question of style. My personal preference is to start the transaction inside the TRY (option 2) just...
September 23, 2011 at 7:19 am
codebyo (9/22/2011)
September 23, 2011 at 12:06 am
Cliff Jones (9/22/2011)
Yes, I saw 1,2,3 and almost forgot to count the null value. Good straight forward question with all the likely wrong answers.
I did forget to count the...
September 22, 2011 at 8:29 pm
Jeff Moden (9/20/2011)
Hmmm... based on our previous conversation, why didn't you include an ORDER BY in this particular example?
Just forgot. I used one in my final example http://www.sqlservercentral.com/Forums/FindPost1177369.aspx
September 20, 2011 at 9:32 pm
GilaMonster (9/20/2011)
SQL Kiwi (9/20/2011)
Amateurs.
SELECT REPLICATE(CONVERT(VARCHAR(MAX), CHAR(39)), 9223372036854775807)Apostrophes all gone :laugh:
Memory too. :crash:
I actually tried running this command before I posted it. :pinch:
I clicked 'cancel' nearly ten minutes ago now :crying:
I...
September 20, 2011 at 1:28 pm
Amateurs.
SELECT REPLICATE(CONVERT(VARCHAR(MAX), CHAR(39)), 9223372036854775807)
Apostrophes all gone :laugh:
September 20, 2011 at 1:17 pm
Chad Crawford (9/20/2011)
September 20, 2011 at 11:10 am
Viewing 15 posts - 1,651 through 1,665 (of 8,416 total)