Thanks  John and Perry,

Sorry for the confusion.

CREATE VIEW [dbo].[View_1]
AS
SELECT RRN.ASettings.oid AS Expr1, RRN.BTType.oid, RRN.CSHistory.sId, dbo.CB.MainProfileID, RRN.Void.VoidID
FROM     RRN.ASettings INNER JOIN
                  RRN.BTType ON RRN.ASettings.oid...

GilaMonster (1/11/2017)

---

???

Also if i explicitly specify the cluster key in a nonclustered...

GilaMonster (1/10/2017)

---

Rechana Rajan (1/10/2017)

---

My doubt is when we create a Non clustered index the clustering key is already a part of it and then why adding PK column as included...

GilaMonster (1/3/2017)

---

Index on foreign keys is a good place to start, but it may not be the best index to have. It's only really needed if rows in the parent...

JasonClark (1/2/2017)

---

Yes, it's good practice to maintain indexing. As.

Performance becomes great on maintaining the relationship on a delete of a primary/unique key.

also, SQL Server can effectively find the rows to...

Why cant you create a new table and insert into that all records and delete the unwanted data from original table ? This will make sure the table...

Igor Micev (12/7/2016)

---

Rechana Rajan (12/7/2016)

---

When i script out tables from my local some have ANSI_PADDING ON and some dont have that mentioned before the create table state. Can anyone help...

Igor Micev (12/7/2016)

---

Rechana Rajan (12/7/2016)

---

When i script out tables from my local some have ANSI_PADDING ON and some dont have that mentioned before the create table state. Can anyone help...

Lowell (12/6/2016)

---

yes it could potentially cause problems. best practice would be to go ahead and schema-qualify all the scripts provided to avoid any issues.

The scenario i would worry about is...

Chris Harshman (11/22/2016)

---

DBCC TRACEON would need to be manually re-run after a server restart. If you use the startup parameters of the service then it will automatically have that...

Chris Harshman (11/22/2016)

---

If you grant the user privileges at the schema level instead of the database level, then they could create and alter procedures at will, but not be allowed...

GilaMonster (11/21/2016)

---

You can create a DDL trigger to roll back the DROP PROCEDURE, but if the user has CREATE & DROP permissions on the database, they'll be able to drop...

From what you have written I guess you job is trying to access backup file to restore it to another database.

Can you check whether the jobs are failing when restore...