maximum number of rows to fetch

Anybody knows how to change the default 1000 of "maximum number of rows to
fetch" in EM to sth else?
You get that prompt by Open Table-->Return Top...
Thanks,
Wenlei
Wenlei Fang wrote:
> Anybody knows how to change the default 1000 of "maximum number of
> rows to fetch" in EM to sth else?
> You get that prompt by Open Table-->Return Top...
> Thanks,
> Wenlei
I wouldn't use SQL EM for that anyway. Use QA and add a TOP X to the
query to return only the rows you need. SQL EM leaves pages on the
server until you scroll to see them in the UI. This leaves shared locks
on the server on the unfetched pages.
David Gugick
Imceda Software
www.imceda.com
|||I'm totally agree with your point. But what I want to do is to change it to
a smaller number, say 5, so we won't lock any rows and still can view some
sample data.
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OmPR5vHFFHA.2756@.TK2MSFTNGP15.phx.gbl...
> Wenlei Fang wrote:
> I wouldn't use SQL EM for that anyway. Use QA and add a TOP X to the query
> to return only the rows you need. SQL EM leaves pages on the server until
> you scroll to see them in the UI. This leaves shared locks on the server
> on the unfetched pages.
> --
> David Gugick
> Imceda Software
> www.imceda.com
|||AFAIK there is no way to do this. No documented method anyway.
I second David G's advice. Avoid EM and use Query Analyzer to sample
and view data.
David Portas
SQL Server MVP
|||Davids,
Thank you for your input. Sometimes it is easier and quicker to view table
structure, sample data and insertion through EM than QA as long as you know
what you are doing. And I'm looking for undoc method such as registry hack
etc.
Regards,
Wenlei
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1108653945.639057.128320@.g14g2000cwa.googlegr oups.com...
> AFAIK there is no way to do this. No documented method anyway.
> I second David G's advice. Avoid EM and use Query Analyzer to sample
> and view data.
> --
> David Portas
> SQL Server MVP
> --
>

maximum number of rows to fetch

Anybody knows how to change the default 1000 of "maximum number of rows to
fetch" in EM to sth else?
You get that prompt by Open Table-->Return Top...
Thanks,
WenleiWenlei Fang wrote:
> Anybody knows how to change the default 1000 of "maximum number of
> rows to fetch" in EM to sth else?
> You get that prompt by Open Table-->Return Top...
> Thanks,
> Wenlei
I wouldn't use SQL EM for that anyway. Use QA and add a TOP X to the
query to return only the rows you need. SQL EM leaves pages on the
server until you scroll to see them in the UI. This leaves shared locks
on the server on the unfetched pages.
David Gugick
Imceda Software
www.imceda.com|||I'm totally agree with your point. But what I want to do is to change it to
a smaller number, say 5, so we won't lock any rows and still can view some
sample data.
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OmPR5vHFFHA.2756@.TK2MSFTNGP15.phx.gbl...
> Wenlei Fang wrote:
> I wouldn't use SQL EM for that anyway. Use QA and add a TOP X to the query
> to return only the rows you need. SQL EM leaves pages on the server until
> you scroll to see them in the UI. This leaves shared locks on the server
> on the unfetched pages.
> --
> David Gugick
> Imceda Software
> www.imceda.com|||AFAIK there is no way to do this. No documented method anyway.
I second David G's advice. Avoid EM and use Query Analyzer to sample
and view data.
David Portas
SQL Server MVP
--|||Davids,
Thank you for your input. Sometimes it is easier and quicker to view table
structure, sample data and insertion through EM than QA as long as you know
what you are doing. And I'm looking for undoc method such as registry hack
etc.
Regards,
Wenlei
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1108653945.639057.128320@.g14g2000cwa.googlegroups.com...
> AFAIK there is no way to do this. No documented method anyway.
> I second David G's advice. Avoid EM and use Query Analyzer to sample
> and view data.
> --
> David Portas
> SQL Server MVP
> --
>

maximum number of rows to fetch

Anybody knows how to change the default 1000 of "maximum number of rows to
fetch" in EM to sth else?
You get that prompt by Open Table-->Return Top...
Thanks,
WenleiWenlei Fang wrote:
> Anybody knows how to change the default 1000 of "maximum number of
> rows to fetch" in EM to sth else?
> You get that prompt by Open Table-->Return Top...
> Thanks,
> Wenlei
I wouldn't use SQL EM for that anyway. Use QA and add a TOP X to the
query to return only the rows you need. SQL EM leaves pages on the
server until you scroll to see them in the UI. This leaves shared locks
on the server on the unfetched pages.
--
David Gugick
Imceda Software
www.imceda.com|||I'm totally agree with your point. But what I want to do is to change it to
a smaller number, say 5, so we won't lock any rows and still can view some
sample data.
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OmPR5vHFFHA.2756@.TK2MSFTNGP15.phx.gbl...
> Wenlei Fang wrote:
>> Anybody knows how to change the default 1000 of "maximum number of
>> rows to fetch" in EM to sth else?
>> You get that prompt by Open Table-->Return Top...
>> Thanks,
>> Wenlei
> I wouldn't use SQL EM for that anyway. Use QA and add a TOP X to the query
> to return only the rows you need. SQL EM leaves pages on the server until
> you scroll to see them in the UI. This leaves shared locks on the server
> on the unfetched pages.
> --
> David Gugick
> Imceda Software
> www.imceda.com|||AFAIK there is no way to do this. No documented method anyway.
I second David G's advice. Avoid EM and use Query Analyzer to sample
and view data.
--
David Portas
SQL Server MVP
--|||Davids,
Thank you for your input. Sometimes it is easier and quicker to view table
structure, sample data and insertion through EM than QA as long as you know
what you are doing. And I'm looking for undoc method such as registry hack
etc.
Regards,
Wenlei
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1108653945.639057.128320@.g14g2000cwa.googlegroups.com...
> AFAIK there is no way to do this. No documented method anyway.
> I second David G's advice. Avoid EM and use Query Analyzer to sample
> and view data.
> --
> David Portas
> SQL Server MVP
> --
>

maximum age

hi,
was wondering any knows the synatax for a query to find the maximum age in a table. in SSH secure Shell
cheersWell, SQL would do that as

SELECT MAX(age) FROM your_table

but I have no idea how to incorporate it with the SSH secure Shell.

Max. number of databases

Hello,
anybody knows what's the maximum number of databases i can create on a SQL
Server 2000 instance?
thanks.
AndresLook in the BOL under 'SQL Server Architecture' -> 'Implementation
Details' -> 'Maximum Capacity Specifications' It's documented as 32,767.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"andsilva" <andsilva@.hotmail.com> wrote in message
news:OEqcrb8gDHA.3784@.tk2msftngp13.phx.gbl...
> Hello,
> anybody knows what's the maximum number of databases i can create on a SQL
> Server 2000 instance?
> thanks.
>
> Andres
>|||Hi Andres,
This is documented in Books Online, under "Maximum Capacity Specifications" article
Maximum number of databases per server instance is 32767
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights. Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
--
| From: "andsilva" <andsilva@.hotmail.com>
| Subject: Max. number of databases
| Date: Thu, 25 Sep 2003 19:37:57 -0500
| Lines: 11
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <OEqcrb8gDHA.3784@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 64.76.52.225
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:308434
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hello,
|
| anybody knows what's the maximum number of databases i can create on a SQL
| Server 2000 instance?
|
| thanks.
|
|
| Andres
|
|
||||In theory 32,767. Practically, you probably want to test thoroughly perf, maint etc if you go above
about 100.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"andsilva" <andsilva@.hotmail.com> wrote in message news:OEqcrb8gDHA.3784@.tk2msftngp13.phx.gbl...
> Hello,
> anybody knows what's the maximum number of databases i can create on a SQL
> Server 2000 instance?
> thanks.
>
> Andres
>