Good job referencing http://support.microsoft.com/kb/2154845/en-us in the script - I would have added some information about it in the article as well. "You observe severe blocking when the SQL Server...

If you really want to baseline things and isolate the changes made, ideally, you might do something like record a few segments (hours worth, including all aspects - input, output,...

I would absolutely start with "cleaning" up data, followed by exact search on the cleaned version, followed by a double metaphone implementation, since that simply generates one or two possible...

Brandon Forest (1/9/2014)

---

I'm frustrated trying to recover a sa password from a legacy database that no one knows. I've tried using Hashcat and oclHashcat following this article and the...

elee1969 (1/6/2014)

---

Thanks for all the help guys. I was able to get it back up last week. The sqlservr.exe file was corrupted. Could not start it from command line. So...

Changing the code in your SP's? Reads, Writes, CPU, and Duration from a trace/profiler session, preferably over multiple runs, the first of which...

In at least sys.databases, database name is of SYSNAME type, which currently equates to nvarchar(128) NOT NULL. While I can...

I've renamed the pure SQL functions somewhat, but here's an example of how I would call them from a stored procedure:

DECLARE @result FLOAT

SET @result = CalculateJaroWinkler('Bob','Bill')

PRINT @result

SET @result = CalculateJaroWinkler('Bob','Bub')...

Jeff Moden (12/31/2013)

---

REBUILDing indexes requires additional space in the database. A LOT of additional space if your tables are large. Typically, and across the database REBUILD of all...

Finding SQL servers can get interesting. By far the best way is using methods that find the service and/or the executable, i.e. some of the SQLPing modes, and commands...

And by strong, we don't mean 8 characters long.

At least 15 truly random characters is a good start.

Minimum permissions at the finest are column based permissions; if that's too difficult,...

Jeff Moden (12/2/2013)

---

Wow! I talked with that DBA ... and he doesn't run any form of anti-virus on them. I didn't have the time to talk with him...

Objection - clustered indexes can be both non-unique and NULL. Yes, they should...

Very interesting.

You've got some odd unprintable characters in there - I replaced them with spaces, and then have the following initial comments:

Why give it a parent job name? I'd...

salman.sadruddin (12/3/2013)

---

We have applications connected to SQL using windows authentication. While having connection with Application user can also access to Database instance on the same time as well. We need...