SQLQuest29

Forum Replies Created

Viewing 15 posts - 91 through 105 (of 286 total)

RE: String search and replace it with single letter

I am using the one u provided:
IF OBJECT_ID(N'tempdb..#T') IS NOT NULL
DROP TABLE #T ;
IF OBJECT_ID(N'tempdb..#T2') IS NOT...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 9, 2011 at 1:48 pm

#1296793
RE: String search and replace it with single letter

I am using the one u provided:
IF OBJECT_ID(N'tempdb..#T') IS NOT NULL
DROP TABLE #T ;
IF OBJECT_ID(N'tempdb..#T2') IS NOT...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 9, 2011 at 1:48 pm

#1296792
RE: String search and replace it with single letter

GSquared (3/9/2011)
Something like this will do a full dedupe. It won't leave deliberate dupes intact. The only way I can think of to do that would be a...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 9, 2011 at 1:42 pm

#1296789
RE: String search and replace it with single letter

GSquared (3/9/2011)
Something like this will do a full dedupe. It won't leave deliberate dupes intact. The only way I can think of to do that would be a...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 9, 2011 at 1:42 pm

#1296788
RE: String search and replace it with single letter

GSquared (3/9/2011)
And what do you want to do if the word has a legitimate repeat in it? Aardvark, apple, peer, assimilate, better, coordinate, dunnage, tonne, etc., all have repeating...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 9, 2011 at 12:57 pm

#1296759
RE: String search and replace it with single letter

GSquared (3/9/2011)
And what do you want to do if the word has a legitimate repeat in it? Aardvark, apple, peer, assimilate, better, coordinate, dunnage, tonne, etc., all have repeating...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 9, 2011 at 12:57 pm

#1296760
RE: Database communication

hemangmehtaa (1/13/2011)
Hi,
We have 2 databases db1 and db2, they may or may not be on the same server.
Now db2 has got a particular table called foo. when db2 enters a...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

January 17, 2011 at 10:59 am

#1274330
RE: Restore in read only mode?

SKYBVI (1/5/2011)
Hi,
I was able to successfully restore the database on secondary side and also set up log shipping.
But there was a variance.
As far as I know, log...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

January 6, 2011 at 11:55 am

#1270259
RE: Restore in read only mode?

SKYBVI (1/5/2011)
Hi,
I was able to successfully restore the database on secondary side and also set up log shipping.
But there was a variance.
As far as I know, log...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

January 6, 2011 at 11:55 am

#1270258
RE: Slow query performance after upgrading from SQL2000

jamesnjamesn (11/29/2010)
Slow query performance after upgrading from SQL2000
We are having query performance issues with our data warehouse server after upgrading from SQL2000 to SQL2008R2.
Our problem is that *some* queries which...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

December 2, 2010 at 8:35 am

#1257926
RE: Slow query performance after upgrading from SQL2000

jamesnjamesn (11/29/2010)
Slow query performance after upgrading from SQL2000
We are having query performance issues with our data warehouse server after upgrading from SQL2000 to SQL2008R2.
Our problem is that *some* queries which...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

December 2, 2010 at 8:35 am

#1257925
RE: back up and restore rows in sql server 2008

sfr_rezaei (11/8/2010)
I want to back up some rows of table from sql
then restore rows to another database. I have two table with relation
How about using Linked server (if it is...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

November 10, 2010 at 12:34 pm

#1249112
RE: back up and restore rows in sql server 2008

sfr_rezaei (11/8/2010)
I want to back up some rows of table from sql
then restore rows to another database. I have two table with relation
How about using Linked server (if it is...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

November 10, 2010 at 12:34 pm

#1249113
RE: DBCC CHECKDB Error Msg 2570, Level 16, State 3

bsock (9/27/2010)
Thanks! That worked for me. I knew I was missing something.
Can you describe what did you do to fix the problem ?
Cheers !
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

October 3, 2010 at 10:36 am

#1230775
RE: Different results when query table by different columns

Kevin Wieand (9/27/2010)
Can anyone help me with this?
I have a table with an ID, last name, and first name which are all varchar. There are other columns in the...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

October 3, 2010 at 10:31 am

#1230774

Viewing 15 posts - 91 through 105 (of 286 total)