Viewing 15 posts - 1,201 through 1,215 (of 5,685 total)
SQL Kiwi (9/4/2012)
Blog post is up: http://bit.ly/ComputeScalar
... Every damn time I start thinking I'm 'good' at this software, you come by and break my brain gently. Thanks for the...
September 4, 2012 at 4:59 pm
StephLocke (prev stephanie.sullivan) (8/30/2012)
A waiter will get minimum wage in America irrespective of how crappy they are at their job. Don't be afraid to not tip!
I fear you're missing...
September 4, 2012 at 4:28 pm
Yes, but you'll end up doing it in a pair of derived structures because I can't remember offhand if you can embed an if-switch into the DATEADD function.
First, derive the...
September 4, 2012 at 4:20 pm
Short version: You're going to have to subform the ever loving daylights out of your form. The reason is hierarchal controls in Access need to be subformed or programmed,...
September 4, 2012 at 3:41 pm
Sean Lange (8/31/2012)
SQLRNNR (8/31/2012)
Sean Lange (8/31/2012)
SQLRNNR (8/31/2012)
Sean Lange (8/31/2012)
SQLRNNR (8/31/2012)
Sean Lange (8/31/2012)
dwain.c (8/30/2012)
Jeff Moden (8/30/2012)
Brandie Tarvin (8/29/2012)
dwain.c (8/29/2012)
Jo Pattyn (8/29/2012)
August 31, 2012 at 2:38 pm
Typically you don't. You can add a table hint for experimentation using WITH INDEX(1) (similar to adding with NOLOCK) and see if that cures the actual problem. Don't...
August 31, 2012 at 2:36 pm
These quotes are slightly re-arranged for pertinance and organization, so please bear with me.
Isaac Vallee (8/30/2012)
August 30, 2012 at 4:16 pm
Hey guys, need a hand with a deadlock issue. Short version: Heap table with no indexing and a single default constraint causing IX - X table level lock conflicts...
August 30, 2012 at 3:21 pm
Yeah, sorry I'm not directly helping here. Your assumptions and reading of the graph are accurate. The queries are both conflicting on an IX - X conversion for...
August 30, 2012 at 3:18 pm
Kevin Dahl (8/30/2012)
I'm not sure I could post them in a useful format, if you're looking to try and re-create the actual problem. There ends up being quite a...
August 30, 2012 at 3:06 pm
It sounds like the execution plan is changing heavily between a local call and the SSRS call. Either that or data transfer on the network is amazingly slow between...
August 30, 2012 at 3:05 pm
The Intent Exclusive locks trying to convert to exclusive aren't your direct issue here. They'll attempt to escalate at 5000 rows but it's not required, it's just an optimization...
August 30, 2012 at 2:42 pm
I don't have a solution for you but an easy workaround is to create a view in one of the databases that is basically a 'passthrough' to the table in...
August 30, 2012 at 2:25 pm
Lokesh Vij (8/30/2012)
August 30, 2012 at 2:05 pm
Alter Table Alter Column your identity column to BIGINT, you've got more than 2 billion entries !!!
August 30, 2012 at 2:01 pm
Viewing 15 posts - 1,201 through 1,215 (of 5,685 total)