Viewing 15 posts - 136 through 150 (of 171 total)
GilaMonster (9/29/2010)
arr.nagaraj (9/29/2010)
Default trace contains the recently ran queries along with a few useful informationlike CPU, starttime etc. .. Probably can help your root cause analysis
The default trace does not...
October 5, 2010 at 6:10 am
Ninja's_RGR'us (9/28/2010)
Am I the only one NOT seeing a plan in that excel file??
The file attached is the results of my query of the execution plan, that's the only way...
September 28, 2010 at 10:11 am
LutzM (9/27/2010)
What processes do you usually kill and what status those are at?
You should run profiler...
September 28, 2010 at 9:00 am
Chris Morris-439714 (9/24/2010)
Have you tried following the steps recommended by Winash?
I have been trying to query the OR statements one at a time but it is still the same issue.
September 24, 2010 at 5:51 am
Chris Morris-439714 (9/24/2010)
Run these two queries and describe the output:
SELECT sc.OrderID, sd.OrderID
FROM supplydates sc
LEFT...
September 24, 2010 at 5:24 am
Chris Morris-439714 (9/23/2010)
tt-615680 (9/23/2010)
I get the same problem when I just run the query by itself.
The whole point of the query is to get all the updated data from...
September 24, 2010 at 4:04 am
Chris Morris-439714 (9/23/2010)
What are you expecting to see?Why are you wrapping these two statements inside a transaction?
What do you see if you remove INTO #UpdatedValue from your first query?
The reason...
September 23, 2010 at 10:13 am
Chris Morris-439714 (9/17/2010)
tt-615680 (9/17/2010)
September 17, 2010 at 9:26 am
CirquedeSQLeil (9/15/2010)
With eleven update statements, it could be useful to isolate each...
September 17, 2010 at 4:23 am
CirquedeSQLeil (9/14/2010)
It would be extremely useful to post the tsql for this job. An execution plan of the tsql would also be highly useful.
ALTER PROC [dbo].[storedprocedurename]
AS
DECLARE @paramnameAS DATETIME
SELECT
@paramname=...
September 15, 2010 at 8:33 am
Steve Jones - Editor (9/14/2010)
I'm not really clear what you're looking for in the job? Perhaps you could explain it better and include some code that might help?
What the code...
September 14, 2010 at 8:49 am
Abhijit More (9/14/2010)
Please provide more information on Job, what does it do?
What the code does is, it looks for any data that has been inserted one day before in one...
September 14, 2010 at 7:33 am
Toby White (9/14/2010)
September 14, 2010 at 7:31 am
tt-615680 (8/26/2010)
GilaMonster (8/26/2010)
Edit: Is that extra quote in your statement a typo?
Should be
BACKUP DATABASE 'Databasename' TO DISK = 'E:\'filename.BAK'...
August 27, 2010 at 4:09 am
GilaMonster (8/26/2010)
Edit: Is that extra quote in your statement a typo?
Should be
BACKUP DATABASE 'Databasename' TO DISK = 'E:\'filename.BAK'
not...
August 26, 2010 at 3:13 am
Viewing 15 posts - 136 through 150 (of 171 total)