Hugo Kornelis (10/17/2013)

---

A good question. I missed my point, because I once again made the mistake of trusting the documentation.

http://technet.microsoft.com/en-us/library/ms181647.aspx says that if sp_recompile specifies a table or view, all...

marcia.j.wilson (10/17/2013)

---

What I really hate...

Thanks Mikael. I tried for some time and was getting same "Kalle" for both proc execution from the xml (though the query you provided was giving "Kalle" and "Pelle").

Now...

Agreed. ParameterCompiledValue is the one which should be considered to answer this question (as I got it and please correct me if I'm wrong).

With my earlier attempt it was giving...

Mikael Eriksson SE (10/17/2013)

---

That is as it should be. The question was about what value was used as input to the...

I still didn't get it. I created one table and populated it as follows"

create table dbo.T(Name varchar(20))

insert into dbo.T values('Kalle'), ('Urban'), ('Steve'), ('Sqlnaive')

Then after creating the procedure as provided, I...

Easy one... 🙂

Check DDL triggers.

Stuart Davies (10/15/2013)

---

ISNUMERIC returns 1 if the value could be interpreted as a number and 0 if it couldn't. The three examples in the QOTD...

Check out first on which value is going to be updated with which value with the following query:

select B.starttime, case when A.fromtime <> B.starttime then A.fromtime end as 'Updatedstarttime',

B.endtime, case...

Thanks a lot Gail. This nature of t-logs chain was wonderful to know.

Also thank you John for clarifications.

Easy & good one. 🙂

Excellent

Old article but still strikes the gold 🙂

It is awesum John. Very big thanks.

Also a masterpiece article for Gail. I'm going to share it with many of my DBA friends as even they were confused on...

I tried checking info about transaction logs from following site but couldn't get any:

http://technet.microsoft.com/en-us/library/ms190925.aspx

Now I found this site:

http://technet.microsoft.com/en-us/magazine/2009.07.sqlbackup.aspx

It says that "A transaction log backup contains all the transaction...