SQLServerCentral / Question of the Day (QOD) / Testing Center

Question of the Day for 20 Jan 2004

Site Owners — Mon, 19 Jan 2004 12:05:00 GMT

Comments posted to this topic are about the Question of the Day for 20 Jan 2004 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=164.

connections sleeping

Angel DBA Mex — Tue, 05 Jun 2007 11:39:00 GMT

i have a doubt, when i execute sp_who the display send me de current conections, but almost case there are a connections with the following information53 0 sleeping NT AUTHORITY\SYSTEM SIMIMX-SIF2 0 msdb AWAITING COMMAND54 0 sleeping NT AUTHORITY\SYSTEM SIMIMX-SIF2 0 master AWAITING COMMAND55 0 sleeping NT AUTHORITY\SYSTEM SIMIMX-SIF2 0 master AWAITING COMMAND56 0 sleeping NT AUTHORITY\SYSTEM SIMIMX-SIF2 0 master AWAITING COMMAND57 0 sleeping NT AUTHORITY\SYSTEM SIMIMX-SIF2 0 master AWAITING COMMANDas you would see, is to me system information that it`s sleeping, and i have more, near to 100 processes that appear daily, could you help me how clearing this proccesses, maybe with a period of time, thank a lot

Question of the Day for 15 Dec 2004

Site Owners — Tue, 16 Nov 2004 16:05:00 GMT

Comments posted to this topic are about the Question of the Day for 15 Dec 2004 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=396.

Question of the Day for 19 Mar 2004

Site Owners — Thu, 18 Mar 2004 16:05:00 GMT

Comments posted to this topic are about the Question of the Day for 19 Mar 2004 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=207.

Question of the Day for 19 Feb 2004

Site Owners — Wed, 18 Feb 2004 16:05:00 GMT

Comments posted to this topic are about the Question of the Day for 19 Feb 2004 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=185.

Question of the Day for 02 Apr 2007

Site Owners — Fri, 30 Mar 2007 20:05:00 GMT

Comments posted to this topic are about the Question of the Day for 02 Apr 2007 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=1003.

Question of the Day for 05 Jun 2007

Site Owners — Tue, 22 May 2007 16:05:00 GMT

Comments posted to this topic are about the Question of the Day for 05 Jun 2007 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=1049.

Question of the Day for 23 May 2007

Site Owners — Tue, 22 May 2007 08:05:00 GMT

Comments posted to this topic are about the Question of the Day for 23 May 2007 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=1046.

Question of the Day for 08 May 2007

Site Owners — Fri, 20 Apr 2007 18:05:00 GMT

Comments posted to this topic are about the Question of the Day for 08 May 2007 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=1029.

Question of the Day for 24 Apr 2007

Site Owners — Mon, 09 Apr 2007 12:05:00 GMT

Comments posted to this topic are about the Question of the Day for 24 Apr 2007 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=1018.

Question of the Day for 30 Mar 2007

Site Owners — Wed, 21 Mar 2007 20:05:00 GMT

Comments posted to this topic are about the Question of the Day for 30 Mar 2007 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=997.

Question of the Day for 26 Mar 2007

Site Owners — Wed, 21 Mar 2007 20:05:00 GMT

Comments posted to this topic are about the Question of the Day for 26 Mar 2007 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=996.

Question of the Day for 07 Mar 2007

Site Owners — Wed, 21 Feb 2007 10:05:00 GMT

Comments posted to this topic are about the Question of the Day for 07 Mar 2007 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=983.

Question of the Day for 01 Mar 2007

Site Owners — Wed, 21 Feb 2007 10:05:00 GMT

Comments posted to this topic are about the Question of the Day for 01 Mar 2007 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=981.

Question of the Day for 29 Jan 2007

Site Owners — Sun, 28 Jan 2007 12:05:00 GMT

Comments posted to this topic are about the Question of the Day for 29 Jan 2007 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=962.

Question of the Day for 24 Jan 2007

Site Owners — Tue, 23 Jan 2007 16:05:00 GMT

Comments posted to this topic are about the Question of the Day for 24 Jan 2007 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=959.

Question of the Day for 22 Dec 2006

Site Owners — Wed, 13 Dec 2006 18:05:00 GMT

Comments posted to this topic are about the Question of the Day for 22 Dec 2006 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=927.

Question of the Day for 07 Dec 2006

Site Owners — Mon, 04 Dec 2006 18:05:00 GMT

Comments posted to this topic are about the Question of the Day for 07 Dec 2006 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=923.

Question of the Day for 27 Sep 2006

Site Owners — Tue, 12 Sep 2006 12:05:00 GMT

Comments posted to this topic are about the Question of the Day for 27 Sep 2006 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=880.

Question of the Day for 28 Aug 2006

Site Owners — Thu, 24 Aug 2006 16:05:00 GMT

Comments posted to this topic are about the Question of the Day for 28 Aug 2006 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=846.

Question of the Day for 21 Jun 2006

Site Owners — Wed, 03 May 2006 12:05:00 GMT

Comments posted to this topic are about the Question of the Day for 21 Jun 2006 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=781.

Question of the Day for 26 Apr 2006

Site Owners — Tue, 25 Apr 2006 12:05:00 GMT

Comments posted to this topic are about the Question of the Day for 26 Apr 2006 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=758.

Question of the Day for 18 Apr 2006

Site Owners — Fri, 14 Apr 2006 16:05:00 GMT

Comments posted to this topic are about the Question of the Day for 18 Apr 2006 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=752.

Question of the Day for 22 Mar 2006

Site Owners — Wed, 15 Mar 2006 18:05:00 GMT

Comments posted to this topic are about the Question of the Day for 22 Mar 2006 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=735.

Question of the Day for 10 Mar 2006

Site Owners — Tue, 07 Mar 2006 12:05:00 GMT

Comments posted to this topic are about the Question of the Day for 10 Mar 2006 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=725.

Question of the Day for 10 Feb 2006

Site Owners — Mon, 06 Feb 2006 22:05:00 GMT

Comments posted to this topic are about the Question of the Day for 10 Feb 2006 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=706.

Question of the Day for 27 Jan 2006

Site Owners — Fri, 06 Jan 2006 20:05:00 GMT

Comments posted to this topic are about the Question of the Day for 27 Jan 2006 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=695.

Question of the Day for 26 Jan 2006

Site Owners — Fri, 06 Jan 2006 20:05:00 GMT

Comments posted to this topic are about the Question of the Day for 26 Jan 2006 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=693.

Question of the Day for 22 Dec 2005

Site Owners — Wed, 30 Nov 2005 16:05:00 GMT

Comments posted to this topic are about the Question of the Day for 22 Dec 2005 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=653.

Question of the Day for 16 Dec 2005

Site Owners — Tue, 13 Dec 2005 12:05:00 GMT

Comments posted to this topic are about the Question of the Day for 16 Dec 2005 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=669.

Question of the Day for 13 Dec 2005

Site Owners — Wed, 30 Nov 2005 16:05:00 GMT

Comments posted to this topic are about the Question of the Day for 13 Dec 2005 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=657.

Question of the Day for 01 Dec 2005

Site Owners — Wed, 30 Nov 2005 16:05:00 GMT

Comments posted to this topic are about the Question of the Day for 01 Dec 2005 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=654.

Question of the Day for 30 Nov 2005

Site Owners — Tue, 29 Nov 2005 16:05:00 GMT

Comments posted to this topic are about the Question of the Day for 30 Nov 2005 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=651.

Question of the Day for 08 Nov 2005

Site Owners — Thu, 27 Oct 2005 18:05:00 GMT

Comments posted to this topic are about the Question of the Day for 08 Nov 2005 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=639.

Question of the Day for 20 Oct 2005

Site Owners — Mon, 17 Oct 2005 16:05:00 GMT

Comments posted to this topic are about the Question of the Day for 20 Oct 2005 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=625.

Question of the Day for 17 Oct 2005

Site Owners — Tue, 11 Oct 2005 14:05:00 GMT

Comments posted to this topic are about the Question of the Day for 17 Oct 2005 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=623.

Question of the Day for 04 Oct 2005

Site Owners — Mon, 03 Oct 2005 18:05:00 GMT

Comments posted to this topic are about the Question of the Day for 04 Oct 2005 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=610.

Question of the Day for 22 Sep 2005

Site Owners — Tue, 20 Sep 2005 18:05:00 GMT

Comments posted to this topic are about the Question of the Day for 22 Sep 2005 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=602.

Question of the Day for 12 Sep 2005

Site Owners — Mon, 29 Aug 2005 22:05:00 GMT

Comments posted to this topic are about the Question of the Day for 12 Sep 2005 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=597.

Question of the Day for 25 Aug 2005

Site Owners — Tue, 16 Aug 2005 12:05:00 GMT

Comments posted to this topic are about the Question of the Day for 25 Aug 2005 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=590.