Viewing 15 posts - 151 through 165 (of 552 total)
Thank you for the post, good one.
(on Monday, I was checking this on my VMs, has a script and launched the 2008r2 instance, changed the compatibility to 90 and then...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
August 28, 2014 at 2:04 am
Carlo Romagnano (8/27/2014)
What do you mean with "we can use print and exec commands in single query"?
that word "query" is confusing... I guess he means in one "batch" or in...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
August 27, 2014 at 2:37 am
Thank you for the post, Shiva, interesting one.
(at first I did not pay attention on the variable size, so I selected two options which seemed right, then I re-read the...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
August 27, 2014 at 1:46 am
Thank you for the post, very very interesting one, never new the word "SARGable" really exists, learnt a good amount of new stuff today. thank you.:-)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
August 26, 2014 at 9:17 am
sestell1 (8/25/2014)
Does anyone actually use the PIVOT operator?I find it so limited that I almost always roll my own using GROUP BY and CASE.
I have one SP where I use...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
August 25, 2014 at 7:03 am
TomThomson (8/24/2014)
...............
Thank you, Tom. As they say, there is no good or bad, and it is just a person's point of view. Not just on in this post, not SQL.....
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
August 25, 2014 at 4:35 am
Thank you for the post, SJ, actually funny one for me after reading the choices, can't stop laughing for this ... "Big Infrastructure Manipulation Language".
(well, at least week's ending...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
August 22, 2014 at 2:47 am
TomThomson (8/21/2014)
twin.devil (8/21/2014)
Just for the information.Becuase #table names max length is only 116 characters in SQL Server 2008 r2. its also valid of SQL SERVER 2012.
It's valid in every...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
August 21, 2014 at 8:20 am
SqlMel (8/20/2014)
Hany Helmy (8/6/2014)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
August 20, 2014 at 7:39 am
SqlMel (8/20/2014)
Well, I don't feel so bad since 83% so far have been incorrect...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
August 20, 2014 at 7:07 am
TomThomson (8/19/2014)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
August 19, 2014 at 1:41 pm
Nils Gustav Stråbø (8/19/2014)
In other words, all isolation levels have their pros and cons. Which one you choose depends on the business requirements for each case.
Thanks, Nils, this makes a...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
August 19, 2014 at 1:32 pm
John Mitchell-245523 (8/19/2014)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
August 19, 2014 at 1:22 pm
Thank you, Tom, very interesting one.
As the old saying goes "everything has pros and cons", so any one see the "pros" side of it?
(I am kind of feeling now, its...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
August 19, 2014 at 10:25 am
Viewing 15 posts - 151 through 165 (of 552 total)