How to find the string with (utf-8) and no sign but all the same results in
MS SQL 2005
Example: I want to search string "nhà đẹp" or "nha dep" all the result in
"nhà đẹp"

SQL Server 2008 SP1.
After doing a restore to migrate a SQL 2000 database to SQL 2008 we ran the
DBCC CHECKDB DATA_PURITY command which identified Invalid Rows in several
tables.

Sql Server 2005 9.00.4035.
We have a hub and spoke topology which includes 6 tables with identity
columns.
I need to add a new subscription to a new server (same version/sp).  I took

Does anyone know if the Elevate America program includes SQL Server training
and/or certification?

It appears that the service broker newsgroup may be dead ?
I apologize if some view this a cross posting...
I have a process whereby I would like to accomplish the following...
The setting includes many client workstations using a VB.net application to

DBTYP.NET Studio 2010 - Database Comparison Suite Released
Vienna, Austria - March 8, 2010
Today, BYPsoft announced the availability of DBTYP.NET Studio 2010, the
newest version of the cross-database comparison tool that compares SQL

As an SBSer since I have SQL on my server I feel like SQL is family so
if you'll indulge me in a fishing expedition on forums versus newsgroups.
I need to pick your brain a bit if you don't mind?  Can I ask some
fishing expedition questions because I want to see if my thoughts are ...

I had a trace file from production (almost all stored proc execution
events) and I'm using it to tune agaist the exact copy of production
database. After running an hour, the progress shows in the Reason
column almost all "Statement does not reference any tables" and

I just wonder if there's anyone who uses\used Attunity with their SQL Server
environment?
I would appreciate if you have any experience, suggestion or tips to share
with me.

I have both SQL server 2005 that have replication set-up between eachother.
It seems that when my site-to-site VPN drops for a medium period (such as
1hr, 2hr) bothe servers no longer respond to client connections.
Restarting the "SQL server Browser" service on both machines ...

I have solutions manuals for these scientific textbooks .. They are
all in PDF format .. If you are interested in any one, simply send me
an email to macmorino(at)gmail(dot)com .. Please this service is NOT
free.

After working for years as a DBA for my company I would like to transition to
another position within the corporation. The company has a large IT
department, however I'm not sure what I can transition to being a DBA. I'd
like to hear from other DBA's out there that have transitioned ...

After working for years as a DBA for my company I would like to transition to
another position within the corporation. The company has a large IT
department, however I'm not sure what I can transition to being a DBA. I'd
like to hear from other DBA's out there that have transitioned ...

Has anyone else noticed performance issues with querying syslockinfo,
dm_tran_locks and sp_lock since upgrading to SQL 2008?
It seems they perform the worst on named instances.
SQL 2008 Server 2008 named instance - 4 seconds

This is a design question.  Here's hoping Joe Celko haunts this newsgroup ;)
The relevant DDL will be at the bottom of the post.
We have two entities -- sporting events and "product" which could be a cup,
shirt or a fee.  Obviously, events have a number of attributes not needed