Database

OutputDebugString / Trace in SQL

1-Feb-09 8:27

Rob Graham wrote:
you could delete the rows as a join on the two tables

If you're referring to the T-SQL extension on DELETE statement, it won't delete rows on both tables. It's just another way to express where condition.

The need to optimize rises from a bad design.My articles[^]

Green Fuze31-Jan-09 10:31

31-Jan-09 10:31

Hey everybody

Does anyone have any idea how can I perform OutputDebugString (C#'s Trace) in SQL?
Is it event possible?

Thanks!

Wendelius31-Jan-09 10:36

31-Jan-09 10:36

It depends, where do you want the output to go?

If you simply want the output to the client calling SQL Server stored procedure, you could use PRINT[^]

The need to optimize rises from a bad design.My articles[^]

Green Fuze31-Jan-09 10:40

31-Jan-09 10:40

Hey,
Thanks for the quick reply!

I don't want to output to the calling app.
I want to print in DebugView (printing to the "output debug").

Wendelius31-Jan-09 10:51

31-Jan-09 10:51

Could you explain a little bit more:
- are you using Visual Studio or SQL Server Management Studio?
- then you call stored procedure?
- while the stored procedure executes you want to print something in the Output window in Visual Studio or Messages Window in Management Studio
- if using Visual Studio, are you running a program and debugging it or simply using Server Explorer while in design mode

The need to optimize rises from a bad design.My articles[^]

Green Fuze31-Jan-09 10:58

Re: OutputDebugString / Trace in SQL [modified]

31-Jan-09 10:58

I'm using SQL Server Management to write stored procedures.

Than, I'm running application that calls these stored procedures (I'm not running the application with debugger).

Just like you wrote, I want to print something to the output window - print to DebugView (what C++'s OutputDebugString() or C#'s Trace.Writeline() are doing).

Wendelius31-Jan-09 11:12

31-Jan-09 11:12

Okay, if you use PRINT in the stored procedure and execute the procedure in Management Studio, the output will come to the message window in Management Studio.

When you're executing an application which then calls a stored procedure, AFAIK there's no way to print any messages to a Management Studio window.

However, if you're using SqlConnection in the application, you can wire InfoMessage[^] event. Whatever you print in the procedure will come to this event and you can redirect it to the place you want.

Was this what you we're after?

If you want the output to the server side where SQL Server is running, you can:
- write the message to a table
- write it to the sqlserver log file
- write it to some other file
- send it using mail
- create a notification

The need to optimize rises from a bad design.My articles[^]

modified on Saturday, January 31, 2009 5:36 PM

Green Fuze31-Jan-09 21:43

31-Jan-09 21:43

Yeah,
Thanks a lot! Smile | :)

Wendelius1-Feb-09 7:05

1-Feb-09 7:05

You're welcome

The need to optimize rises from a bad design.My articles[^]

Mycroft Holmes1-Feb-09 14:23

Mycroft Holmes

1-Feb-09 14:23

Mika
Does the event fire on the print command in the proc or when the procedure comepletes?

Never underestimate the power of human stupidity
RAH

Wendelius1-Feb-09 18:11

1-Feb-09 18:11

Hi,

My first guess would be that when the execution completes, but I'll run few tests this evening since I'm not sure about asynchronous execution.

Mika

The need to optimize rises from a bad design.My articles[^]

Mycroft Holmes1-Feb-09 18:14

Mycroft Holmes

1-Feb-09 18:14

I have a few beast size procs that I may wire up for testing!

Never underestimate the power of human stupidity
RAH

Wendelius1-Feb-09 18:36

speed up read and write on access table with ado [modified]

1-Feb-09 18:36

Ok, what you could try is to use SqlCommand..::.BeginExecuteNonQuery Method (AsyncCallback, Object)[^]. Also wire the InfoMessage event. If you add print to the start of your proc you would be able to see if the InfoMessage fires before async execution is finished.

The need to optimize rises from a bad design.My articles[^]

sal2131-Jan-09 7:39

sal21

31-Jan-09 7:39

If i use ado and msacce mdb in c:\ all work fat but if i use the same code to read and write on md in \\myserver\mydir... all opertion are very very slow!!!!!
PLease "10 gold rules" to speed up operation on network !
Tks.

modified on Saturday, January 31, 2009 1:51 PM

Re: speed up read and write on access table with ado

Wendelius31-Jan-09 8:15

Re: speed up read and write on access table with ado

31-Jan-09 8:15

There's not much on your post to work with but few things you should check:

Is the connect slow. If the connect is slow, you should try to find a way to speed up finding the server and the share. Since you use names for server, perhaps DNS is responding slowly etc. Talk with the people responsible for your network. Also you can try to use IP-address instead of server name.

Slow selects, how much data do you transfer. If you need for example just one row in your application, do you fetch all rows from a table in database and then filter the data in the application. Always use the filtering abilities of the database. Also do not select columns you don't need.

Slow modifications, try to make all modifications at once. For example avoid situations where you first insert a row and then later update it. If you have such operations, prepare the data as much as you can before transfering it to the database.

Modeling, perhaps some operations are slow because of the data modeling. Review your relational model critically and for example eliminate duplicate data, normalize etc.

And of course check that the network is working correctly. For example copy a big file to that directory and see if it's copied in reasonable time.

The need to optimize rises from a bad design.My articles[^]

Rob Graham1-Feb-09 5:55

Rob Graham

1-Feb-09 5:55

There is little you can do other than use a different DBMS. Microsoft Access is a "file share" based database, as opposed to a server dbms, so all the data delivery is accomplished using the underlying file sharing. As a result, MSAccess is a real dog in any shared multi-user scenarios. (or even a single user network share scenario). Try converting the database to use Sql Server Express, MySql, Firebird, or any other server based dbms.

Report Builder - Reporting Services 2005

cbe_pav31-Jan-09 2:03

cbe_pav

31-Jan-09 2:03

Hi All...

Im a new to Report Builder - SQL reporting services 2005. I need to use a Query in Report builder to generate the reports.

Currently,im using a Single table to generate a report...

Is there any way to use more than one tables in Report Builder...

If its possible to use Query,Where do i ve to write it???

Any pls suggest some solution...

Thanks in Advance...

Damn database wizard!

Muammar©31-Jan-09 1:52

31-Jan-09 1:52

Hey,
Can you guide me in brief and tell me how can I make the simplest form of a master-details form using the boody .Net database wizard.. you know the add new data source thing from the data menu.. God, I feel really terrible about this when I thought I dont have to go through all the trouble doing it the hard way, the point is, how do you usually handle it people?? Am I the only one that spends about a week to get such a simple database form designed and working with update, insert and delete functions?? Isn't there any easy way to handle this??

For God's sake help me if you have any clue cuz it's getting me crazy!!

ps. Hi Mika $Shucks | :-\$

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Wendelius31-Jan-09 2:55

31-Jan-09 2:55

Hi,

I actually never use typed datasets since in my opinion they lack very much functionality when you want to do anything "more complex" (but I had to give it a try in this case Smile | :)

).

I understood that the problem isn't in creating the typed dataset, but how to build the form so that when you click on the first datagridview (or some other control) which represents the parent table, how to design the UI so that the child datagridview automatically shows the records corresponding to the selected parent row?

If that was correct, the trick is that when designing the second datagridview you define the datasource as the foreign key from the first binding source.

First bind the parent datagridview normally. Then when binding the child datagridview open the datasource combo and you should see a plus sign before the previously created bindingsource (for the parent datagridview) object. When you expand that, you should see the foreign key name defined in the typed dataset. Select it as datasource. After that you're able to select stuff from the child table and it should work.

The need to optimize rises from a bad design.My articles[^]

31-Jan-09 5:57

Thanks Mika, I should try that now and if it works, it is exactly what I need so thanks again mate Smile | :)

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Wendelius31-Jan-09 6:09

31-Jan-09 6:09

No problem Smile | :)

If you have time after testing it, drop a post and tell how it went.

The need to optimize rises from a bad design.My articles[^]

31-Jan-09 20:02

Hey Mika,
It's finally working! Thanks to you and a couple of modifications.. You know what, I think I'll have to share my experience in an article cuz it's a bit tricky to explain without pictures, I think what makes it difficult is that database I'm working with is Oracle God I'm sorry Mika but I think my bird is dying!! I'll let you know when I have this article ready!

Many thanks Mika.. Please pray for my bird Cry | :((

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Wendelius1-Feb-09 7:10

1-Feb-09 7:10

Muammar© wrote:
I think what makes it difficult is that database I'm working with is Oracle

Don't quite understand why it would be any more difficult than with SQL Server or any other database because you're still using datasets. Perhaps something in the data model?

Muammar© wrote:
I'll let you know when I have this article ready

That would be nice Smile | :)

Muammar© wrote:
Many thanks Mika..

No problem at all.

Muammar© wrote:
Please pray for my bird

I will!

The need to optimize rises from a bad design.My articles[^]