Jeff Moden (2/21/2015)

---

I guess my point is that while there is the difference in Nullability, an NC-PK isn't really going to have any I/O advantage over a Unique NCI as...

Quick trigger example, should be sufficient to get you passed this hurdle.

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_SECONDARY_TABLE') IS NOT NULL DROP TABLE dbo.TBL_SECONDARY_TABLE;

IF OBJECT_ID(N'dbo.TBL_PRIMARY_TABLE' ) IS NOT NULL DROP TABLE...

Quick suggestion (if I got the question right 😉 )

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_Group') IS NOT NULL DROP TABLE dbo.TBL_Group;

CREATE TABLE [dbo].[TBL_Group](

[Id] [int] NULL,

[Title] [varchar](100) NULL

);

IF OBJECT_ID(N'dbo.TBL_GroupProd') IS NOT...

Quick LAG window function solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_LOG') IS NOT NULL DROP TABLE dbo.TBL_LOG;

CREATE TABLE dbo.TBL_LOG

(

InfoDate DATE ...

TomThomson (2/20/2015)

---

Steve Jones - SSC Editor (2/20/2015)

---

I think that there shouldn't be any difference between a PK and unique index, whether CI or NCI, but perhaps there's some misunderstanding out...

Lynn Pettis (2/20/2015)

---

Ed Wagner (2/20/2015)

---

Lynn Pettis (2/20/2015)

---

SQLRNNR (2/20/2015)

---

Ed Wagner (2/20/2015)

---

Eirikur Eiriksson (2/20/2015)

---

SQLRNNR (2/20/2015)

---

Lynn Pettis (2/20/2015)

---

Couldn't post this morning, Internet was down for a long time due to a cut cable.

......

SQLRNNR (2/20/2015)

---

Lynn Pettis (2/20/2015)

---

Couldn't post this morning, Internet was down for a long time due to a cut cable.

... Mark one off, 8 days on the calendar to go. 8...

Quick thought, if the code is called very frequently then there will be a huge...

In order to provide any meaningful answer, some more information must be provided, i.e. are the two tables in the same database, different databases on the same server, different SQL...

You were lucky this time, maybe it's time to implement source control and other recognized development practices;-)

😎

ramana3327 (2/19/2015)

---

Hi,

We have a database. It is enabled for mirroring. We need to delete the old records. That is around 500k records from a table. But it has foreign key...

Quick thought, unless you have 2 x LotsOfRAM on a single server, run ArcGis and SQL Server on two separate servers, my guess is that if those two start to...

Quick thought, the reason for passing parameters as string works in SQL is the implicit type casting it performs. This does not exist in VB/C# and therefore the data type...

Only 1001 to go:-D

😎

stpii (2/19/2015)

---

Hi!

Working in a project using Entity Framework (Code First)...

Until now the project has been connected to a (generated) SQL Server Compact 4.0 database,

but now we want to connect to...