gclausen (10/30/2014)

---

Very good post! I like the breakdown and information the script provides. I'm finding that indexing can be very frustrating and time consuming. Your post will...

pdanes (10/30/2014)

---

Excellent script - many thanks. Already found and fixed some indexing screw-ups in my databases, just on the first run-through. This is something I will be studying in detail,...

Thanks for sharing this!

Okay, thanks.

Yeah, text searches can run REALLY slow. Did you try using some of the input variables from my proc? It tends to help if you know column length, number of...

stevemc (10/22/2014)

---

WRT compiling this procedure on production servers, would it be possible to run this as a temp sproc on that system?

IF OBJECT_ID (N'tempdb..#usp_String_Search', N'P') IS NULL

BEGIN

EXECUTE ('CREATE...

peter.mauss (10/22/2014)

---

Sean Smith-776614 (10/22/2014)

---

peter.mauss (10/22/2014)

---

Yes, it displays the

object_name, the column_name for each hit. It would be cool if it would also Display

the Name of the Primary key column for the...

below86 (10/22/2014)

---

Sean Smith-776614 (10/22/2014)

---

below86 (10/22/2014)

---

I like the idea of this but the only issue I have is this, If I want to run this against our production warehouse I'm not...

peter.mauss (10/22/2014)

---

Yes, it displays the

object_name, the column_name for each hit. It would be cool if it would also Display

the Name of the Primary key column for the object and its...

below86 (10/22/2014)

---

I like the idea of this but the only issue I have is this, If I want to run this against our production warehouse I'm not going to have...

Can you explain a bit more what you mean?

Glad you enjoyed it. 🙂

RD-201664 (10/17/2014)

---

The first time I played the computer sunk my entire fleet in 29 shots while I only scored 3 hits!!

Grrrr, the code must have BUGS!! 😉

Thanks for a...

Optional in a manner of speaking by setting default values. A good example is sp_who2.

I'm glad you liked it. It was a lot of fun to build (became a bit of an obsession at one point LOL).