I have create a view which I use to get duplicates and near matches between
two tables. Getting the near matches means a where clause with lots of OR
clauses to get the various permutatiuons which are classed as a near match.
So my view is like this - there are lots or variations ...

how to determine how many milliseconds a segment of code takes to execute in
TSQL on sql server 2005?

Can someone help me with restoring a database using sql server
management studio?  Every time I attempt to restore a database, I get
the following message:
Restore failed for Server 'localhost\SQLExpress'.

The code listed below is being used from inside Crystal Reports to build a
cross tab report showing the total number of clients by level (1,2,3,E, or
P) and Type (I or P). What I would like to do is add some compute statements
(or something) to the end of this query that would ...

How do I loop through the records in a temporary table?
Thanks

I've got a SQL 2000 Server setup having multiple databases. One of my users
wants to be able to backup and restore his database
using SQL database and use Linked Server feature in sql 2000. In SQL 2000,
if I grant him access Server and System administration roles,

Hello group,
I have the following issue:
select convert(varchar, GETDATE(), 105)
------------------------------

Hi I have a simple package I am putting together.  The package runs a query
on an SQL database (database1) and the results are then copied over to
another SLQ database (database2).  I have this set up and it works.  I am
trying to add another element that will update a table in ...

i just want to check if i could have any problems in the future with this.
The thing is that i've installed a sql 2005 enterprise 64 bits on a windows
2003 enterprise R2 64 bits, with Intel x64 cpu.
But when i check on the sql instance properties it shows that the platform

I often only use one or more XML-files as database for my applications since
it is very non-complicated and lets me model my datastructure in any way i
like it to be. But when do I really need to consider moving up to a larger
database-platform?

On my Windows 2003 server, I just created a local account, I was planning
using that account for the SQL Server 2000 log shipping.  However, I don't
know how to use that account to start SQL Server related services.  Would
some one give some advice?

We have aquired a new company and I need to migrate a SQL 2000 server from
thier existing domain to our AD domain.  Other than changing the service
accounts and any SQL domain accounts is there anything else I should be aware
of?

we has all web applications and databases on one server.recently we
did an  excercise to move all databases to a new server and connecting
it through the application server.
The database is in sql server and all applications are in .Net

Does SQL Server use PFS to check whether a page is allocated or not if the
table has a clustered index.
Regards
Balaji

I am trying to install SQL 2005 (standard/enterprise) in windows server
2008.And it complains about compatibility issues. Does anybody know how to
resolve such issue.
Ghanashyam