for this query alone, I would advise only a non-clustering (but covering) index since there is no extra data-access.

In general an " exists (select ... where correlated predicate = xxx)...

IMO this notation is more comprehensive ...

Select * From Master

 INNER JOIN Details D1

ON Master.MasterID = Details.MasterID 

                       and D1.Value = 'Criteria1Value' 

 INNER JOIN Details D2

ON Master.MasterID = Details.MasterID

   and D2.Value = 'Criteria2Value'

provide...

sqlserver version and sp / hotfix ?

I use this kind of instruction as a last step of my backup-jobs to copy to safehaven.

XCOPY C:\MSSQL\BACKUP\*.* \\myUNCservername\myshare\MyDbServerName\Database\ /c /k /h...

- duplicate spids are caused by parallelism.

- they shouldn't interfere with backup activities

It works just fine now !!

Imports

System

Imports

System.Data

Imports

System.Data.SqlClient

Thank you for your time.

It took me a while, but finaly I got the winform app to work ...

Address = Address.Replace(

" ", "+"

Here it is ... my vbform :

form fields : streettxt , citytxt, statetxt , datagridview Resultsdgv

form button : CallWebServicebtn

here's the code :

Imports

System

Imports

System.Data

I like the article and the example.

I've tried to install it on my local sql2005STD instance wich has clr enabled and my testdb is trustworthy.

The vb.net version as well as...

about the same goes for "Spotlight on SQLServer" from Quest software.

First of all, you query is to heavy !

You use 3 objects and only join two of them, leaving the 3-th one for crossjoining ???

First I would start looking in the Windows event log searching for IO-errors (cards or disks) if you can perform a checkdisk,..

Then check if there are memory errors.

Then perform dbcc...

indeed F1 just brings up BOL,

shift-F1 brings up BOL and positiones to the selected statement in possible.

e.g. create index x on mytable (y)

when you select "create index" and then...

Books Online is a valuable resource. It contains the help for SQL and SQLServer

From Query Analyser, you can access it pressing Shift +...

how about

select substring(account_number,1,2) as Acc_prefix, count(*) as Counter

from your_accounting_table

group by substring(account_number,1,2)

order by Acc_prefix