Indexing/Clearing Cache REsultset - Sql SErver 2000

How do you put a combined index on two fields within a table where they are
both varchar'
Is it possible to clear out a cache resultset from with sql query analyzer?
J. D> How do you put a combined index on two fields within a table where they
> are both varchar'
What is a "combined index"? Do you mean:
CREATE INDEX idxWhatever ON tableName(col1, col2)
?

> Is it possible to clear out a cache resultset from with sql query
> analyzer?
If you hit Ctrl+R, it will "hide" the results. There is no way that I know
of to get rid of them completely, without closing the current query window.
A|||DBCC DROPCLEANBUFFERS
go
DBCC FREEPROCCACHE
go
--Kristy
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OXmbtMrRFHA.3740@.TK2MSFTNGP10.phx.gbl...
> What is a "combined index"? Do you mean:
> CREATE INDEX idxWhatever ON tableName(col1, col2)
> ?
>
> If you hit Ctrl+R, it will "hide" the results. There is no way that I
know
> of to get rid of them completely, without closing the current query
window.
> A
>|||Aaron,
That was what I thought they meant, but was not 100% sure....thanks
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OXmbtMrRFHA.3740@.TK2MSFTNGP10.phx.gbl...
> What is a "combined index"? Do you mean:
> CREATE INDEX idxWhatever ON tableName(col1, col2)
> ?
>
> If you hit Ctrl+R, it will "hide" the results. There is no way that I
> know of to get rid of them completely, without closing the current query
> window.
> A
>|||Thanks Kristy
"Kristy" <pleasereplyby@.posting.com> wrote in message
news:eON$ITrRFHA.2680@.TK2MSFTNGP09.phx.gbl...
> DBCC DROPCLEANBUFFERS
> go
> DBCC FREEPROCCACHE
> go
> --Kristy
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:OXmbtMrRFHA.3740@.TK2MSFTNGP10.phx.gbl...
> know
> window.
>|||On Thu, 21 Apr 2005 16:45:52 -0400, Aaron [SQL Server MVP] wrote:
(snip)
>If you hit Ctrl+R, it will "hide" the results. There is no way that I know
>of to get rid of them completely, without closing the current query window.
Hi Aaron,
In "Results in Text" mode: switch to results pane, hit Ctrl-A to select
all, hit Backspace or Delete key.
In both "Results in Text" and "Results in Grid" mode: switch to query
pane, highlight one or more space characters, hit Ctrl-F5 to execute.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)