ASP.Net

Looking for some good examples of how folks used ASP.Net to pass in
parameters to SQL2005 Reporting Services - not liking how the parameters
have to be coded within the designer itself.We used a single string parameter and embedded an XML document within
that, translating it in a wrapping stored procedure to be the
parameters required by the real sp on the database.
This allowed us to do things like data driven parameters to the report
(in the ASP.Net web application we wrote as the front end)
Cheers
Greg
Joe wrote:
> Looking for some good examples of how folks used ASP.Net to pass in
> parameters to SQL2005 Reporting Services - not liking how the parameters
> have to be coded within the designer itself.|||I use stored procedures as the datasource and set the parameters with the
procedure variables. Using report parameters takes way too long on large data
sets from what I have experienced. All the data is loaded before the
filtering takes place (from what I was told).
"Joe" wrote:
> Looking for some good examples of how folks used ASP.Net to pass in
> parameters to SQL2005 Reporting Services - not liking how the parameters
> have to be coded within the designer itself.
>
>

article on the optimiser generating a query plan

Is there a nice article on where i can find out how the query optimiser
chooses a query plan and what kind a plan it might choose with some examples
?
Whether it may use nested loop joins or merge or hash , whether it will do a
table scan, Clustered Index scan or seek.,etc...Take a look at:
http://msdn.microsoft.com/library/default.asp?url=/nhp/default.asp?contentid=28000409
and
http://msdn.microsoft.com/library/default.asp?url=/nhp/default.asp?contentid=28000409
--
Hal Berenson, SQL Server MVP
True Mountain Group LLC
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uX8$UyFbDHA.1940@.TK2MSFTNGP10.phx.gbl...
> Is there a nice article on where i can find out how the query optimiser
> chooses a query plan and what kind a plan it might choose with some
examples
> ?
> Whether it may use nested loop joins or merge or hash , whether it will do
a
> table scan, Clustered Index scan or seek.,etc...
>|||The 2 URLs are the same. Is that a generic place u sent me to about SQL
Server or is there a specific article out there
"Hal Berenson" <haroldb@.truemountainconsulting.com> wrote in message
news:uIj1A3FbDHA.2024@.TK2MSFTNGP12.phx.gbl...
> Take a look at:
>
http://msdn.microsoft.com/library/default.asp?url=/nhp/default.asp?contentid=28000409
> and
>
http://msdn.microsoft.com/library/default.asp?url=/nhp/default.asp?contentid=28000409
> --
> Hal Berenson, SQL Server MVP
> True Mountain Group LLC
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:uX8$UyFbDHA.1940@.TK2MSFTNGP10.phx.gbl...
> > Is there a nice article on where i can find out how the query optimiser
> > chooses a query plan and what kind a plan it might choose with some
> examples
> > ?
> > Whether it may use nested loop joins or merge or hash , whether it will
do
> a
> > table scan, Clustered Index scan or seek.,etc...
> >
> >
>|||Superb... I havent read it though but it looks like what i was looking for.
When is part 8 due ? Do you have all that clubbed together somehow for an
easy print ?
Good Luck to u
"joe chang" <jchang6@.yahoo.com> wrote in message
news:0e5d01c36cb4$6583dec0$a601280a@.phx.gbl...
> http://www.sql-server-
> performance.com/jc_sql_server_quantative_analysis1.asp
>
> >--Original Message--
> >Is there a nice article on where i can find out how the
> query optimiser
> >chooses a query plan and what kind a plan it might choose
> with some examples
> >?
> >Whether it may use nested loop joins or merge or hash ,
> whether it will do a
> >table scan, Clustered Index scan or seek.,etc...
> >
> >
> >.
> >|||Hassan,
MS SQL Server Performance Tuning and Optimization for Developers, Part 2:
The Query Optimizer
http://www.microsoft.com/technet/prodtechnol/sql/maintain/optimize/dat411.asp?frame=true
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uX8$UyFbDHA.1940@.TK2MSFTNGP10.phx.gbl...
> Is there a nice article on where i can find out how the query optimiser
> chooses a query plan and what kind a plan it might choose with some
examples
> ?
> Whether it may use nested loop joins or merge or hash , whether it will do
a
> table scan, Clustered Index scan or seek.,etc...
>|||Is that good enough for SQL 2000 ? It says Tech-Ed 97.. Can you confirm ?
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:%23gjaEuNbDHA.2820@.tk2msftngp13.phx.gbl...
> Hassan,
> MS SQL Server Performance Tuning and Optimization for Developers, Part 2:
> The Query Optimizer
>
http://www.microsoft.com/technet/prodtechnol/sql/maintain/optimize/dat411.asp?frame=true
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:uX8$UyFbDHA.1940@.TK2MSFTNGP10.phx.gbl...
> > Is there a nice article on where i can find out how the query optimiser
> > chooses a query plan and what kind a plan it might choose with some
> examples
> > ?
> > Whether it may use nested loop joins or merge or hash , whether it will
do
> a
> > table scan, Clustered Index scan or seek.,etc...
> >
> >
>|||Hassan,
Except some basic stuff, I dont believe it holds good for SQL2000
considering the presentation date and the author not explictly stating the
SQL Server version.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:eKkSoMObDHA.1204@.TK2MSFTNGP12.phx.gbl...
> Is that good enough for SQL 2000 ? It says Tech-Ed 97.. Can you confirm ?
> "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> news:%23gjaEuNbDHA.2820@.tk2msftngp13.phx.gbl...
> > Hassan,
> >
> > MS SQL Server Performance Tuning and Optimization for Developers, Part
2:
> > The Query Optimizer
> >
>
http://www.microsoft.com/technet/prodtechnol/sql/maintain/optimize/dat411.asp?frame=true
> >
> > --
> > Dinesh.
> > SQL Server FAQ at
> > http://www.tkdinesh.com
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:uX8$UyFbDHA.1940@.TK2MSFTNGP10.phx.gbl...
> > > Is there a nice article on where i can find out how the query
optimiser
> > > chooses a query plan and what kind a plan it might choose with some
> > examples
> > > ?
> > > Whether it may use nested loop joins or merge or hash , whether it
will
> do
> > a
> > > table scan, Clustered Index scan or seek.,etc...
> > >
> > >
> >
> >
>|||This is a SQL Server 6.5 presentation and doesn't apply to SQL Server 7.0 or
2000.
The articles at
http://www.microsoft.com/technet/prodtechnol/sql/maintain/optimize/sql7qp.asp
and
http://msdn.microsoft.com/library/en-us/dnsql7/html/sqlquerproc.asp
were written for SQL Server 7.0 but are 90% accurate for SQL Server 2000 as
well.
--
Hal Berenson, SQL Server MVP
True Mountain Group LLC
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:eKkSoMObDHA.1204@.TK2MSFTNGP12.phx.gbl...
> Is that good enough for SQL 2000 ? It says Tech-Ed 97.. Can you confirm ?
> "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> news:%23gjaEuNbDHA.2820@.tk2msftngp13.phx.gbl...
> > Hassan,
> >
> > MS SQL Server Performance Tuning and Optimization for Developers, Part
2:
> > The Query Optimizer
> >
>
http://www.microsoft.com/technet/prodtechnol/sql/maintain/optimize/dat411.asp?frame=true
> >
> > --
> > Dinesh.
> > SQL Server FAQ at
> > http://www.tkdinesh.com
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:uX8$UyFbDHA.1940@.TK2MSFTNGP10.phx.gbl...
> > > Is there a nice article on where i can find out how the query
optimiser
> > > chooses a query plan and what kind a plan it might choose with some
> > examples
> > > ?
> > > Whether it may use nested loop joins or merge or hash , whether it
will
> do
> > a
> > > table scan, Clustered Index scan or seek.,etc...
> > >
> > >
> >
> >
>