You don't sound like a spoiled brat. Based on what I've read, it seems that you've done a lot of good work for your company even though they've chosen...

Yeah I'm not looking to create 30 data flows in the package as that would just be the same development effort for me. I was hoping to be able...

Nice trick; I'll have to remember that.

Thanks; on a good day I would have remembered this. Oh well.

I'm not preaching against the morality of copyright material nor do I wish to get into "holier than thou" discussions. I'm just saying that a lot of people would...

^Like copyright laws ever stopped anybody from downloading books, movies etc 😛

Thanks for the responses. Does MeasureUp offer lessons/learning material like the Microsoft Training Kits do or just practice tests?

Actually my table was compressed but even if I compress my index (both the table and index have page type compression), the index (with the include columns) still takes up...

I've just tried it without the include columns:

CREATE NONCLUSTERED INDEX [Product_ArrivalID]

ON [dbo].[Product] ([ArrivalID])

and the index takes up 50 % of the space that the data does but it still seems...

Hi BiCoolGal,

That seems like an unusual error message you're getting. Did you trying running the query under "Query Type = Text" instead of stored procedure. You may be...

Nevermind it appears this feature doesn't exist in SSRS http://social.msdn.microsoft.com/Forums/sqlserver/en-US/11eee199-7eb2-472e-b7da-76c25af62578/force-parameter-refresh-after-clicking-view-report?forum=sqlreportingservices

I would also suggest that you back up the table before removing the duplicates. Although the solution is nice and simple, the recovery is definitely not if you make...

"Since the processing happens in in-memory only, if there is any sudden growth in the Hekaton tables, we can cache less of your other tables."

Does this mean with SQL Server...

Thanks. I'll give it a shot.

Thanks for the replies. Any suggestions for the reading material? My concern is that in 3 weeks, the exam will be updated to include SQL Server 2014 material...