Why is this part of your code?

AND ISNULL(TableZ.MyCol,'') + '/' + ISNULL(Table2.MyCol,'') + '/' + ISNULL(Table3.MyCol,'')

+ '/' + ISNULL(Table4.MyCol,'')+ '/' + ISNULL(Table5.MyCol,'') IS NOT NULL

Using the ISNULL followed by a...

I would also try to get some before and after stats on things such as table sizes (data and indexes) in order to help narrow down what activity is affecting...

As mentioned in the article it only checks against the following data types:

CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, and XML

Yes it does:

USE tempdb

CREATE TABLE test (somevarchar VARCHAR (100) PRIMARY KEY CLUSTERED)

INSERT INTO test VALUES ('does it seach PK')

EXEC "database the proc is in".dbo.usp_String_Search

@v_Search_String = 'does it seach PK'

,@v_Database_Name...

I think you need to change the DB context to have it search against whichever DB you are interested in.

As for "#temp" vs. "tempdb..#temp", this should make no difference in...

Ah, 100-year-old 3rd party consultant code... been there <SHUDDER>. LOL!

How does the time waiting indicate a query that needs tuning? Couldn't the wait time be caused by other processes, heavy load on the server, blocking issues, etc.? Just not...

Okay. Best suggestion then is to try some PowerShell user groups / sites. If you find the answer feel free to share it. 🙂

Hi there.

I am glad that the script has helped you out (I actually have plans for expanding it soon-ish).

Unfortunately, I know nothing about PowerShell, so I won't be able to...

Just plain AWESOME!

Very interesting! I had not considered this. The issue would be identifying such a case since comments can be in many different forms:

--@my_unused_parameter

-- @my_unused_parameter

-- need to clean this up one...

Honestly, never tried (but I would think no). Sorry, haven't dealt much with SSIS packages. Try a search string that you know is in an SSIS package and see if...

Actually, that is a decent workaround for now. 🙂

There are various methods of saving output to a file. Unfortunately it is too long to go into detail here, but if you Google "SQL Server saving results to a...

Fantastic. Hope you enjoy some of the new features of this version. 🙂