Viewing 15 posts - 4,006 through 4,020 (of 9,715 total)
Okay. That makes sense.
I guess the next question is, is there any method of prediction on lock types or does it literally just come down to what the engine is...
September 10, 2012 at 11:19 am
GilaMonster (9/10/2012)
Brandie Tarvin (9/10/2012)
Is there a way to use an estimated execution plan to determine what kind of locks will be held on a table?
No. The optimiser knows nothing about...
September 10, 2012 at 10:55 am
GilaMonster (9/10/2012)
Oh, and please note that the blog post you referenced is 90% copy-paste from these two pages:http://msdn.microsoft.com/en-us/library/ms184286%28v=sql.105%29.aspx
Ah. Thank you for pointing that out.
September 10, 2012 at 10:20 am
It would be easier for us to answer that question if you posted the requested DDL and sample data. The sample data doesn't have to be real. You can fake...
September 10, 2012 at 9:08 am
Stewart "Arturius" Campbell (9/10/2012)
The issue relates to the
and dateadd(day, -30, getdate())section of the where clause.
And apparently I don't remember how to read this morning. DUH.
Good catch.
September 10, 2012 at 8:31 am
Post your table DLL, an INSERT statement with sample data, and what you've written on the CTE. That will help us help you better.
September 10, 2012 at 8:31 am
I think I have found my issue. Details in this post: http://www.sqlservercentral.com/Forums/Topic1356750-391-1.aspx?Update=1
September 10, 2012 at 8:24 am
Anyone can answer if they still wish to, but I think I found my issue.
Estimated Plan pointed out some index seeks. I googled locks and indexes and stumbled across the...
September 10, 2012 at 8:23 am
sstteevvee22 (9/10/2012)
SELECT dbo.RHeads.Branch, dbo.RLines.Part, dbo.Stock.Free AS [On Hand], dbo.RLines.CQty AS [Qty Last Received],
dbo.RHeads.DateTime AS Date,
...
September 10, 2012 at 8:07 am
Look up Common Table Expressions in Books Online. That's precisely what it was created for.
http://msdn.microsoft.com/en-us/library/ms190766(v=SQL.105).aspx
September 10, 2012 at 8:05 am
Check out this thread. I bet you have the same issue.
I found it by googling your error message.
September 10, 2012 at 8:02 am
aaron.reese (9/10/2012)
the view with UNION ALL the same query once for each agent table
Not something I recommend. The view will have to be recreated every time a new agents table...
September 10, 2012 at 7:23 am
DBayliss, if you can follow t.brown's advice, that would be the best solution to your issue. If you are constrained from making changes to the existing schema, here are a...
September 10, 2012 at 6:07 am
We've had the same issue due to permissions and we've had the same issue due to missing or out of date dll files on our server.
Was this package developed by...
September 10, 2012 at 5:56 am
Scott D. Jacobson (9/9/2012)
Just saw this on Hacker News and immediately thought of this long running thread: http://mattgemmell.com/2008/12/08/what-have-you-tried/%5B/url%5DThe Hacker News comments are interesting as well.
Yeah, the comment that led to...
September 10, 2012 at 5:16 am
Viewing 15 posts - 4,006 through 4,020 (of 9,715 total)