percent of executed procedure

rozrabiak

Hi!

How can I get percent of executed procedure in MSSQL Server, lik in
Enterprise Manager and/or dbMgr2k ?

I use Visual C# and MSDE.

Thank's for help, gregory

Jul 20 '05 #1

Subscribe Post Reply

1454

Erland Sommarskog

rozrabiak (br**@maila.pl) writes:

How can I get percent of executed procedure in MSSQL Server, lik in
Enterprise Manager and/or dbMgr2k ?

That is very difficult to achieve. Of course, if your doing some iterative
processing, and first count the number of rows you are to process, then
it is not that difficult:

RAISERROR('Processing row %d of a total of %d rows', 0, 1, @row, @tot)
WITH NOWAIT

WITH NOWAIT prevents the message from being buffered.

But normally you should endulge in iterative processing, but use
set-based logic since in very most cases this gives superiour performance.
But in this case there is not away to wrestle progress information from
SQL Server.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Jul 20 '05 #2

by: vishal | last post by:

Hi, I am writing my first script to execute a Oracle procedure through a unix script. Could you tell me how do I do error handling here? How do I know in my script if the procedure executed...

Oracle Database

percent of executed procedure

by: rozrabiak | last post by:

Hi! How can I get percent of executed procedure in MSSQL Server, lik in Enterprise Manager and/or dbMgr2k ? I use Visual C# and MSDE. Thank's for help, gregory

Microsoft SQL Server

sql alert percent log used

by: orauser | last post by:

hi, i want to create a generic alert which scan the percent log used for the databases; when i'm doing this, i can select one database or 'total' using enterprise manager. When i have an alert,...

Microsoft SQL Server

calculating a percent of total in a query

by: mhodkin | last post by:

I created a query in which I have grouped data by City. I wish to calculate the percent of each value, e.g. City/(Total count of all Cities), in tbe next column of the query. I can't seem to...

Microsoft Access / VBA

Percent of executed procedure..

by: rozrabiak | last post by:

Hi! How can I get percent of executed procedure in MSSQL Server, lik in Enterprise Manager and/or dbMgr2k ? I use Visual C# and MSDE. Thank's for help, gregory

C# / C Sharp

Percent of what? A proposal

by: VidTheKid | last post by:

THE PROBLEM The % symbol is too vague when defining dimensions in CSS and HTML. It can relate to an inherited value, a measure of the containing element (which can differ between box models) or...

HTML / CSS

Weird situation - Stored procedure executed twice

by: Chris | last post by:

In SQL 2005 I have a stored procedure as below: @sub_no smallint OUTPUT BEGIN BEGIN TRANSACTION INSERT...INTO

Microsoft SQL Server

what are the memory caps for threads running as a CLR stored procedure executed by sql server 2005? is it limited by OS only or also by sql servers memory limits? e.g. lets say my clr stored procedure is executed by sql server 2005 then it creates 10

by: DR | last post by:

what are the memory caps for threads running as a CLR stored procedure executed by sql server 2005? is it limited by OS only or also by sql servers memory limits? e.g. lets say my clr stored...

.NET Framework

Finding top x percent of data

by: nycjay | last post by:

I am trying to do the following w/ SQL for db2 9... I want to find the top x percent of rows. For example, if i wanted to find the average sale price of the top 10 most expensive items in a store,...

DB2 Database

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Similar topics