Interview questions and answers

Hi,
Can someone please point me to a link which include SQL Server interview
questions and answers on database administration, performance tuning at
expert level (400)?
Thanks,
EinatTry these:
SQL Server Interview Questions
http://vyaskn.tripod.com/iq.htm
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Gil" <gillapid@.google.com> wrote in message
news:%23N2%23kSw%23GHA.4376@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Can someone please point me to a link which include SQL Server interview
> questions and answers on database administration, performance tuning at
> expert level (400)?
> Thanks,
> Einat
>
>

Interview questions and answers

Hi,
Can someone please point me to a link which include SQL Server interview
questions and answers on database administration, performance tuning at
expert level (400)?
Thanks,
EinatTry these:
SQL Server Interview Questions
http://vyaskn.tripod.com/iq.htm
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Gil" <gillapid@.google.com> wrote in message
news:%23N2%23kSw%23GHA.4376@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Can someone please point me to a link which include SQL Server interview
> questions and answers on database administration, performance tuning at
> expert level (400)?
> Thanks,
> Einat
>
>

Interpreting SQLIO Results... What Now?

Hi all, I ran SQLIO against my SAN and got back some discouraging results.
It basically seemns to point to optimal performance settings of 64KB I/O's
and 4096 KB Stripes. My question is this: how do I ensure that Windows and
SQL Server 2K use these settings? Is there something that needs to be set
in the registry or do I need to modify settings in SQL, or what?
Thanks
P.S. - We got even better results when we set the Buffering option to "All".
How can we make sure Windows, SQL, et al. are using the same options that
SQLIO used?
Thanks
"Michael C#" <xyz@.yomomma.com> wrote in message
news:ODOA5mMKFHA.3916@.TK2MSFTNGP14.phx.gbl...
> Hi all, I ran SQLIO against my SAN and got back some discouraging results.
> It basically seemns to point to optimal performance settings of 64KB I/O's
> and 4096 KB Stripes. My question is this: how do I ensure that Windows
> and SQL Server 2K use these settings? Is there something that needs to be
> set in the registry or do I need to modify settings in SQL, or what?
> Thanks
>