Another Need Help for Choosing an SQL Server front end

Hi,
I'm just in the planning stages of upgrading a small bunch of databases
to MS SQL Server (2003). The current databases are very poorly
designed, so I'm basically starting from scratch. The databases will
grow to be quite large over time, and we have plenty of space for it.
Currently the number of users is about 15 in total. I would prefer to
web-enable it using our intranet since I have skills in programming JSP,
html, etc. But don't have time to learn ASP or ASP.Net. Am also
proficient with MS Access but have found it a little unstable in the
past.
Is there anything someone could recommend as a front-end?
AMH
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
"AMH" <anonymous@.blah.com> wrote in message
news:ukIxMAgHFHA.3244@.TK2MSFTNGP09.phx.gbl...
> I'm just in the planning stages of upgrading a small bunch of databases
> to MS SQL Server (2003). The current databases are very poorly
> designed, so I'm basically starting from scratch. The databases will
> grow to be quite large over time, and we have plenty of space for it.
> Currently the number of users is about 15 in total. I would prefer to
> web-enable it using our intranet since I have skills in programming JSP,
> html, etc. But don't have time to learn ASP or ASP.Net. Am also
> proficient with MS Access but have found it a little unstable in the
> past.
> Is there anything someone could recommend as a front-end?
There is no SQL Server 2003... 2000 is the current version. Microsoft Access
still makes a reasonably good front end. If the data is constantly being
changed by your users, you will need to learn to be proficient in multi-user
VBA coding techniques.
Steve
|||I can't see the users changing data so much. There'll be a lot of data
entry, and a lot of querying to find trends, patterns, etc.
AMH
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||When you buy sql server 2000 it comes already with a good GUI front end
called Enterprise Manager. It is very easy to use and you could control
who has access to what.
It is free too and can be installed on everybodies workstation.
|||But Enterprise Manager isn't designed to be a front end tool
for end users. It's a "quick and dirty" administration tool.
It's not necessarily free to distribute to everyone. It's
still governed by licensing.
-Sue
On 1 Mar 2005 16:41:48 -0800, thomasamillergoogle@.yahoo.com
wrote:

>When you buy sql server 2000 it comes already with a good GUI front end
>called Enterprise Manager. It is very easy to use and you could control
>who has access to what.
>It is free too and can be installed on everybodies workstation.
|||Thanks, but Enterprise Manager is more for the administrative side of
things - that's what I'll use. But I'm after a user interface that I
can build for the every-day user who can't have direct access to the raw
data.
AMH
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||"AMH" <anonymous@.blah.com> wrote in message
news:uYxTSzsHFHA.3376@.TK2MSFTNGP14.phx.gbl...
> Thanks, but Enterprise Manager is more for the administrative side of
> things - that's what I'll use. But I'm after a user interface that I
> can build for the every-day user who can't have direct access to the raw
> data.
One solution, use Microsoft Access as your front and create custom views in
SQL Server. The users never sniff the raw data tables
Steve

Analyzing a Query in SQL Server

I have to duplicate a bunch of reports that were produced by a VB6 app. Now I'm using C#, ASP.net and Crystal Reports via VS2003. Each executes a stored procedure in SQL Server (before and now).

For each report I have a Stored Procedure and a View. The View's SQL code is identical to the Stored Procedure except that the two input parameters (startDate and endDate) are removed because Views don't allow parameters.

Some of the reports work perfectly right off the bat. But others are timing out. My initial test of the timing out is to just display the View. If it fails then I know that the the report engine will fail too.

So now I'm trying out the SQL Query Analyzer tool to execute the code in one of the Views. It's now at 29 minutes and still going - at least it hasn't timed out!

My question is this: Is there a way I could examine what's going on with the query to see why it's taking so long?

Robert WernerHave a look at the query execution plan in the query analyzer, do you see any bottlenecks there ? During execution you might encounter a deadlock. looking in the appropiate node in SQL Server Enterprise Manager (Current Activity) you might be able to find the blocking process.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||Jens,

Thank you for your suggestion. I've never used that Execution Plan before so just tried it out on one of the queries that's timing out. I took the liberty of taking a screen capture and posting it here:

http://pocketpollster.com/downloads/public/WBMCST11_Execution_Plan.jpg

Does this communicate anything to you?

Robert Werner
Vancouver, BC|||THe information which is sensitive while moving over the individual objects is missing for us, so its hard to tell. This is the estimated execution plan not the actual executed one, but as a rule of thumb you should have a look on the highest cost in the plan as well as actions like table scans. They are often costly if made for huge tables but are on the opposite cheaper then using indexes in smaller tables. There are some other thing you could check like setting the STATISTICS_IO to on or the SHOWPLAN to make the execution plan shippable to other peers with more information.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Analysis Services 2005 Derived Member

Hi,

I can't seem to find any information about creating a derived member in SSAS 2005. I have found a bunch of stuff for 2000. I have some Calculated members that are giving me some performance pains that I was hoping to solve by creating derived members.

Any info would be greatly appreciated.

S

WHat is "derived member" ? Neither AS2000 nor AS2005 have such a concept. Can you point out to the information you found, so it will be easier for us to understand what you mean. Or, perhaps, you can describe your scenario in detail, and then this forum might be able to help.|||

I apologize. It was Derived Member.

Here is a link: http://www.databasejournal.com/features/mssql/article.php/3394681

|||

In this case, the "derived member" discussion in that link is the equivalent of adding named calculations within the DSV of an SSAS 2005 solution.

A named calculation is added to a table (or view) that has been included within a DSV. The named calculation takes an expression (in the SQL dialect of the underlying RDBMS involved) and provides a name for the resulting value. This then becomes another available column within the table from the perspective of the rest of the SSAS solution. Thus, a measure could be built using the named calculation (if it is in a fact table) or an attribute could be created using it (if it is in a dimension table).

HTH,

Dave Fackler