It's an old problem with a solution that's nearly as old. SQL Server MVP Jeff Moden shows us the old trick mixed with a slick trick to format the duration as extended hours, minutes, seconds, and milliseconds.
2015-04-03 (first published: 2014-01-16)
49,410 reads
This gives you info about blocking, head blocker,wait_type, duration of the queries that are currently running
2011-08-11 (first published: 2011-08-04)
2,222 reads
I have a very larre (and growing) table which contains a PK and another column of the type text.The text column contains XML, and I wish to search for the occurance of the various XML tags in the table.Currently I can use LIKE statements to pull out matches. Will I still be able to do this […]
2004-03-16
2004-03-16
http://www.sql-server-performance.com/sql_server_log_shipping.asp is a really good covering of this subject. I have based all my log shipping work on it with great success. I hope it helps. Regards from Paul
2004-03-16
2004-03-01
-- Be sure to declare variables output in -- the execute line of the batch... declare @input1 varchar(10) declare @input2 varchar(10) declare @output1 varchar(10) declare @output2 varchar(10) -- execute myProc @input1, @input2, @output1 output, @output2 output -- -- Here's the proc declaration... -- CREATE PROC myProc @input1 varchar(10) , @input2 varchar(10) , @output1 varchar(10) output […]
2003-08-18
You don't want the SUM in the percent part, plus you can't use aliases in the SUM expression...must use the full expression. If you don't want to do this repeatedly, check out computed columns in BOL: Sum([intquantity]*[curcost]) AS Cost, Sum([intquantity]*[curprice]) AS Price, sum(([intquantity]*[curPrice])-([intquantity]*[curcost]))AS Profit, ((sum(([intquantity]*[curPrice])-([intquantity]*[curcost]))/Sum([intquantity]*[curprice]))*10000)/100) AS [ProfitPercent] [/code]
2003-06-05
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers