Viewing 15 posts - 106 through 120 (of 205 total)
Mighty (1/18/2013)
Dave62 (1/18/2013)... I was interested and curious about why the message (1 row(s) affected) was being returned. It would appear that some have confirmed my suspicion that the...
January 18, 2013 at 7:10 am
paul s-306273 (1/18/2013)
In my naivete I'm thinking 'so what?'.Is there a relevance to this?
No, I don't think there is any "relevance" so to speak. Some questions are just trivia.
I was...
January 18, 2013 at 6:09 am
Thanks for the answers! I'd much rather learn the best practice by asking here instead of finding out the hard way. 🙂
January 17, 2013 at 8:27 am
GilaMonster (1/17/2013)
Because it allows for parameterisation of the dynamic SQL (which exec does not). That leads to better plan reuse and better security
Thanks for the answer!
Does this apply only to...
January 17, 2013 at 8:10 am
gkganeshbe (12/26/2012)
Is there any performance difference in the below given three queries.Note: Col1 is NOT NULL column
SELECT COUNT(*) FROM Sales.SalesOrderDetail;
SELECT COUNT(Col1) FROM Sales.SalesOrderDetail;
SELECT COUNT(0) FROM Sales.SalesOrderDetail;
Good question. I ran...
December 27, 2012 at 6:43 am
Thanks for the question!
Lucky for me I answered before having my coffee. After less than 5 seconds of thought I chose the correct answer because I have used filtered...
December 20, 2012 at 6:43 am
palotaiarpad (12/19/2012)
I'm also wrong, but i learned something. Could someone please explain, why is the identity resetted after a truncate? For me is a possible source of inconsitency.
Hello, if resetting...
December 19, 2012 at 7:01 am
ashokkumar.thangavel-639050 (12/6/2012)
I need a favor here.. Guys, could you please help me on this below scenario,
I have one ssis 2005 package, in this running one sp which will...
December 6, 2012 at 7:15 am
bitbucket-25253 (12/4/2012)
1. I did test the code multiple times ...
2. When testing the ; was NOT present.
3. I can only guess,...
December 4, 2012 at 7:22 am
Hugo Kornelis (12/4/2012)
Did he actually try the code himself? In that case, it is a nasty trick question,...
December 4, 2012 at 6:45 am
Jan Van der Eecken (11/28/2012)
To Dave62, just a thought, given all the negative feedback you had, maybe it would have been a better idea to just post this one...
November 29, 2012 at 6:12 am
I came across this odd behavior in SSMS the other day when I was looking at estimated execution plans and thought I'd share it with the community.
Sorry if some do...
November 28, 2012 at 6:39 am
Great points about looking before leaping into the cloud!
"... just don’t forget to read the small print."
It may be worse than not forgetting to read the small print because you...
November 21, 2012 at 9:16 am
Which of the following statements is true of table variables in SQL Server 2008, 2008 R2, and 2011? (select 6)
It's not possible to pick 6 true statements for all of...
October 19, 2012 at 7:09 am
Viewing 15 posts - 106 through 120 (of 205 total)