Viewing 15 posts - 181 through 195 (of 727 total)
Hugo Kornelis (10/17/2013)
http://technet.microsoft.com/en-us/library/ms181647.aspx says that if sp_recompile specifies a table or view, all...
October 17, 2013 at 10:28 pm
marcia.j.wilson (10/17/2013)
Richard Warr (10/17/2013)
How nice not to see page on page of "Easy peasy" comments.Interesting question which opens up an area still uncharted for many developers.
What I really hate...
October 17, 2013 at 9:32 am
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...
October 17, 2013 at 6:14 am
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...
October 17, 2013 at 5:13 am
Mikael Eriksson SE (10/17/2013)
sqlnaive (10/17/2013)
It gave me "Pelle" two times for both executions.
That is as it should be. The question was about what value was used as input to the...
October 17, 2013 at 5:00 am
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...
October 17, 2013 at 3:07 am
Stuart Davies (10/15/2013)
T.Ashish (10/15/2013)
Why it returns 1 ?
ISNUMERIC returns 1 if the value could be interpreted as a number and 0 if it couldn't. The three examples in the QOTD...
October 15, 2013 at 1:50 am
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...
October 14, 2013 at 6:00 am
Thanks a lot Gail. This nature of t-logs chain was wonderful to know.
Also thank you John for clarifications.
October 14, 2013 at 1:25 am
Excellent
Old article but still strikes the gold
October 11, 2013 at 7:52 am
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...
October 11, 2013 at 7:50 am
GilaMonster (10/11/2013)
Books Online?
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...
October 11, 2013 at 7:26 am
Viewing 15 posts - 181 through 195 (of 727 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy