Sorry, I almost forgot about this post. I put together an example of how you would do what I was talking about; attached is the RDL so you can just...

chrisn-585491 (3/25/2015)

---

Plus F# isn't a wallflower. F# is the best of the functional first languages. If you are a serious developer and not just a CRUD developer, F# is a...

I am still working on a solution to this, (I thought I had something but just saw your reply to Jeff)...

In the meantime I came up with a better way...

This is a somewhat ambiguous request. Can you explain what the @NewID, @GroupID, and @i variables are for. We're those something you were attempting to use to solve this...

Not to take anything away from what joe put together for you I bet if you put Eirikur's solution into an inline table valued function it would perform much better...

Yep. I was one of those people. This thread brought back some memories.

I do all my SQL in SSMS. SS%S happens in Visual Studio.

I suspect he meant that...

Lowell (3/26/2015)

---

my fast proof of concept: drop and recreate is definitely slower

in a measly 1000 iterations,these were my stats:

2113 milliseconds for Drop and Recreate

543 milliseconds for Truncate Existing Table

and my...

Just to add to what Magoo said, if you don't have a dates table (and can't create one) you could create a stored proc that produces one like so (just...

I don't think there is anything wrong with Triggers when used for the right reasons and used correctly. I have seen people do bad things with triggers.

Dwain Camps recently...

There is no difference between truncating a temp table vs dropping/recreating it. Truncating and dropping/recreating a table can be measured in milliseconds.

As Alexander said - it would be good...

Had a few moments to kill...

USE tempdb

GO

-- It's always good to provide sample data in an easily usable format like so

CREATE TABLE dbo.

([year] int not null,

Client_Name varchar(100) not...

PHYData DBA (3/24/2015)

---

Alan.B (3/23/2015)

---

My apologies - I misread you original post a little. I was under the impression that some of these indexes were 10% fragmented weekly, not more than...

SELECT * FROM

(

SELECT LocationID, LanguageID ,LocationLanguageRecID,

row_number() over (partition by LOCATIONID

order by LocationLanguageRecID) LineNumber

FROM LocationLanguages

) X

WHERE LineNumber = 2

Luis Cazares (3/24/2015)

---

Alan.B (3/24/2015)

---

Luis Cazares (3/24/2015)

---

This is a quick idea.

WITH Letters AS(

SELECT TOP 26 CHAR(ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) + 64) letter

FROM...