Viewing 15 posts - 48,631 through 48,645 (of 49,571 total)
When I tried it, with the schema I got no rows, without it your query returned one row.
Is the xml column bound to a schema?
-- Test code
CREATE
...
June 7, 2007 at 11:51 pm
Best this is to run the query in management studio withn the execution plan enabled and look at where the high costs are. That should give you some indication where...
June 7, 2007 at 7:49 am
Please don't cross-post
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=65&messageid=371682
June 7, 2007 at 5:43 am
You have both union and distinct. With union, distinct is redundent, since union removes duplicates anyway.
Do the views retrun duplicate data? If not, you can remove the distincts
Is there any chance of...
June 7, 2007 at 4:32 am
Inserts by themselves should not be able to deadlock. that requires 2 or more commands in a transaction ussually. Is there a trigger on that table?
You can try setting the...
June 7, 2007 at 2:28 am
I'm not sure why you're doing a group by without aggregates. Duplicate records?
Try something like this (2005 specific)
SELECT
mile_code, DeltaT, rep
June 7, 2007 at 2:00 am
Are you thingking of the SQL_Text DMV?
SELECT
er.session_id, start_time, database_id, st.text
FROM
June 7, 2007 at 1:41 am
I think it has something to do with the schema. When I took the schema definition out of your XML, the select returned one row.
I haven't had that much expereience...
June 7, 2007 at 1:21 am
I was supposed to be writing 442 at the end of this month, but it's been postponed to next month due to time constraints.
I wrote 441 a couple months back...
June 7, 2007 at 12:56 am
I was supposed to be writing 442 at the end of this month, but it's been postponed to next month due to time constraints.
I wrote 441 a couple months back...
June 7, 2007 at 12:53 am
Try catching the Stored Proc: SPStarted event instead of the RPC started event. I know that in 2005 the SPStarted event doesn't filter.
AFAIK the filtered words are 'password' and 'setapprole'
June 6, 2007 at 12:48 am
I studied for 431 from just Books Online and the Pocket administrator's guide. I took the requirement list from MS site and went through each them one by one.
That said,...
June 5, 2007 at 2:40 am
Interesting. I recall that SQL 2000 would never create multi-column stats. I looked in the 2005 BoL and couldn't find anything that outright stated that it will or won't. I...
June 5, 2007 at 12:11 am
Interesting. I wasn't aware of that.
I would still suggest that you try and find the cause of the deadlock and eliminate it, rather than handling and trying again.
June 4, 2007 at 4:21 am
Profiler is a very good place to start. If you run it during the slow downs you should be able to identify the source of the long duration locks
Also make sure...
June 1, 2007 at 4:27 am
Viewing 15 posts - 48,631 through 48,645 (of 49,571 total)