sql-lover (3/27/2014)

---

Is someone else experiencing this problem, SQL2012, of course:

Violation of PRIMARY KEY constraint 'PK_MyTable'. Cannot insert duplicate key in object 'dbo.MyTable'. The duplicate key value is (1842649).

The statement has...

jpk 91966 (3/27/2014)

---

Anyone know how to get the disk space usage of a table by row?

Example:

I have table A with 1 million rows. I want to know how much space...

Koen Verbeeck (3/27/2014)

---

Is that absolutely necessary? It depends on the type of table and...

Congrats!

Here is one way.

create table #Something

(

ID int,

Name varchar(50),

Address varchar(50),

DateInserted datetime

)

insert #Something

select 1, 'Amy Paul', '2 Main St, Acton,MA', '2013/03/02' union all

select 1, 'Amy Claire Paul', '2 Main St, Acton,MA', '2014/01/09'...

JKSQL (3/26/2014)

---

For my own curiosity I wanted to know how to handle situations where developers ask for specific sprocs vs get all.

I have a table call Foo that has Id,...

No...

Hi and welcome to the forums. It looks like maybe you want a crosstab here. You can read about the technique by following the link in my signature.

If you need...

yuvipoy (3/27/2014)

---

Hi,

Can we have a GUID Column to primary key with nonclusterindex?

Is nonclusterindex is needed while we run the GUID column on WHERE Condition.

Say for eg i am having 50...

Loads fast now. Not sure what the issue was. I tried several times yesterday and no dice. I only have a couple of the scripts added to my briefcase so...

Nice question about a basic concept that many people don't understand. Given that at the time of post there are 30% wrong answers it seems this is something that many...

mdsharif532 (3/26/2014)

---

I have the Baseline number and I have to populate the next columns based on the following formula

2013 = Baseline + Baseline*0.055

2014 = 2013 + 2013*0.055

2015 = 2014 +...

This seems like it is pretty cool. It loads up the scripts section pretty fast. However, the favorites seems to be broken. I clicked on favorites and it asked me...

kishorreddy.yuva (3/26/2014)

---

I have a table with five columns as

ID Join_Date Join_Qtr End_Date End_Qtr

1 2014-01-12 2014Q1 2015-05-15 ...

mberran (3/26/2014)

---

Sorry, I didn't realize I selected the SQL 2008 forum. We are using SQL Server 2005 on both servers. The new server pretty much has upgraded OS...