This is a big topic and there's plenty of people on SSC that can answer this in detail. I think it's...

Eirikur beat me to it but I was going to say

The Microsoft Data Warehouse Toolkit, 2nd Edition

[/url]. This is the geared towards data warehousing in Microsoft environments specifically. If...

Quite frankly, I had to read it a few times to get it. It is extremely well-written but the subject matter is a bit heavy in my opinion. Well worth...

I have not passed the test yet but have been studying for it and think this book is really good:

Querying Microsoft SQL Server 2012 (MCSA) (Microsoft Press Training Kit)

I would...

Wrong version (the link is for 2008, this is a 2012 forum.

I periodically have to do this kind of thing. Take a look at:

Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets[/url] by Jeff Moden. This has...

The first thing that comes to is to save the the report as a PDF and then use some kind of utility that splits the PDF into seperate files. There's...

You might find this helpful.

Sample Resume: SQL Developer[/url]

Dave-148053 (2/5/2015)

---

I am most often returning all the columns in the table.

As far as the primary key, that's part of my "what's a good strategy" question. Should I be...

What columns are you returning? And why no primary key? The first index you need is a clustered index...

Edit: Added question about PK.

This is a duplicate post. Active thread can be found here:

http://www.sqlservercentral.com/Forums/Topic1658159-3412-1.aspx

Using the unpivot method in Dwain's article I came up with this solution...

(Note that I used 4 numbers for brevity)

USE SSRS_POC

GO

IF OBJECT_ID('tempdb..#tablewinners') IS NOT NULL DROP TABLE #tablewinners;

IF OBJECT_ID('tempdb..#tableguesses') IS...

Igor Micev (2/5/2015)

---

Alan.B (2/5/2015)

---

Igor Micev (2/5/2015)

---

Alan.B (2/5/2015)

---

Or you can run DBCC FREEPROCCACHE & DBCC DROPCLEANBUFFERS (caution: this will cause other queries to slowdown as they will need to recompile)....

Interesting...

I have never unpivoted a table, but I think I understand what it is your are saying. I will read up on unpivot to see how to make it...

Igor Micev (2/5/2015)

---

Alan.B (2/5/2015)

---

No this! It...