jasona.work (5/12/2016)

---

Michael L John (5/12/2016)

---

Ed Wagner (5/12/2016)

---

Agreed. Now...

Ed Wagner (5/12/2016)

---

Agreed. Now where's that launcher? ...

Lynn Pettis (5/10/2016)

---

Red Letter Day! Silver Spoon posted a helpful response to a question. Of course, it could just be a parrot response. But hey, it still...

1. Create a new database role, call it something like db_view_schema.

2. Add the users/groups into this role.

3. Grant VIEW DEFINITION to the desired schema's contained in the database to this...

monilps (5/9/2016)

---

Below is the create table script. When created Primary Key name and Index name are the same. If I change the name of Index then Primary Key name will...

Ed Wagner (5/6/2016)

---

Brandie Tarvin (5/6/2016)

---

Ever have one of those emergency "everything's down", only it's in Test/UAT. But it's still urgent because we're on a deadline to upgrade.

And, oh, we have...

What have you tried? Can you post this?

Also, we cannot see your data or your schema. Can you follow the link in my signature so we can properly...

Well, you could take the code that was provided and change the name from "t1" to "test" and try to figure it out.

In the slow plan, there is a RID lookup on the table [DB_FRMIS_det].[dbo].[MI_ORT_OrderRowTransaction_T]

Could there be a missing clustered index?

I suggest you compare the index structures for all of...

Learner44 (4/28/2016)

---

Because we do this exercise every week splitting one table into 4. So when we do this we don't care about what's in there into those 4 tables so...

Couldn't this have been simplified with the REPLICATE function?

SELECT REPLICATE(@CharsTobePaddedWith, @PadLenght) + @PaddedChar

I'm still wondering why you need to do this.

Luis Cazares (4/28/2016)

---

Read...

This may work

ALTER PROCEDURE Doc124NEW_new

(

@DMIGRATIONNEW nvarchar(255)

)

AS

SET NOCOUNT ON

SET XACT_ABORT ON

DECLARE @ErrorMessage varchar(2048);

DECLARE @ErrorSeverity INT;

DECLARE @ErrorState INT;

DECLARE @sql AS NVARCHAR(MAX)

DECLARE @Count int = 0

BEGIN TRY

BEGIN...

Not sure what you are trying to do, and why, but there is some basic things that may be able to be simplified, and, some basic logic flaws.

If the number...