Viewing 15 posts - 2,866 through 2,880 (of 49,571 total)
GilaMonster (6/29/2016)
Does that table have an index on the DueDate column?
June 29, 2016 at 3:42 pm
LinksUp (6/29/2016)
It said something along the lines that transactions are logged but that the space used will be overwritten.
Yup, that's correct. Simple recovery means that the log space is automatically...
June 29, 2016 at 3:05 pm
Maybe remove the WHERE clause that's filtering out the inactive rows? A guess, because you haven't posted the definition of the procedure, so I have no idea what it inserts...
June 29, 2016 at 2:57 pm
Sree Divya (6/29/2016)
is there any possibility of chance to delete the rows from table WHERE DueDate = '20020701'; USING CTE Funcion.
Yes, but I don't know why you'd want to seeing...
June 29, 2016 at 2:40 pm
LinksUp (6/29/2016)
You could try and put the database in simple recovery mode to minimize logging.
ALTER DATABASE database_name SET Recovery SIMPLE-- Do Deletes
ALTER DATABASE CIS SET Recovery FULL
Gah!!!
Simple recovery does not...
June 29, 2016 at 2:38 pm
TomThomson (6/29/2016)
In fact real Britons don't approve of these non-Brit Anglo-Saxon and Norman-French invaders calling themselves Britons. 😛
You know, after a thousand or so years, I think we can...
June 29, 2016 at 2:10 pm
It's the same as WHERE 1=1, a logical condition that can never be false, will never exclude any rows and is ignored by the Query Optimiser
June 29, 2016 at 2:07 pm
Jeff Moden (6/29/2016)
June 29, 2016 at 2:02 pm
Screen shots are useless, please post the XML deadlock graph here. Profiler does capture the XML.
June 29, 2016 at 10:36 am
Please post new questions in a new thread. Thanks
June 29, 2016 at 10:35 am
That will only be non-zero if the SQL Server is running with locked pages enabled. Without that, it can't lock pages and hence that value will be zero.
June 29, 2016 at 7:59 am
Probably a key-lookup deadlock, table scans wouldn't cause a deadlock if it's just these two queries.
June 29, 2016 at 6:58 am
Jeff Moden (6/28/2016)
Steve Jones - SSC Editor (6/28/2016)
Jeff Moden (6/25/2016)
From the Article:
“This doesn’t work like it used to.”
While I agree that it probably has fewer bugs that previous releases,...
June 29, 2016 at 4:54 am
June 29, 2016 at 3:57 am
Viewing 15 posts - 2,866 through 2,880 (of 49,571 total)