Viewing 15 posts - 1,771 through 1,785 (of 2,458 total)
what is the difference between clustered and non clustered index
This is a big topic and there's plenty of people on SSC that can answer this in detail. I think it's...
-- Itzik Ben-Gan 2001
February 10, 2015 at 6:41 am
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...
-- Itzik Ben-Gan 2001
February 10, 2015 at 6:07 am
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...
-- Itzik Ben-Gan 2001
February 9, 2015 at 3:20 pm
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...
-- Itzik Ben-Gan 2001
February 9, 2015 at 3:17 pm
CooLDBA (2/9/2015)
Start with Exam 70-433 - TS: Microsoft SQL Server 2008, Database Development
Wrong version (the link is for 2008, this is a 2012 forum.
-- Itzik Ben-Gan 2001
February 9, 2015 at 3:10 pm
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...
-- Itzik Ben-Gan 2001
February 9, 2015 at 3:09 pm
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...
-- Itzik Ben-Gan 2001
February 9, 2015 at 12:42 pm
You might find this helpful.
Sample Resume: SQL Developer[/url]
-- Itzik Ben-Gan 2001
February 9, 2015 at 11:10 am
Dave-148053 (2/5/2015)
As far as the primary key, that's part of my "what's a good strategy" question. Should I be...
-- Itzik Ben-Gan 2001
February 5, 2015 at 4:35 pm
What columns are you returning? And why no primary key? The first index you need is a clustered index...
Edit: Added question about PK.
-- Itzik Ben-Gan 2001
February 5, 2015 at 4:02 pm
This is a duplicate post. Active thread can be found here:
http://www.sqlservercentral.com/Forums/Topic1658159-3412-1.aspx
-- Itzik Ben-Gan 2001
February 5, 2015 at 3:40 pm
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...
-- Itzik Ben-Gan 2001
February 5, 2015 at 12:12 pm
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)....
-- Itzik Ben-Gan 2001
February 5, 2015 at 11:29 am
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...
-- Itzik Ben-Gan 2001
February 5, 2015 at 11:18 am
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).
No this! It...
-- Itzik Ben-Gan 2001
February 5, 2015 at 10:49 am
Viewing 15 posts - 1,771 through 1,785 (of 2,458 total)