Yes, pinning tables was done prior to SQL Server 2005. I think the reason it was depricated is that it was decided that SQL Server should have complete control over...

SSIS or Integration Services is Microsoft’s ETL tool. Essentially, it is a tool to move and manipulate data between various sources. You might move data from an Oracle server, to...

SSIS

You're right, I'm REALLY bad about using up all of my interview time. 😉

Thanks for your reply. I loaded up the query and ran it. But then I realized that...

There have been a lot of wise things said regarding the optimization of the query “SELECT * FROM table WHERE MONTH(datefield)=’mm’”, and I have to admit there were several issues...

Oh. I should also mention that external fragmentation should be as high as 100% if your clustered table/index has less than 9 pages; SQL Server allocates the first 8 pages...

Make sure you have enough contiguous extents to build the new index in and that you are attempting one index at a time rather than using the ALL option. If...