Lokesh Vij

Forum Replies Created

Viewing 15 posts - 31 through 45 (of 516 total)

RE: Reset of Identity

Easy one for the day. Thanks Vivek 🙂
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter

July 15, 2013 at 10:45 pm

#1632748
RE: TSQL-Order by

Easy one for Monday morning 🙂
Thanks Pramod!
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter

July 14, 2013 at 11:07 pm

#1632291
RE: TDE DR

Being unaccustomed of Encryption features, made me read about the TDE and what it takes to move the TDE protected database before marking the correct answer.
Thanks Steve, it is...
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter

July 11, 2013 at 11:15 pm

#1631802
RE: Change Tracking

Easy question for the day. Not sure..was it worth "2 points"? 😀
Anyways..thanks for the question Naseer.
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter

July 9, 2013 at 11:53 pm

#1631068
RE: SQL Server 2012 Concat

Nice and easy! Thanks Pramod
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter

July 8, 2013 at 10:21 pm

#1630647
RE: Len() with different datatypes

Nice and easy. thanks Prasad
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter

July 8, 2013 at 12:57 am

#1630322
RE: The US Holiday

kapil_kk (7/3/2013)
yooooooooo!!!!!! :hehe:
What a day 😛
feels awsome when you earned 7 points at start of the day 😀
Thanks Steve:-)
[Adding to what Hugo said the other day]
I would be more excited.....
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter

July 3, 2013 at 11:41 pm

#1629732
RE: The US Holiday

I thought this to be the easiest Qotd ever attempted. Wondering why so many wrong attempts!!
Correct answers:48%(11)
Incorrect answers:52%(12)
Total attempts: 23
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter

July 3, 2013 at 10:51 pm

#1629726
RE: T-SQL Like

Nice Question and in-line explanation makes it worthy 🙂
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter

July 3, 2013 at 5:35 am

#1629489
RE: Back to basics

martin.whitton (7/2/2013)
It provides a neat way of sending multiple options as a single integer parameter.
Nice example Martin 🙂
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter

July 2, 2013 at 3:32 am

#1628962
RE: Fun with real and float

Nice question! Thanks 🙂
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter

June 30, 2013 at 9:13 pm

#1628587
RE: How does SQL pronounce SQL?

Thanks for the Question Ron! I never used DIFFERENCE function earlier. Got to learn something today 🙂
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter

June 27, 2013 at 9:50 pm

#1628189
RE: Between Clause

amit_adarsh (6/27/2013)
why Doug is not in the list.
If I pick the names and sort them in ascending order in excel sheet, I will get below
B.
Bob
Carl
D
D.
Doug
Now as the WHERE clause is...
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter

June 27, 2013 at 2:40 am

#1627852
RE: Database Backup Restore

KWymore (6/25/2013)
Nice question. I have never used this option. Good to know!
+1 🙂
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter

June 26, 2013 at 12:31 am

#1627383
RE: Temp Table

demonfox (6/25/2013)
easy one.
In case of global temporary table creation it will throw an error. i.e ##Table1
Local Temp just gets another session.
Thanks for the question.
Good point..
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter

June 25, 2013 at 12:24 am

#1626990

Viewing 15 posts - 31 through 45 (of 516 total)