Find location of data files

What is the tsql cmb to view the file structure location on a database?
This will help me with my attach and detach.sp_help '<dbname>'
sqlteam32 wrote:
> What is the tsql cmb to view the file structure location on a database?
> This will help me with my attach and detach.|||Sorry, make that:
sp_helpdb '<dbname>'
sqlteam32 wrote:
> What is the tsql cmb to view the file structure location on a database?
> This will help me with my attach and detach.|||try the following:
use <dbname>
sp_helpfile
sp_helpgroup
select * from sysfiles
use master
select * from sysaltfiles
"sqlteam32" <mtorpy@.gmail.com> wrote in message
news:1149798455.023852.166600@.h76g2000cwa.googlegroups.com...
> What is the tsql cmb to view the file structure location on a database?
> This will help me with my attach and detach.
>|||Note that following will yield an error. If a call to a stored procedure is
not the first thing in a batch, you must use the keyword EXECUTE (or EXEC)
Also, I'm not sure why you need sp_helpgroup, which returns security groups.
Perhaps you want sp_helpfilegroup?
USE <dbname>
EXEC sp_helpfile
EXEC sp_helpfilegroup
SELECT * FROM sysfiles
--
HTH
Kalen Delaney, SQL Server MVP
"Jayesh Antony Jose" <jayeshaj@.hotmail.com> wrote in message
news:OvXadVDjGHA.3800@.TK2MSFTNGP03.phx.gbl...
> try the following:
> use <dbname>
> sp_helpfile
> sp_helpgroup
> select * from sysfiles
>
> use master
> select * from sysaltfiles
>
> "sqlteam32" <mtorpy@.gmail.com> wrote in message
> news:1149798455.023852.166600@.h76g2000cwa.googlegroups.com...
>> What is the tsql cmb to view the file structure location on a database?
>> This will help me with my attach and detach.
>

Find location of data files

What is the tsql cmb to view the file structure location on a database?
This will help me with my attach and detach.sp_help '<dbname>'
sqlteam32 wrote:
> What is the tsql cmb to view the file structure location on a database?
> This will help me with my attach and detach.|||Sorry, make that:
sp_helpdb '<dbname>'
sqlteam32 wrote:
> What is the tsql cmb to view the file structure location on a database?
> This will help me with my attach and detach.|||try the following:
use <dbname>
sp_helpfile
sp_helpgroup
select * from sysfiles
use master
select * from sysaltfiles
"sqlteam32" <mtorpy@.gmail.com> wrote in message
news:1149798455.023852.166600@.h76g2000cwa.googlegroups.com...
> What is the tsql cmb to view the file structure location on a database?
> This will help me with my attach and detach.
>|||Note that following will yield an error. If a call to a stored procedure is
not the first thing in a batch, you must use the keyword EXECUTE (or EXEC)
Also, I'm not sure why you need sp_helpgroup, which returns security groups.
Perhaps you want sp_helpfilegroup?
USE <dbname>
EXEC sp_helpfile
EXEC sp_helpfilegroup
SELECT * FROM sysfiles
--
HTH
Kalen Delaney, SQL Server MVP
"Jayesh Antony Jose" <jayeshaj@.hotmail.com> wrote in message
news:OvXadVDjGHA.3800@.TK2MSFTNGP03.phx.gbl...
> try the following:
> use <dbname>
> sp_helpfile
> sp_helpgroup
> select * from sysfiles
>
> use master
> select * from sysaltfiles
>
> "sqlteam32" <mtorpy@.gmail.com> wrote in message
> news:1149798455.023852.166600@.h76g2000cwa.googlegroups.com...
>

Filters with large number of values

I have web-based reports using SQL server 2005 with filters called location
and suppliers and the number of locations and suppliers are more than 200
each. When the report is rendered with this filters, selection of locations
and suppliers is taking long time on the browsers and it is not easy to
search for the required options in the drop down with checkboxes,
1. Can we modify the parameters display area to show a file-open image
clicking on which opens a popup window for users to select the filter
values?
2. Can we improve the performance while user selects the filter values?
3. Is there any other way to handle this type of large filters (more than
200 filter options) for the reports?
Thanks and Regards,
SridharOn Jun 6, 12:13 am, "Sridhar" <dsrid...@.translogicsys.com> wrote:
> I have web-based reports using SQL server 2005 with filters called location
> and suppliers and the number of locations and suppliers are more than 200
> each. When the report is rendered with this filters, selection of locations
> and suppliers is taking long time on the browsers and it is not easy to
> search for the required options in the drop down with checkboxes,
> 1. Can we modify the parameters display area to show a file-open image
> clicking on which opens a popup window for users to select the filter
> values?
> 2. Can we improve the performance while user selects the filter values?
> 3. Is there any other way to handle this type of large filters (more than
> 200 filter options) for the reports?
> Thanks and Regards,
> Sridhar
In response to number 1, I'm afraid not. In response to number 2, if
I'm understanding you correctly, the more filters you have the more
the performance will be affected. To improve performance, I would
suggest running the report query/stored procedure through the Database
Engine Tuning Advisor to see if there are any indexes that can be
implemented/removed that would improve the performance of the query.
Then, make sure that you are doing as much of the processing in the
query/stored procedure as possible and not in the report. After that,
I would say to limit the number of filters you have on the report.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant