Viewing 15 posts - 166 through 180 (of 288 total)
Interesting if you take it out to xml you get a lot more... hard to read in xml though.
<deadlock-list>
<deadlock victim="process5b1d708">
<process-list>
<process id="process5b1d708" taskpriority="0" logused="0" waitresource="OBJECT:...
June 13, 2013 at 8:54 am
PaulB-TheOneAndOnly (6/11/2013)
Are all these production database alike? ... like implementations of the same for different customers?Hope this helps.
Thanks, no we have a number of applications that we support, and each...
June 12, 2013 at 9:37 am
So how do I tell what number to use, it does not list a Alert Number???
Date5/29/2013 11:42:28 AM
LogSQL Server (Current - 5/30/2013 11:49:00 PM)
SourceServer
Message
New queries assigned to process on Node...
May 31, 2013 at 7:25 am
Ok.. so here is what I put together ... I would have thought these two would match, but they do not... the first is wrong (vrs excel) and the second...
May 29, 2013 at 12:43 pm
I am accessing a 3rd party's database to get the data, and they store it that way... They create a generated key to link various parts of the data... shipments,...
May 28, 2013 at 3:12 pm
Thanks for the warning Jeff.
On the Jobs front.. We almost never put SQL into the Job, but thanks for reminding me to check there too. Thanks to everyone for...
May 14, 2013 at 9:59 am
I do not have permissions on the server.. and there is a lot of red tape to get anything installed.
However I did use the SQL provided... with a few changes......
May 13, 2013 at 10:30 am
Most, but not all, are dbo... but this table exists only in dbo. I think what I might have done was not to cast delivery in the where statement... the...
May 13, 2013 at 8:28 am
The only things I left out was the listing of columns and the complete name (liked server.database.dbo.table), and the WHERE includes a limit on the #delivery... "Where #Delivery.Load_From = 'Something'...
May 9, 2013 at 7:04 am
Lynn Pettis (5/8/2013)
dwilliscp (5/8/2013)
I have found one other strange thing..
The outer join has data in the columns for details_2, so I do not understand how in the heck it is...
May 8, 2013 at 12:05 pm
Sean Lange (5/8/2013)
dwilliscp (5/8/2013)
Since the first table had one record with a delivery of 00835308 and the second had none, I would have expected the SQL to return one record....
May 8, 2013 at 11:41 am
Sean Lange (5/8/2013)
What are the results of these two queries?
select COUNT(*) FROM #Delivery Where cast(delivery as int) = 83535308
select COUNT(*) from details_2 where cast(details_2.Delivery_Doc as int) = 83535308
One (Delivery)...
May 8, 2013 at 11:40 am
Eugene Elutin (5/8/2013)
dwilliscp (5/8/2013)
I have two tables.. linking on Delivery No and Item No..
Temp table #Delivery has one...
May 8, 2013 at 9:13 am
It is query time. The team that built the cube,would load data into the cache and use it all day long. But now MS will clean out cache items that...
April 12, 2013 at 7:25 pm
Thanks for your help.. I will review your link next week! 😎
April 5, 2013 at 2:10 pm
Viewing 15 posts - 166 through 180 (of 288 total)