rodjkidd (11/2/2015)

---

Really good summit.

My lasting memories will be;

The Threadizens taking over one of the birds of a feather tables (don't tell anyone), and the photo!

Gail's hat for ArgenisWithOutBorders - I...

It was awesome to get to meet some of the denizens of The Thread last week. Too bad Jeff Moden wasn't able to be there this...

Grant Fritchey (10/27/2015)

---

Great Summit so far. I've been able to talk to Gail & Lynn and Rod. Saw Gianluca as I was running between events. Any Threadsters I'm missing, track...

Does this work (can't test it, on a flight to Seattle)?

declare @startdate datetime = "20151126";

select dateadd(day,5,dateadd(month,10,dateadd(year,year(@startdate) - 1900 - 1),0)));

Did some one post an ad somewhere that said we had a surplus of silver spoons? :w00t:

One, not enough information to even write a query.

Two, based on the information provided this should be a relatively simple query to write.

You may want to read to the first...

Something like this?

SELECT

DATEPART(yyyy,tc.Call_Date) AS ArchiverYear

FROM

dbo.tblCall tc

INNER JOIN PrismDataArchive.dbo.ArchiveDriver AS Arch

...

chindilog (10/22/2015)

---

Below code works fine if I add timeworked.info in the group by. It doesn't worked without it. Basically below code gives the quantity, user and time worked. Since same...

mw112009 (10/22/2015)

---

FOUND THE MISTAKE.. ALL Set ....

Select object_name(SI.object_id) as tab_name,

( Select c.name from sys.columns c where object_id = SI.object_id AND c.column_id = SIC.column_id ) as [index_col_name]

from

sys.indexes SI...

mw112009 (10/22/2015)

---

Yep, works, thanks...

I changed it here and there ...

May I ask whether we could also do a similar query to identified PRIMARY keys ???

select distinct

A.name as tab_name...

Well, I see the problem, ORM Generated queries. They may be fine for trivial queries, but you really should write the more complex ones yourself to allow for performance...

Determine if ColumnA has duplicate values:

select

ColumnA,

count(*)

from

dbo.MyTable

group by

ColumnA

having

count(*) > 1;

Hopefully I...

david 70530 (10/20/2015)

---

Thanks Kristen

First I used the statement to figure out the trouble makers and there were about 8 or so records. I was going to delete them but decided...

The following will drop all foreign key constraints in your database. Be sure to remove the space between the d and e in the first statement.

d eclare @SQLCmd nvarchar(max);

set...

hlsc1983 (10/20/2015)

---

hi, i did but i am not getting any...