No announcements
Found 748068 threads
-
0 Votestop 10 blocked queries
This will includes several queries to troubleshoot blocking or identify blocking on SQL Server instance.Answered | 5 Replies | 6772 Views | Created by Ven Raja - Tuesday, December 18, 2012 8:04 PM | Last reply by Basit Farooq - Wednesday, December 19, 2012 3:21 PM
-
0 Votes
list of blocked queries
Hi Venkat, Checkout my following article: Different techniques to identify blocking in SQL Server.Answered | 5 Replies | 2167 Views | Created by Ven Raja - Tuesday, December 18, 2012 8:48 PM | Last reply by Basit Farooq - Wednesday, December 19, 2012 3:11 PM -
3 Votes
Why is my query blocking
A parallel query will appear to block itself during execution (CXPACKET waits).Answered | 11 Replies | 1460 Views | Created by Pragati Sharma - Tuesday, June 18, 2019 4:07 PM | Last reply by Dan Guzman - Monday, June 24, 2019 10:57 AM -
0 Votes
select from select query
As you have not specify what type of query you are trying to execute, we can try simply as, SELECT FIELD1,CASE WHEN ID = 0 THEN (SELECT TOP 1 * FROM ...Answered | 1 Replies | 3250 Views | Created by Gaurav Arora IT professional (busy infotech) - Monday, September 16, 2013 11:14 AM | Last reply by Chongtham Rajen Singh - Monday, September 16, 2013 11:22 AM -
0 Votes
SELECT query
> need some help with SELECT query.Answered | 6 Replies | 729 Views | Created by green2004 - Friday, May 15, 2015 12:20 PM | Last reply by --CELKO-- - Friday, May 15, 2015 3:05 PM -
0 Votes
Capture Process blocked queries
It basically emails the details of any spid (full SQL text etc) which has caused more than 5 mins of blocking on a server.Answered | 3 Replies | 1885 Views | Created by sunny2683 - Friday, August 16, 2013 4:45 PM | Last reply by Kevin Urquhart - Friday, August 16, 2013 5:44 PM -
3 Votes
Select query block inset query
Confirm that you have locking issues – check if there are shared lock waits in wait stats, that there is no lock escalations that block readers, check that queries are ...Proposed | 6 Replies | 4759 Views | Created by arifulhaq - Saturday, July 18, 2020 8:53 AM | Last reply by Cris Zhan - Friday, July 24, 2020 1:20 AM -
0 Votes
select query
from what i understood.. may be this declare @ClientManager table(Id int,Organization varchar(20)) insert into @ClientManager values ...Answered | 1 Replies | 1347 Views | Created by emaak - Thursday, July 9, 2015 8:39 PM | Last reply by Stan210 - Thursday, July 9, 2015 8:57 PM -
1 Votes
Query for Historical Locks, Blocks, or Deadlocks
Hi miguelh, AFAIK, there's no way to query history details for locks, blocks and deadlocks(If trace flag 1222 is set on, you can find ...Answered | 1 Replies | 22956 Views | Created by miguelh - Thursday, January 28, 2016 4:16 AM | Last reply by Eric__Zhang - Thursday, January 28, 2016 4:42 AM -
0 Votes
select query
I have added a select query on top for testing the output.Answered | 9 Replies | 3914 Views | Created by Sudeep Puvvadi - Tuesday, February 7, 2012 7:57 AM | Last reply by arun.passioniway - Tuesday, February 7, 2012 3:55 PM -
0 Votes
Prevent blocking : Update query
If there are blocking query 1 update is blocking another update ( same query but different row).Answered | 5 Replies | 1257 Views | Created by sakurai_db - Tuesday, March 12, 2019 7:17 AM | Last reply by Dedmon Dai - Wednesday, March 13, 2019 1:58 AM -
0 Votes
select query
You can prevent the XML encoding with the option TYPE: DECLARE @val varchar(20) SET @val = 'Hello ' + CHAR(13) + CHAR(10) + 'World' -- Result with ...Answered | 1 Replies | 968 Views | Created by emaak - Wednesday, August 6, 2014 5:30 PM | Last reply by Olaf Helper - Wednesday, August 6, 2014 5:54 PM -
0 Votes
Select Query.
Kindly have a look at below code to see how to to obtain desired results --Sample Data declare @t table ( empNo int , empName nvarchar(100) , dateReceived ...Answered | 1 Replies | 3203 Views | Created by AnirbanSingha - Tuesday, July 10, 2012 12:39 AM | Last reply by Chintak Chhapia - Tuesday, July 10, 2012 6:00 AM -
2 Votes
Update Statistics blocks update queries?
The only thing I can think of is DDL being blocked by a schema-stability lock, which is taken by pretty much anything.Answered | 2 Replies | 2094 Views | Created by Kalyan Chakravarthi (MCP) - Monday, August 19, 2013 12:57 PM | Last reply by Andrew Bainbridge - Monday, August 19, 2013 1:17 PM -
0 Votes
Query to get the details of Blocking and deadlock occurred for the Day
Hi, I need a query to get the details of blocking and deadlock occurred for the day.Answered | 3 Replies | 1389 Views | Created by winoa - Monday, August 18, 2014 9:33 AM | Last reply by Shanky_621 - Monday, August 18, 2014 10:07 AM -
0 Votes
Block query based D-Lists
Reopen the ADUC on the Exchange server using Exchange admin account, you will find the option to new query based D-lists disappeared.Answered | 6 Replies | 4112 Views | Created by JoeQuigley - Friday, May 7, 2010 5:30 PM | Last reply by emma.yoyo - Wednesday, May 12, 2010 3:47 AM -
2 Votes
Long running select query
If the query simply runs for a long period of time and doesn't affect system resources (disk, memory, cpu, network) and also doesn't cause blocking or affect users then it might be ...Answered | 7 Replies | 1138 Views | Created by juniorkiran - Tuesday, August 18, 2015 12:33 PM | Last reply by Daniel Janik - Friday, August 21, 2015 2:36 PM -
0 Votes
SELECT QUERY
Otherwise you're correct and this query would work.Answered | 8 Replies | 4120 Views | Created by Cool Tech - Wednesday, December 2, 2009 6:34 PM | Last reply by Arif Hasan - Thursday, December 3, 2009 7:06 AM -
0 Votes
Select Query ?
But i need to SELECT QUERY about my sample.Answered | 4 Replies | 1171 Views | Created by MSDN.CSharp - Monday, August 19, 2013 8:21 PM | Last reply by --CELKO-- - Tuesday, August 20, 2013 1:24 AM -
1 Votes
Select Query
_________________________________________________ Please mark post/s answered/ helpful if they answer ur query -- kunalAnswered | 7 Replies | 3704 Views | Created by Seeta Rama Raju - Wednesday, November 11, 2009 10:05 AM | Last reply by Kunal Joshi - Thursday, November 12, 2009 12:23 PM - Items 1 to 20 of 748068 Next ›
No announcements
