Viewing 15 posts - 16 through 30 (of 186 total)
Elliott Whitlow (3/29/2012)
I have seen this on VERY large tables, you might need to add a statistic, that has seemed to resolve a lot of my issues.CEWII
Yes Elliot, my table...
March 29, 2012 at 12:30 pm
dweil (3/29/2012)
I want to write a query to find out which employees have preformed a service on the weekend over a quarter period. They get one...
March 29, 2012 at 12:19 pm
Hi Sean, surprised you found this post because it's probably buried in this forum (or at least WAS). I saw someone else wrote out their "schedule" to an outlook style...
February 29, 2012 at 12:16 pm
There we go! It looks like this worked:
Set @ID = 46633086
Select cast(Cast(CorrespondenceFO as ntext) as xml) From IARTS..CorrespondenceLog Where CorrespondenceLogID = @ID
Thanks Lutz!!!
February 17, 2012 at 11:29 am
Thanks Lutz.
I tried that and got this as an error:
Msg 9402, Level 16, State 1, Line 20
XML parsing: line 1, character 39, unable to switch the encoding
Is it because this...
February 17, 2012 at 11:26 am
Fixed. Incorrect version of the SQLServer2005_BC_x64.msi.
October 27, 2011 at 9:35 am
Here we go. I was only able to reproduce when I do "exec [procname]"...
October 21, 2011 at 10:01 am
GilaMonster (10/21/2011)
Those 2 plans are, as far as I can tell, absolutely identical. Did they perform radically differently?
No, for the 2 executions I did, one OFF and one ON, they...
October 21, 2011 at 9:53 am
GilaMonster (10/21/2011)
Without seeing at least the procedure and preferably the execution plans too, no.
I always forget to include the stuff y'all need...
USE [IARTS]
GO
Set ARITHABORT ON
Declare @VehNoList varchar(8000)
Set @VehNoList = 5140014
DECLARE...
October 21, 2011 at 9:42 am
Update for this problem (fixed).
Our DBA rebooted our SQL Server, and that didn't fix the problem. Our backups job started later on that night and got hung up somehow. Had...
October 21, 2011 at 9:20 am
GilaMonster (10/19/2011)
gregory.anderson (10/19/2011)
I'd have to ask her to shut down the Quest tools, but then we'd have to rely on the users to tell us how performance is.....
No, you can...
October 19, 2011 at 1:26 pm
Nobody running SQL Server Profiler. DBA hasn't responded yet but she usually runs PSSDiag if she does any tracing...and she usually tells me if she's going to...
I'd have to ask...
October 19, 2011 at 12:53 pm
The "heavy hitters" in Quest are all Create Table #tempTable statements inside stored procedures. Any idea why a simple create temp table statement could be the cause of this? (If...
October 19, 2011 at 12:29 pm
Damn, says it's coming from our application....just started happening yesterday and we haven't done a code move in a month. :angry:
October 19, 2011 at 12:27 pm
I'll check, good thought. Only myself, and our DBA have the permissions to run that though....we'll see.
October 19, 2011 at 12:14 pm
Viewing 15 posts - 16 through 30 (of 186 total)