Ambiguity

Jeff Moden (5/10/2015)

---

Have you actually ever done a measurement on this subject? I could be wrong in some instances but it would appear the space savings are not true when...

Most common use I see...

GilaMonster (5/10/2015)

---

Eirikur Eiriksson (5/10/2015)

---

Ken Davis (5/9/2015)

---

I have a large table in a large database. The DB = 1.2TB and the big table is 70% of the DB or 840GB....

zogher (5/9/2015)

---

Hi,

Thanks for the reply.

Couple of things to note (yes, my example is rather simplified), I will try...

rkrpat (5/10/2015)

---

Hi,

We are working in a Merge replication environment where we have SQL Server 2005, 11 publications and 2 subscribers.

We used to get lot of incidents from the Application...

Quick suggestion, use OUTPUT parameter for the procedure

😎

/* Procedure #1 */

CREATE PROCEDURE [dbo].[GetUserIDbyUserName]

@UserName nvarchar(100)

,@UserID uniqueidentifier = NULL OUTPUT

AS

SELECT

@user-id...

Ken Davis (5/9/2015)

---

I have a large table in a large database. The DB = 1.2TB and the big table is 70% of the DB or 840GB. I would...

Quick solution which should be enough to get you passed this hurdle

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

CREATE TABLE dbo.TBL_A

(

nRef ...

Sequence

petervdkerk (5/9/2015)

---

A little explanation:

[giftregistry] is the general description of the list, the bridal couple in this is the only owner. They can add a text they want to send to...

Add a CTE for the conversion, then you can use the same code

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

CREATE TABLE dbo.TBL_XML_SAMPLE

(

XS_ID ...

One more thing, can you run DBCC CheckDB('[database name]') WITH NO_INFOMSGS, ALL_ERRORMSGS and post the full unedited output?

😎

Quick questions:

😎

1) The amount column in giftregistrypurchase table, is that the quantity of items?

2) In the same table, is the itemid the giftregistryitems.id?

Looking at the schema, I suspect that either...

Freyja