rda submitsql: based

Showing posts with label based. Show all posts

Wednesday, March 28, 2012

raid 5 v raid 10

We are looking to run a web based CRM package that runs on SQL 2005.
It has been recommend that we set the it up with RAID 5 however on
reading up on this it looks like RAID 10 could be better option.
The hard ware spec so far is for RAID 5
2 * 72.6 GB Hard Drives for the operating system
3 * 146.8 GB Hard Drives the database.
If were to go for RAID 10, as to requires equal number of drives I
presume that we would need to up it from 3 to 4.
What are other peoples experiences/viewsIf you have over 20% of your IO activity is write based IO you will get
better performance with RAID 10. While RAID 5 is more expensive than RAID
10 typically the performance gains offset this added cost.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"jp" <jeremypw@.googlemail.com> wrote in message
news:1168248735.954175.305990@.s34g2000cwa.googlegroups.com...
> We are looking to run a web based CRM package that runs on SQL 2005.
> It has been recommend that we set the it up with RAID 5 however on
> reading up on this it looks like RAID 10 could be better option.
> The hard ware spec so far is for RAID 5
> 2 * 72.6 GB Hard Drives for the operating system
> 3 * 146.8 GB Hard Drives the database.
> If were to go for RAID 10, as to requires equal number of drives I
> presume that we would need to up it from 3 to 4.
> What are other peoples experiences/views
>|||"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23Uzk0HxMHHA.5012@.TK2MSFTNGP02.phx.gbl...
> If you have over 20% of your IO activity is write based IO you will get
> better performance with RAID 10. While RAID 5 is more expensive than RAID
> 10 typically the performance gains offset this added cost.
Uh, I think you mean while RAID 5 is LESS expensive than RAID 10?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "jp" <jeremypw@.googlemail.com> wrote in message
> news:1168248735.954175.305990@.s34g2000cwa.googlegroups.com...
>> We are looking to run a web based CRM package that runs on SQL 2005.
>> It has been recommend that we set the it up with RAID 5 however on
>> reading up on this it looks like RAID 10 could be better option.
>> The hard ware spec so far is for RAID 5
>> 2 * 72.6 GB Hard Drives for the operating system
>> 3 * 146.8 GB Hard Drives the database.
>> If were to go for RAID 10, as to requires equal number of drives I
>> presume that we would need to up it from 3 to 4.
>> What are other peoples experiences/views
>|||Hi,
Well, actually, RAID 10 could outperform RAID 5, especially because of
that CRM uses a lot of random writes which is the black point of RAID 5
level.
The theory is the following, assuming you have n similar disks :
RAID 5 Write time : 1/(n-1)
RAID 10 Write time : 1/(n/[number of disks per RAID 1 set])
RAID 5 Read time : 1/(n-1)
RAID 10 Read time : 1/n
RAID 5 fault tolerance : 1 disk
RAID 10 fault tolerance : [number of RAID 0 sets] * ([number of disks
per RAID 1 set] - 1)
Nevertheless, this is only theory... And here are some of the problems
in the real life :
- While updating small sets of data (just as you might do in a CRM
application), you make a random write... Thus, in RAID 5, the
controller has to re-read the entire stripe to write the parity blocks.
Which dramatically brings down the RAID 5 performances... As you double
the theorical write time...
- While inserting large amounts of data, you make a sequential write...
Thus RAID 5 would be much more efficient than any other RAID level,
assuming you need fault tolerance.
- While reading either small sets of data or large amounts of data,
RAID 5 is a little bit slower than RAID 10...
- RAID 5 loses much less disk capacity than RAID 10, and as so is much
cheaper.
In conclusion you might use RAID 10 if your application needs a lot of
random writes... However, as a matter of cost, I would recommand you to
keep RAID 5 and to add a third set of drives to store transaction logs.
In many cases I've came accross, the I/O bottleneck raises because of
the usage of the same set of disks for data and transaction log... As
RAID 5 wouldn't have been a real problem...
C=E9dric Del Nibbio
MCSD .NET
MCTS SQL Server 2005
http://cedric-delnibbio-sql.blogspot.com
jp a =E9crit :
> We are looking to run a web based CRM package that runs on SQL 2005.
> It has been recommend that we set the it up with RAID 5 however on
> reading up on this it looks like RAID 10 could be better option.
> The hard ware spec so far is for RAID 5
> 2 * 72.6 GB Hard Drives for the operating system
> 3 * 146.8 GB Hard Drives the database.
> If were to go for RAID 10, as to requires equal number of drives I
> presume that we would need to up it from 3 to 4.
> > What are other peoples experiences/views|||Thanks Strider - you're right - RAID 10 has a minimum of 4 drives and 50%
utilization. RAID 5 needs a minimum of 3 drives with n-1 utilization.
So RAID 5 is cheaper.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:u1D1dLyMHHA.2456@.TK2MSFTNGP06.phx.gbl...
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%23Uzk0HxMHHA.5012@.TK2MSFTNGP02.phx.gbl...
>> If you have over 20% of your IO activity is write based IO you will get
>> better performance with RAID 10. While RAID 5 is more expensive than
>> RAID 10 typically the performance gains offset this added cost.
>
> Uh, I think you mean while RAID 5 is LESS expensive than RAID 10?
>
>> --
>> Hilary Cotter
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>>
>> "jp" <jeremypw@.googlemail.com> wrote in message
>> news:1168248735.954175.305990@.s34g2000cwa.googlegroups.com...
>> We are looking to run a web based CRM package that runs on SQL 2005.
>> It has been recommend that we set the it up with RAID 5 however on
>> reading up on this it looks like RAID 10 could be better option.
>> The hard ware spec so far is for RAID 5
>> 2 * 72.6 GB Hard Drives for the operating system
>> 3 * 146.8 GB Hard Drives the database.
>> If were to go for RAID 10, as to requires equal number of drives I
>> presume that we would need to up it from 3 to 4.
>> What are other peoples experiences/views
>>
>|||Theoretical pros and cons aside, whether or not you need a three-plus-drive
RAID5 or a four-plus-drive RAID10 should be determined by the I/O
requirements of your app(s), and that only you or your app folks can answer.
You can look at some of your previous perfmon counters for clue.
Alternatively, you can run some tests to get an even more accurate estimate.
It's possisle that RAID5 can provide sufficient I/O throughput to meet your
requirements.
Linchi
"jp" wrote:
> We are looking to run a web based CRM package that runs on SQL 2005.
> It has been recommend that we set the it up with RAID 5 however on
> reading up on this it looks like RAID 10 could be better option.
> The hard ware spec so far is for RAID 5
> 2 * 72.6 GB Hard Drives for the operating system
> 3 * 146.8 GB Hard Drives the database.
> If were to go for RAID 10, as to requires equal number of drives I
> presume that we would need to up it from 3 to 4.
> What are other peoples experiences/views
>|||for writing process Raid 5 is MORE expensive from performance point of view
;-)
not from a money point of view where Raid 5 is cheaper then raid 10 for the
same usable disk space. (3 disks in raid 5 = 4 disks in Raid 10, so cheaper
for the same space but less performance)
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:u1D1dLyMHHA.2456@.TK2MSFTNGP06.phx.gbl...
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%23Uzk0HxMHHA.5012@.TK2MSFTNGP02.phx.gbl...
>> If you have over 20% of your IO activity is write based IO you will get
>> better performance with RAID 10. While RAID 5 is more expensive than
>> RAID 10 typically the performance gains offset this added cost.
>
> Uh, I think you mean while RAID 5 is LESS expensive than RAID 10?
>
>> --
>> Hilary Cotter
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>>
>> "jp" <jeremypw@.googlemail.com> wrote in message
>> news:1168248735.954175.305990@.s34g2000cwa.googlegroups.com...
>> We are looking to run a web based CRM package that runs on SQL 2005.
>> It has been recommend that we set the it up with RAID 5 however on
>> reading up on this it looks like RAID 10 could be better option.
>> The hard ware spec so far is for RAID 5
>> 2 * 72.6 GB Hard Drives for the operating system
>> 3 * 146.8 GB Hard Drives the database.
>> If were to go for RAID 10, as to requires equal number of drives I
>> presume that we would need to up it from 3 to 4.
>> What are other peoples experiences/views
>>
>|||Thanks for the info
Linchi Shea wrote:
> Theoretical pros and cons aside, whether or not you need a three-plus-drive
> RAID5 or a four-plus-drive RAID10 should be determined by the I/O
> requirements of your app(s), and that only you or your app folks can answer.
> You can look at some of your previous perfmon counters for clue.
> Alternatively, you can run some tests to get an even more accurate estimate.
> It's possisle that RAID5 can provide sufficient I/O throughput to meet your
> requirements.
> Linchi
> "jp" wrote:
> > We are looking to run a web based CRM package that runs on SQL 2005.
> > It has been recommend that we set the it up with RAID 5 however on
> > reading up on this it looks like RAID 10 could be better option.
> >
> > The hard ware spec so far is for RAID 5
> > 2 * 72.6 GB Hard Drives for the operating system
> > 3 * 146.8 GB Hard Drives the database.
> >
> > If were to go for RAID 10, as to requires equal number of drives I
> > presume that we would need to up it from 3 to 4.
> >
> > What are other peoples experiences/views
> >
> >|||Thanks for the info
Linchi Shea wrote:
> Theoretical pros and cons aside, whether or not you need a three-plus-drive
> RAID5 or a four-plus-drive RAID10 should be determined by the I/O
> requirements of your app(s), and that only you or your app folks can answer.
> You can look at some of your previous perfmon counters for clue.
> Alternatively, you can run some tests to get an even more accurate estimate.
> It's possisle that RAID5 can provide sufficient I/O throughput to meet your
> requirements.
> Linchi
> "jp" wrote:
> > We are looking to run a web based CRM package that runs on SQL 2005.
> > It has been recommend that we set the it up with RAID 5 however on
> > reading up on this it looks like RAID 10 could be better option.
> >
> > The hard ware spec so far is for RAID 5
> > 2 * 72.6 GB Hard Drives for the operating system
> > 3 * 146.8 GB Hard Drives the database.
> >
> > If were to go for RAID 10, as to requires equal number of drives I
> > presume that we would need to up it from 3 to 4.
> >
> > What are other peoples experiences/views
> >
> >

Monday, March 26, 2012

radius search

I have latitude and longitude in my database, can anyone give me an sql query how I can make radius search based on that?

I don't understand what you mean by "radius search" exactly. What is your input and what is your desired output?|||

Thanks for your reply. I am trying to realize a distance serach based on an entered zip code.
MyTable: has fields: ID, Zip,Lat,Long

Assuming user entered UserZip=26511 and UserRadius=5miles. If these are parameters
for my stored procedure, how should I write my stored procedure to return all
the IDs that meet this criteria.

|||

Depends on how accurate you want the result to be. I'll assume that a margin of error of 10% is acceptable in your case. So if you say 10 miles, it will include all zips between 0 and 9 miles away, some zips that are between 9 and 11, and none that are 11 and over. Accurate enough for find all (somethings) within x miles of me type queries without killing the database server with complex math formulas.

SELECT t1.ID

FROM MyTable t1

JOIN MyTable t2 ON (sqrt(square(69.1*(t2.lat-t1.lat))+square(53.0*(t2.long-t1.long)))<@.Distance)

WHEREt2.Zip=@.StartZip

For highly accurate results, use this:

SELECT t1.ID

FROM MyTable t1

JOIN MyTable t2 ON (3963.0*acos(sin(t1.lat/(180/PI())) * sin(t2.lat/(180/PI())) + cos(t1.lat/(180/PI())) * cos(t2.lat/(180/PI())) * cos(t2.long/(180/PI())-t1.long/(180/PI())))<@.Distance)

WHEREt2.Zip=@.StartZip

The second formula makes the assumption that the earth is a perfect sphere (it's really closer to an oblate spheroid) that has a radius of 3963.0 miles. If you need something more accurate than that (I don't know why you would), let me know and I'll post it up for you, but be warned, it'll probably kill your SQL Server trying to calculate it in real time against 100,000 zip codes.

|||Thanks.sql

Wednesday, March 21, 2012

R

Hello -

I have a report based on a query that currently uses the = operator and I'd like to change it to the LIKE operator and allow a wildcard...using the %.

So...from something like, "....WHERE zipcode = @.ZipCode" to "...WHERE zipCode = @.zipCode plus the wildcard character.

Is this possible?

Thanks,

- will

You cannot do it direcly from query , You can write procedure and then call this procedure from report.

alter procedure TestReport(

@.param varchar(20)

)

declare @.SQLstring as nvarchar(200)

set @.SQLstring='select getdate() where zipcode like ''%'+@.zipcode+'%'''

exec sp_executesql @.SQLstring;

|||

Will Durning wrote:

Hello -
I have a report based on a query that currently uses the = operator and I'd like to change it to the LIKE operator and allow a wildcard...using the %.
So...from something like, "....WHERE zipcode = @.ZipCode" to "...WHERE zipCode = @.zipCode plus the wildcard character.
Is this possible?
Thanks,
- will

You can very well achieve this in the query itself. Eg: select * from <table-name> where <column-name> like '%' + @.column-name + '%'

|||

Thanks for the replies.

I ended up using a stored procedure and just concatenate the '%' to the incoming parameter. I could not get it to work with an inline sql query in my report....and besides, I was planning on using stored procs anyway.

Friday, March 9, 2012

Quick select statement question

hi all

another easy one

how would i write it to where i select a value = 0 where all are equal to 0 rather than one line. when selecting based off a key from another table how would i select the values that all bring back 0 for that key rather than just a line or 2? i hope that makes sense, lol.What have you come up with so far?|||select case when exists(select * from MyTable where MyValue <> 0) then 1 else 0 end|||SELECT dbo.tPA00175.chrJobNumber, dbo.tPA00175.intJobKey, dbo.tPA00125.numQuantityToInv
FROM dbo.tPA00125 INNER JOIN
dbo.tPA00175 ON dbo.tPA00125.intJobKey = dbo.tPA00175.intJobKey
WHERE (dbo.tPA00125.numQuantityToInv = 0)

but this is only selecting the single values...id like to select the ones that have all 0's for the particular jobkey|||How about:

select dbo.tPA00175.chrJobNumber,
dbo.tPA00175.intJobKey,
numQuantityToInv = 0
from dbo.tPA00175 inner join (select intJobKey
from dbo.tPA00125
group by intJobKey
having max(case when numQuantityToInv = 0 then 0 else 1 end) = 0
) as t2 on dbo.tPA00175.intJobKey = t2.intJobKey|||thanks, that works nicely

Wednesday, March 7, 2012

Quick Question

hello I am trying to use the reportviewer control in a custom web app.
Currently using a frame based design where I have a treeview of all the
reports available and a click on the individual report should open the
reportviewer control in another frame.
Currently facing issues passing the exact URL.
here is how my base URL
newNode.NavigateUrl = "http://server-name/reportserver?" & cirep.Path &
"
Trying passing target but without much luck. Anyway knows how to do it
?
Thanx.
Q2 I know that using frames is generally not preferred.
is there a better way to achieve what i am trying to accomplish with a
treeview or a menu on the Left side and the reportviewer showing up on
the right side ?
Thx
RaviSince frames really aren't supported by the gui in visual studio, I
generally just put the nav and the data on the same page. Network speeds
what they are, it shouldn't be an issue.
Mike G.
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1109019748.507926.276380@.c13g2000cwb.googlegroups.com...
> hello I am trying to use the reportviewer control in a custom web app.
> Currently using a frame based design where I have a treeview of all the
> reports available and a click on the individual report should open the
> reportviewer control in another frame.
> Currently facing issues passing the exact URL.
> here is how my base URL
> newNode.NavigateUrl = "http://server-name/reportserver?" & cirep.Path &
> "
> Trying passing target but without much luck. Anyway knows how to do it
> ?
> Thanx.
> Q2 I know that using frames is generally not preferred.
> is there a better way to achieve what i am trying to accomplish with a
> treeview or a menu on the Left side and the reportviewer showing up on
> the right side ?
> Thx
> Ravi
>|||you mean something like using a table or
using different dataregions or rectangles ?|||I mean just putting the report viewer control in an html table.
Mike G.
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1109025325.041436.297720@.g14g2000cwa.googlegroups.com...
> you mean something like using a table or
> using different dataregions or rectangles ?
>|||Hello Mike,
Thanks for the info. This is what I am trying to do.
I want a treeview as the navigation on the left and the reportviewer
next to it.
But the issue i am facing is that when I use a treeview, I set the
values to the treeviewnode.navigateUrl and I click on the link to a
report, it is rendering on the whole page.
But When I use a dropdown menu I could make it render to a certain
region like a cell in a Html table. good thing about the dropdown menu
is that there is OnClick Event which I dont seem to have in the
treeview control I downloaded from the Asp.net web controls.
Any hints on how to go about ?
Thankx very much
Ravi|||(Hmmm. I thought I replied to this yesterday, but I don't see it now.
Sorry if this is a dup response.)
I'm not sure I understand how you are rendering the report. Are you
redirecting to a url, using the render method...? Also, do you know about
the report viewer control?
Mike G.
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1109038650.929162.40500@.c13g2000cwb.googlegroups.com...
> Hello Mike,
> Thanks for the info. This is what I am trying to do.
> I want a treeview as the navigation on the left and the reportviewer
> next to it.
> But the issue i am facing is that when I use a treeview, I set the
> values to the treeviewnode.navigateUrl and I click on the link to a
> report, it is rendering on the whole page.
> But When I use a dropdown menu I could make it render to a certain
> region like a cell in a Html table. good thing about the dropdown menu
> is that there is OnClick Event which I dont seem to have in the
> treeview control I downloaded from the Asp.net web controls.
> Any hints on how to go about ?
> Thankx very much
> Ravi
>|||I am using the reportviewer control. It may sound stupid but my exact
problem has been how do I tie the reportviewer control to a node in the
treeview.
I am using the treenode.navigateUrl property to set the url, which is
causing it to render it all over the screen.
I dont have this problem when I use a dropdown menu of reports and a Go
button. I use the Onclick event of the go button to set the properties
to the reportviewer control.
Thx
Ravi|||Ok, so you're passing the url of the report to the treeview control?
Instead, the navigateurl should be to the same page (like a postback) and
set the querystring to be the value of the report you're trying to view
(navigateurl = samepage.aspx?report=" & reportvar). (of course, instead of
a querystring you could use the viewstate object or a session object or
.... ) On the load event of the page, check if there is a value in the
querystring, and if so set the property of the reportviewer.
Was that vague enough?
Mike G.
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1109087785.988437.208740@.o13g2000cwo.googlegroups.com...
>I am using the reportviewer control. It may sound stupid but my exact
> problem has been how do I tie the reportviewer control to a node in the
> treeview.
> I am using the treenode.navigateUrl property to set the url, which is
> causing it to render it all over the screen.
> I dont have this problem when I use a dropdown menu of reports and a Go
> button. I use the Onclick event of the go button to set the properties
> to the reportviewer control.
> Thx
> Ravi
>|||Hey Mike,
here is the URL i am passing to the navigateUrl property of the
Treenodes.
This posts the report to the same page. But it doesnt render in the
reportviewer control object I have in a html table in the same page,
which i am trying to achieve.
http://servername/reportserver?/folder/report1&rs:Command=Render&rc:zoom=75&rc:toolbar=true
thx
ravi|||Maybe I don't understand: How are you rendering the report? It sounds like
you are either redirecting the user to the report page or using the render
method of the web service?
Do you know about the asp.net report viewer control?
Mike
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1109038650.929162.40500@.c13g2000cwb.googlegroups.com...
> Hello Mike,
> Thanks for the info. This is what I am trying to do.
> I want a treeview as the navigation on the left and the reportviewer
> next to it.
> But the issue i am facing is that when I use a treeview, I set the
> values to the treeviewnode.navigateUrl and I click on the link to a
> report, it is rendering on the whole page.
> But When I use a dropdown menu I could make it render to a certain
> region like a cell in a Html table. good thing about the dropdown menu
> is that there is OnClick Event which I dont seem to have in the
> treeview control I downloaded from the Asp.net web controls.
> Any hints on how to go about ?
> Thankx very much
> Ravi
>|||This is more of an asp.net question than reporting services, but the url
you're passing to the treeview tells it where to navigate. You're telling
it to navigate away from your page and to the report page. Instead, the
link should be closer to:
http://server/path/nameofcurrentpage.aspx?report=report1
you then have to have code on nameofcurrentpage.aspx that retrieves the
value from the querystring and changes the property of the report viewer
control appropriately.
For more info, look for docs on querystrings in asp.net.
Mike G.
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1109090642.640699.254080@.l41g2000cwc.googlegroups.com...
> Hey Mike,
> here is the URL i am passing to the navigateUrl property of the
> Treenodes.
> This posts the report to the same page. But it doesnt render in the
> reportviewer control object I have in a html table in the same page,
> which i am trying to achieve.
> http://servername/reportserver?/folder/report1&rs:Command=Render&rc:zoom=75&rc:toolbar=true
> thx
> ravi
>|||You can do what you want using a combination of a modified ReportViewer
control and the rc:ReplacementRoot parameter. You can see where we came up
with this idea here:
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/fc71a51d020123ed/a295a0d77da59b6c?q=replacementroot&_done=%2Fgroup%2Fmicrosoft.public.sqlserver.reportingsvcs%2Fsearch%3Fgroup%3Dmicrosoft.public.sqlserver.reportingsvcs%26q%3Dreplacementroot%26qt_g%3D1%26&_doneTitle=Back+to+Search&&d#a295a0d77da59b6c
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1109019748.507926.276380@.c13g2000cwb.googlegroups.com...
> hello I am trying to use the reportviewer control in a custom web app.
> Currently using a frame based design where I have a treeview of all the
> reports available and a click on the individual report should open the
> reportviewer control in another frame.
> Currently facing issues passing the exact URL.
> here is how my base URL
> newNode.NavigateUrl = "http://server-name/reportserver?" & cirep.Path &
> "
> Trying passing target but without much luck. Anyway knows how to do it
> ?
> Thanx.
> Q2 I know that using frames is generally not preferred.
> is there a better way to achieve what i am trying to accomplish with a
> treeview or a menu on the Left side and the reportviewer showing up on
> the right side ?
> Thx
> Ravi
>|||Hello jeff,
I have modified the reportviewer code adding your code and created the
new dll.
I also added the rc:ReplacementRoot = MyIframe in the Build URl string
method.
Do I need to do that ?
But when I actually ran the app with the new reportviewer DLL (removed
the old and added new reference to reportviewer, just to be sure) it is
still opening the drillthrough reports in a different Browser window.
And I dont see the rc:replacementroot part in the URL of the
drillthrough.
Am i missing anything ?
Thanks
Ravi|||Sorry it took so long to get back to you. I answered these questions in
another thread.
By the way, there's not a need to start all these new threads for the same
issue! Now others will have a difficult time finding the answer to your
question, since you started so many different threads on this same issue.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1109276158.622182.138890@.f14g2000cwb.googlegroups.com...
> Hello jeff,
> I have modified the reportviewer code adding your code and created the
> new dll.
> I also added the rc:ReplacementRoot = MyIframe in the Build URl string
> method.
> Do I need to do that ?
> But when I actually ran the app with the new reportviewer DLL (removed
> the old and added new reference to reportviewer, just to be sure) it is
> still opening the drillthrough reports in a different Browser window.
> And I dont see the rc:replacementroot part in the URL of the
> drillthrough.
> Am i missing anything ?
> Thanks
> Ravi
>

Quick DMX question

Is there anyway to predict what a customer is likely to buy based on their purchase history?

What I would like to do is something simliar to using a natural prediction join with multiple union selects, but with data supplied from my purchases table.

So I need something like this:

Code Snippet

Openquery([ds], 'SELECT DISTINCT [PurchasedProductID] FROM [Table] WHERE [CompanyName] = 'a')

To work like how this works:

Code Snippet

(SELECT (SELECT '1234' AS [ProductID] UNION SELECT '12345' AS [ProductID]) AS [Table])

Thanks!

You can try this:
... <Model> NATURAL PREDICTION JOIN
SHAPE {
OPENQUERY([DS], 'SELECT ''A'' AS CompanyName')
} APPEND
( {
Openquery([ds], 'SELECT DISTINCT [CompanyName], [PurchasedProductID] FROM [Table] WHERE [CompanyName] = ''a'' ')
} RELATE [CompanyName] TO [CompanyName]
) AS [Table]
AS T

Note the "fake" top level row (the first query) which just serves as foreign key to group the entries in the nested (APPEND) statement|||wow! It works! Thanks so much!

Quick custom security question

I am trying to implement some type of security based on the user, the
report, and what parameters the are supplying.
So lets say that I have a report called "Salary Report" that shows
employees salary and bonus data. The people who can run the report
with Department = 1 are not allowed to run the report as Department = 2.
Previously I believe the answer was to use the "UserId" in my reports,
which would be populated with the current users Username, but we
already have a very complex system for determining peoples rights to
different things on our intranet site.
People can delegate rights to others, people get rights based on their
project assignments, people get rights based on their position in the
company, people get rights based on who they report to, and who reports
to them, and on and on.
So all I need to know to validate is username (or userID), what report
they are running, and what parameters they are supplying.
Is there any way to do this?Would a query based parameter work for you where you use a stored procedure
to return a list of valid parameters that they can use for that report based
on who they are and what rights they have inherrited?
Steve MunLeeuw
"cmay" <cmay@.walshgroup.com> wrote in message
news:1161293948.030847.304270@.m73g2000cwd.googlegroups.com...
>I am trying to implement some type of security based on the user, the
> report, and what parameters the are supplying.
> So lets say that I have a report called "Salary Report" that shows
> employees salary and bonus data. The people who can run the report
> with Department = 1 are not allowed to run the report as Department => 2.
> Previously I believe the answer was to use the "UserId" in my reports,
> which would be populated with the current users Username, but we
> already have a very complex system for determining peoples rights to
> different things on our intranet site.
> People can delegate rights to others, people get rights based on their
> project assignments, people get rights based on their position in the
> company, people get rights based on who they report to, and who reports
> to them, and on and on.
> So all I need to know to validate is username (or userID), what report
> they are running, and what parameters they are supplying.
> Is there any way to do this?
>

Monday, February 20, 2012

Questions using RS2005

I have two questions. Both of my questions are based on my experiences
briefly using RS2000. First, has RS2005 managed to fix the problem with
returning large (average 50K) records without eating up all the server
resources or even crashing the server. This happened when I was using RS2000
regardless if I was using paging feature like returning partial records at a
time. I've called MS and the support person told me that RS2000 was not
meant to return more than 10k records. I thought that was stranged but I
kind of understand. Have this issue been resolved in RS2005? Or do I
continue using Crystal Reports..
Second question is regarding dataset being pass from asp.net. In RS2000,
there was no way to pass dataset from asp.net to RS2000. I know few people
in the past have created their own customize dataset (Teo Lachev is one) to
be able to pass datasets (not rs2000 dataset but, dataset in asp.net/
vb.net). Have RS2005 added this feature? Thanks in advance.
HenryRS 2005 has not changed how it is managing rendering. Rendering is done in
memory which is why the problem returning 50,000 records IF rendering to PDF
or Excel. Rendering this size in HTML or CSV is not a problem (in either RS
2000 or 2005). If this is your reason to stay away then you either need to
consider CSV (this many records is not for human consumption, it is a data
export and CSV works well for that).
Second, VS 2005 comes with two new controls that you can run in either local
mode or server mode. In local mode you give it a dataset. Note that in local
mode you have to do more work (handling sub reports etc).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Henry" <Henry@.discussions.microsoft.com> wrote in message
news:8AE7E99E-1E90-4DA7-B8BC-8AF03BE80BE7@.microsoft.com...
>I have two questions. Both of my questions are based on my experiences
> briefly using RS2000. First, has RS2005 managed to fix the problem with
> returning large (average 50K) records without eating up all the server
> resources or even crashing the server. This happened when I was using
> RS2000
> regardless if I was using paging feature like returning partial records at
> a
> time. I've called MS and the support person told me that RS2000 was not
> meant to return more than 10k records. I thought that was stranged but I
> kind of understand. Have this issue been resolved in RS2005? Or do I
> continue using Crystal Reports..
> Second question is regarding dataset being pass from asp.net. In RS2000,
> there was no way to pass dataset from asp.net to RS2000. I know few
> people
> in the past have created their own customize dataset (Teo Lachev is one)
> to
> be able to pass datasets (not rs2000 dataset but, dataset in asp.net/
> vb.net). Have RS2005 added this feature? Thanks in advance.
> Henry

Wednesday, March 28, 2012

raid 5 v raid 10

raid 5 v raid 10

raid 5 v raid 10

Monday, March 26, 2012

radius search

Wednesday, March 21, 2012

R

Friday, March 9, 2012

Quick select statement question

Wednesday, March 7, 2012

Quick Question

Quick DMX question

Quick custom security question

Monday, February 20, 2012

Questions using RS2005

rda submitsql

Blog Archive

About Me