Hemanth Damecharla

Interests: Operating Systems, Database Management Systems, Networks, Poetry.

Session complete status and estimated completion time

by Hemanth Damecharla

SQLServerCentral.com

SQL Server

A small retake on the popular percent complete script which tell how much more time an executing command will take.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3 (3)

Log in or register to rate

You rated this post out of 5. Change rating

2012-03-21 (first published: 2012-03-07)

1,579 reads

Discuss

Blogs

AI Step 1

By Vinay Thakur

As this is an Artificial Intelligence (AI) World, things are changing. We can see that...

Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend

By Ige Adetokunbo Temitayo

In a containerized app, React and Chakra UI provide a robust and accessible user...

A New Word: Nachlophobia

nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...

Read the latest Blogs

Forums

Call dynamic sql storedprocedure from SSIS execute sql task

hi, I have a table called Rules Create table Rules ( Id int ,...

Migrating database with many orphan users.

I am currently upgrading a very old database running SQL Server 2008 to SQL...

Active and Active Cluster

Hi Team, I am planning to apply security updates for SQL Server 2016 on...

Visit the forum

Question of the Day

The Funny SELECTs

What is returned from this query?

SELECT
  ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
    WHERE soh.OrderDate > '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2000
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
    WHERE soh.OrderDate > '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2001
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
    WHERE soh.OrderDate > '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2002;

See possible answers