Indepth SPID information
This SP gives you most of the detail you need on a long running query. Simply pass the SPID.
2009-01-12 (first published: 2008-12-31)
2,113 reads
sys.sysprocesses
RE: Proper Shutdown of SQL Servers in a Cluster
it's a .cmd file and I use shutdown.exe from the Resource Kit, though I'll be switching that to psshutdown because it honors the power down as well. It's manually executed by an administrator if needed. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-07-16
RE: Scheduling DTS Packages...
Hello Carl, quote: Any other ideas? are you able to figure out where the package hangs (AS400, DB Updates, eMail)? Cheers, Frank
2003-06-10
RE: Scheduling DTS Packages...
Be sure you don't have any interactive elements in the package. If so, it will stall waiting for input. Usually this is either a message box or an error with an "OK" Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-09
RE: SQL Time
select convert(time_challan,114) from tableA you've missed the first parameter of convert should be select convert(varchar,time_challan,114) from tableA
2003-06-07
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers