Viewing 15 posts - 16 through 30 (of 96 total)
The following query gives the result I want. But I consider it a ham fisted approach. I am sure there must be a better way and I would appreciate it...
November 10, 2014 at 11:04 am
Jeff,
Thanks for the clarification. I appreciate it.
May 14, 2014 at 8:07 am
Scott, Thanks for the confirmation.
Jeff, I tried the [0-9] and it worked. I am not sure if there is a performance gain. This query will not be used very often...
May 14, 2014 at 4:17 am
You have correctly identified the declaration of the parameters, specifically the data type, as the problem. My VS statement, “.addwithValue(“@LotNo”,”000000113855”) which is implicitly converted to @LotNo=N' 000000101058' is the...
May 7, 2014 at 11:46 am
Grant,
I did not know that so thanks for the advice. In this instance I have a Server dedicated to testing. I am the only one using it. I turn the...
March 28, 2014 at 7:51 am
I have found a partial answer. I am capturing, ShowXMLPlan, RPC:Completed, SP:StatementCompleted, SQL:BatchCompleted and SQL:BatchStarting. So far in the trace I am following, only Stored Procedures have been called. It...
March 27, 2014 at 7:51 am
Gail,
I am still a bit lost so let me paraphrase. A CTE never writes data to the TempDb. But in this instance since the TempDb grows from 8MB to 3.8...
February 26, 2013 at 4:58 am
Sergiy,
Thank you for that example. Since I am programming in VB.Net that would be an "easy" solution. However, I am using this as an opportunity in increase my SQL knowledge...
February 25, 2013 at 8:15 pm
Below you will find the CTE again and data. The data is preceeded by the Create table statement and the Alter statements for creating the indexes.
CTE Update
with MstrTbl as (Select...
February 25, 2013 at 5:17 pm
Gail,
I do not understand. If there is no activity other than this query and the TempDb grows so dramatically in size, what would the cause be?
Also, I have attached the...
February 25, 2013 at 4:33 pm
Let’s begin with the actual query that is giving me fits.
with MstrTbl as (Select N.Source, N.Sink, N.TimePoint, D.TPIntDate, D.TPHour, N.Delta From dbo.ECoUpToPairedData N
Inner Join dbo.EcoDate D
On N.TimePoint = D.TimePoint
Where D.TimePoint...
February 25, 2013 at 11:34 am
Jason,
I haven’t read/studied that article yet. Thank you. There was another article which is referenced in a previous post I made when I was trying to build the query which...
February 25, 2013 at 10:15 am
I completely agree with you. Whatever is being created in the TempDb is not being reused between when the query runs the second, third, fourth, etc times. I do not...
February 25, 2013 at 5:06 am
Bill,
It worked like a charm.
Thanks,
pat
February 15, 2013 at 9:51 am
Viewing 15 posts - 16 through 30 (of 96 total)