Question - Give me a minute of yours

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Question - Give me a minute of yours

Author

Topic

santosh2307
Starting Member

7 Posts

Posted - 2009-03-24 : 14:25:50

All Experts,

I have a basic question in SSRS.
Should we use the sql commands in the datasets or have stored procedures?

Which has more advantages?

Or
Is there any other way where we will have better performance and control.

Thanks for your time.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-03-24 : 14:41:28

This is a very old debate. I'm in the "stored procedure camp".

If you are interested in this very heated debate, I'd suggest googling it. It has been widely discussed.

It's not specific to SSRS, by the way. So don't put SSRS in your search.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

santosh2307
Starting Member

7 Posts

Posted - 2009-03-25 : 04:44:00

I have fair idea about the stored procedure advantages, but I specifically require the performance fo SPs in SSRS.

quote:
Originally posted by tkizer

This is a very old debate. I'm in the "stored procedure camp".

If you are interested in this very heated debate, I'd suggest googling it. It has been widely discussed.

It's not specific to SSRS, by the way. So don't put SSRS in your search.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-03-25 : 15:48:17

There is nothing specific about performance with stored procedures in SSRS. The debate applies to data access for all applications, including SSRS.

We use stored procedures in our reports, but then again I'm in the "stored procedure camp" for that debate.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-03-28 : 04:54:14

we also prefer using stored procedures rather than sql commands. Whenever some small changes come to query logic we can do it in stored procedure rather than tweaking each and every report query where the query is used. also common logic can be written in procedure which can be reused across several reports rather than repetition everywhere.

MaddCutty
Starting Member

1 Post

Posted - 2009-04-06 : 11:13:25

We use stored procedures for more complicated items and select statements for simple items. As usual there is no absolute rule where the cutoff between stored procedure and select statements.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-04-06 : 12:34:47

My cutoff rule is security. It is much more secure to use stored procedures.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

QAZAFI
Yak Posting Veteran

50 Posts

Posted - 2009-04-08 : 16:26:19

I am also with Stored procedure. I will give you one simple reason why I am, First Security but other important thing if you need to change in your select statement you have to deploy your reports back on server but in case of SP you dont need to. So thumb rule is Use SP
thanks
Qazafi Syed

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources