simple one, just need to analyse the Query.

I was sure about the %(Modulo) and found the answer quit easily.

i learned about Bitwise Exclusive OR (^).thanks for a nice Question.

David McKinney (6/18/2010)

---

sharath.chalamgari (6/18/2010)

---

i tried with "ma-516002" query in the 2005 version the results are same i am able to get the records from both the tables. when i tried...

i tried with "ma-516002" query in the 2005 version the results are same i am able to get the records from both the tables. when i tried something simila with...

easy one.....

can we get the table structure and the procedure.

Please check the index of the table and procedure exection plan

Nice Question on the Select Into

for a second i thought Question as How many Rows then while selecting the answer i saw it as columns :hehe:

i new the answer but still last my points because i ignored the systax error. at least could have provided the sysntax error option which will enable us to think...

Thanks Paul, i was thinking that the Log Backups will be smaller.

again i learned something new today!

Use the Export Package as u used earlier but choose the package location as the File system and save the package to your disk. Now you can open and edit...

Good Question, we will be always thinking that having can be used only with the Group By clause.

Good Question:-)

it is hard to read

If any one is answered incorrectly because of the visibility they can use this code

Create Table #s(start datetime,[end] datetime)

Insert Into #s

Select Cast ('2010-04-08 12:00:00'as...

Support ends at Dec 2011

if you use IS NULL then there will not be any effect on the ANSI_NULLS settings

Today i learned about the Transaction Logs and virtual log files