Sean Pearce (1/21/2013)

---

Did someone steal your login credentials?

CREATE PROCEDURE TestErr

AS

DECLARE @Err NVARCHAR(255);

BEGIN TRY

SELECT 1 / 0

END TRY

BEGIN CATCH

SET @Err = 'Errrr';

RAISERROR(@Err,...

If it is as simple as what you provided... creating an index on Table2.FieldB will "probably" help. It will get rid of the scan and use a key lookup...

I would answer this for you, but it is easy enough to set up and test. Look at the execution plans both before and after the index...

Where exactly are you changing this? In a script? In a maintenance plan package? No matter which one... Please provide details of the script/package. My initial assumption is...

pdanes (12/19/2012)

---

David Webb-200187 (12/19/2012)

---

You could send a fixed terminating character on the end of your variable parameters and check to see if it is actually the last character in the...

pdanes (12/19/2012)

---

GilaMonster (12/19/2012)

---

pdanes (12/19/2012)

---

Don't you get a performance hit from passing a table over the network, rather than a single string? And I think the server would parse it a...

Don't you get a performance hit from passing a table over the network, rather than a single string? And I think the server would parse it a lot faster than...

It really depends on what you are doing with it. When the parameter is passed in and is 9000 characters, where does it get stored? It is not like...

I use this:

SELECT s.name, o.name, SUM(ps.reserved_page_count * 8),

SUM(CASE WHEN ps.index_id < 2 THEN ps.row_count ELSE 0 END)

FROM sys.objects o

INNER JOIN sys.dm_db_partition_stats ps

ON o.object_id = ps.object_id

INNER JOIN sys.indexes i

ON ps.object_id =...

I would say that in the case where a parameter is passed to the stored proc that does not match the size of a particular column (i.e. a delimited string),...

pdanes (12/19/2012)

---

GilaMonster (12/19/2012)

---

I'm going to be unpopular here but...

Dependency analysis?

Regression testing?

Unit tests?

Sure, making all parameters and variables varchar(max) would work. Shall we make all table columns varchar max too (if...

Well... The option is not there in the GUI in 2012,...

If you are using SQL Server 2008 (which I have to assume you are since this is a 2008 forum), you should use Transactional Replication with Updateable Subscriptions. This is...

Did you highlight it and try to run it? That's the best way to find out...