Viewing 15 posts - 166 through 180 (of 2,647 total)
Any time I am running any of the suggested code to grab the deadlock graphs, I am looking at the xml and seeing that object_id in the resource-list is blank....
Jared
CE - Microsoft
February 27, 2013 at 9:28 am
That's helpful, but it refers to SQL_statement_completed, not sp_statement_completed. Is it possible that sp_statement_completed refers to each statement within the stored proc? I'm still a bit confused...
Jared
CE - Microsoft
February 20, 2013 at 1:31 pm
Lynn Pettis (2/20/2013)
How many SQL statements are there in the stored procedure?
Several. This is a stored proc that should be a large Method in C# 🙂 Do...
Jared
CE - Microsoft
February 20, 2013 at 12:58 pm
Bump!
Jared
CE - Microsoft
February 20, 2013 at 12:43 pm
I recreated the session and added a ring buffer target as well. When the stored proc was executed once, I found 21 rows of data in the results (events)...
Jared
CE - Microsoft
February 20, 2013 at 6:50 am
opc.three (2/1/2013)
Search for 'entitized' on this page for some details and...
Jared
CE - Microsoft
February 1, 2013 at 6:38 am
opc.three (2/1/2013)
@Jared, where did you land on the code review? Are you sending the code back for refactoring using officially supported techniques?
We are going to use the FOR XML method....
Jared
CE - Microsoft
February 1, 2013 at 6:23 am
dwain.c (1/31/2013)
SQLKnowItAll (1/31/2013)
Here's my issue......
2. However!!! SQL 2012 solves this problem with new window functions, so I'm not going to complain too much... 😀
Jared - I would be most interested...
Jared
CE - Microsoft
January 31, 2013 at 8:28 pm
Here's my issue...
1. It is not syntactically correct, so it should not work. Just because it solves a problem that many of us have does not make it a...
Jared
CE - Microsoft
January 31, 2013 at 6:38 am
DiverKas (1/30/2013)
SELECT STUFF(( SELECT ''+A.data FROM (SELECT DISTINCT TOP 100 PERCENT data FROM #temp ORDER BY data) AFOR XML PATH ('')),1,1,'')
Would that not work? I have found that to...
Jared
CE - Microsoft
January 30, 2013 at 11:42 am
ScottPletcher (1/30/2013)
No, no syntax errors per se, but that method's not guaranteed to work safely either.
Thanks Scott! Now, in a second question... What do you think is the best way...
Jared
CE - Microsoft
January 30, 2013 at 10:59 am
Gazareth (1/30/2013)
SQLKnowItAll (1/30/2013)
Jared
CE - Microsoft
January 30, 2013 at 10:52 am
What is a "relatively large" database? Can you give us an actual size? I want to rule out other problems... Anthony's suggestion of initializing from a backup would be...
Jared
CE - Microsoft
January 30, 2013 at 10:49 am
After reviewing BOL, I do not see anywhere that it states that the file sizes are copied from model. In fact, the only reference I see to file size...
Jared
CE - Microsoft
January 30, 2013 at 9:54 am
pramod.gururaj (1/25/2013)
I have to bcp an excel to a table and when i give this command below, it is giving me the following error 🙁
Exec Master..xp_cmdshell 'bcp pmdb.dbo.abc in...
Jared
CE - Microsoft
January 25, 2013 at 9:43 am
Viewing 15 posts - 166 through 180 (of 2,647 total)