For all the reasons Gail stated, high memory consumption is actually a feature, not a flaw. Any time you can avoid going to disk and read pages from memory...

jasona.work (9/26/2015)

---

Ed Wagner (9/25/2015)

---

Okay, it's a bit of a haul for me, but it'll be good to know if I ever find anyone who actually has one. It would...

The title had me intrigued. If there's no time for testing, then it's no time to code. We all encounter emergency situations where people want things done right...

I'm curious as well. I always use sys.sql_modules to query procedure and function definition and I've never encountered a case when it's wrong. The columns is an nvarchar(MAX),...

Bowser

Kristen-173977 (9/26/2015)

---

Very entertaining video of a presentation by Rob...

Finding everything that calls your SF is going to be difficult. You can use sys.sql_modules for everything in the database, but if you have any code outside the database,...

If you want a tested solution, please take the time to read the article pietlinden and Jeff mentioned. There's also a link to it in my signature. Please...

J Livingston SQL (9/25/2015)

---

USE tempdb

GO

-- create a test proc in tempdb

CREATE PROCEDURE usptest

AS

SELECT * FROM #temp

GO

-- following code will not remove proc from SSMS

-- but does prevent it showing in...

MotivateMan1394 (9/25/2015)

---

Thank you All

I checked it with server team.

Most likely It's related to new backup server . It has a drive with 2 T.byte size.

Although they say...

If the point of the OP was to test ISNUMERIC, then ample information and Jeff's article has been provided and I won't offer anything different. The function does what...

Sean Lange (9/25/2015)

---

Wayne West (9/25/2015)

---

Sounds like the ERP system used by a previous employer. ...

jasona.work (9/25/2015)

---

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Dang...

Now I'm going to have to leave it to the wife...

SQLRNNR (9/25/2015)

---

Eirikur Eiriksson (9/25/2015)

---

...and...

jasona.work (9/25/2015)

---

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Dang...

Now I'm going to have to leave it to the wife which one we...