Re: Share Database with 2 SQL Servers.

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 05/21/04 

Date: Fri, 21 May 2004 12:48:05 -0400

Why would you need more than 900 bytes in an index key? Anything that large
really needs to go to full-text search instead. 

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jack Victor" <Nomail@JustPostReply.tv> wrote in message
news:pan.2004.05.21.15.40.12.152000@JustPostReply.tv...
> Damn!  At least I know this ahead of time.  Our db has almost no indexes
> (just the primary keys really) and because of the 900 byte index limit I
> can't create indexes on the fields that we would be frequently searching
> on.  But at least since have have few indexes and rows don't go through
> multiple table joins, we should have high insert rates.
>
> I didn't know about sqlpass.org.  Thanks for the tip!
>
>
> On Fri, 21 May 2004 10:21:47
> -0400, Geoff N. Hiten wrote:
>
> > No. Each SQL Server\instance has exclusive control over its databases.
>

Relevant Pages

  • Re: Active/Active/Active/Passive and Database Mirroring
    ... Senior Database Administrator ... Microsoft SQL Server MVP ... In the active/active/active/passive configuration is it possible to load ... "Geoff N. Hiten" wrote: ...
    (microsoft.public.sqlserver.clustering)
  • Re: Data Loss?
    ... Is the application using Windows Authentication or SQL Server logins? ... -- "Geoff N. Hiten" wrote in message ... I was able to when the deleting took place,> and the SPID of the user or computer it came from, but apparently SPIDs> change so whoever had that number on the day the deletions occurred has a> different SPID now. ... >> Senior Database Administrator ...
    (microsoft.public.sqlserver.server)
  • Re: Maintenance PLan recommendation
    ... I support the Professional Association for SQL Server ... > I can definitely confirm that what Geoff is stating is true. ... the SQL Service account must have FULL CONTROL ... >>>Senior Database Administrator ...
    (microsoft.public.sqlserver.server)
  • Re: Scenario
    ... limited budget, but you may need to point out to management that they will ... I support the Professional Association for SQL Server ... > "Geoff N. Hiten" wrote in message ... >> Senior Database Administrator ...
    (microsoft.public.sqlserver.clustering)
  • Re: Connecting to an instance in a cluster
    ... "Geoff N. Hiten" wrote: ... you cannot reuse port numbers. ... Microsoft SQL Server MVP ... That is the port you have to open on the firewall. ...
    (microsoft.public.sqlserver.clustering)