get sp_whoisactive from SQLBlog.com (v11.11 is latest last I heard) and use that to get all KINDS of important information about executions on your sql server

Smash125 (7/15/2012)

---

Have created Scalar User Defined Function and when i try to execute the function it fails.What could be the problem

Please find the function as below.

CREATE FUNCTION fnContactFullName(@ID INT)

RETURNS NVARCHAR(100)

AS

BEGIN

DECLARE...

1) If you don't need true ENCRYPTION, then using a hash will be much better since you can still get seeks against a NC index on the column. This...

chewychewy (7/15/2012)

---

Hi Guys,

Let's say my server has 16 GB physical ram. I have set the sql server max memory setting to 4 GB to cap it.

If my sql server doesn't...

Didn't fully read all posts here, but since this is a SQL 2008 forum, I would think MERGE would be the obvious solution that completely eliminates all concurrency/locking issues that...

You have views AND a table valued function in play here. There is no telling how complex and messed up the actual query is given those two things. ...

1) As Jack pointed out, you REALLY need to do SET BASED processing in your triggers

2) I would absolutely have THREE triggers for this stuff - one each for INSERT/UPDATE/DELETE....

SQLKnowItAll (7/10/2012)

---

TheSQLGuru (7/10/2012)

---

SQLKnowItAll (7/10/2012)

---

Well, I might have made an...

SQLKnowItAll (7/10/2012)

---

Well, I might have made an @$$ out...

Spot-on Gail, as always.

See this post: http://www.sqlservercentral.com/Forums/Topic1301588-1550-1.aspx#bm1302471

rocky_498 (7/8/2012)

---

Jeff,

Thanks for your reply and advice, if you can show me right path/ articles/tutorials that you can think is good learning for me that would be great, if...

Why are you converting to Nvarchar?? 2 bytes of storage for nothing there, isn't it?

I will guess that you are on VERY old hardware given your OS and SQL Server version. The best thing you can do in that case is to move...

weevil (7/5/2012)

---

Some great suggestions here guys, its a great help. I have a workshop with the client in a few days. It seems there is indeed more than...

ronald.dirkx (7/3/2012)

---

hi all,

we need to set up Transaction Log Shipping on a production server. The issue we are facing upfront is that it will be virtually impossible to make a...