+1000

Switching...

What is migration_db? Is this a one-time migration? You have a design or a data issue or both if your regularly matching a nullable column to another and always treating...

This vaguely sounds like one of the old encryption/hashing methods in SQL 2000 and before that have long-since-been-dropped-from-the-product. Which version of SQL Server were you on at the time?

Expect scans:

DECLARE @temp VARCHAR(MAX)

SET @temp = 'aaa'

SELECT *

FROM SampleData

WHERE ',' + value1 + ',' LIKE '%,' + @temp + ',%'

Stamey (7/19/2011)

---

My task is to go through certain fields one many DBs and servers to make the columns larger. In this case it is because the standard column size is...

GSquared provided the goods.

I am curious though, do you mind sharing the FTS piece of it? Is it still relevant for the overall solution?

Excellent! The problem domain is set. Have a go at this using the techniques outlined in the article. It has everything you need to arrive at a solution to this...

tleezer (7/19/2011)

---

This script will loop through a directory, executing all SQL files within...

--Enable xp_cmdshell

EXEC [master].[dbo].[sp_configure] 'show advanced options', 1

RECONFIGURE

GO

EXEC [master].[dbo].[sp_configure] 'xp_cmdshell', 1

RECONFIGURE

GO

--Execute all sql files in dir

EXEC xp_cmdshell 'for...

jmoldover (7/19/2011)

---

I need to take data in the following format (in SQL 2005):

System_NameManufacturerModelTypeOSFunction

XXX-G-BCKM-001HP CompanyDL385 ServerWin2003BCKMS

XXX-G-CLSA-001HP CompanyDL385ServerWin2003CLSA

XXX-G-CLSA-002HP CompanyDL385ServerWin2003CLSA

XXX-G-CLSA-003HP CompanyDL385ServerWin2003CLSA

...

and, filtering on the Function field, turn it into the following:

Attribute XXX-G-CLSA-001XXX-G-CLSA-002XXX-G-CLSA-003

ManufacturerHP CompanyHP...

Make sure you're in compliance with CAN-SPAM too. "Correcting" an email address on behalf of the person who provided the data after it's been collected and the person is no...

GSquared (7/19/2011)

---

...truncated...

If the DB Admin will be doing the actual query tuning himself, that's a different question entirely. But that's not DB Admin. That's "Lead Database Developer" or...

Alliances don't need to be a negative thing, or cast in a negative light. Unified messages to customers and clear direction amongst team members can be invaluable in the heat...

bopeavy (7/19/2011)

---

opc.three (7/19/2011)

The Dixie Flatline (7/19/2011)

--------------------------------------------------------------------------------

Call the people at SETI.

Seriously, I think T-SQL may be the wrong tool for the job of discovering undefined patterns....

Doesn't mean we can't discuss it...John will be back later if performance concerns outweigh the next deadline.

SB crossed my mind too. I was thinking of external activation calling a compiled...

The Dixie Flatline (7/19/2011)

---

Call the people at SETI[/url]. 😀

Seriously, I think T-SQL may be the wrong tool for the job of discovering undefined patterns. This sounds like...