So lets say I have 5 databases, all with the same schema, but different data. I want to be able to build reports based on the data in all of those databases. How could I construct a view which would ...

Although tables in SQL databases typically contain massive amounts of data, they’re not always in a format that can be used by data analysts. The data records in these tables need to be filtered ...

Knowing exactly what in-memory OLTP tables are used for will help you make the most of one of SQL Server's newest features. While in-memory online transaction processing (OLTP) tables may sound like a ...

I'm importing a flat file into SSIS which needs to be split into two tables. In my input file I have a few columns (just an example.. I'm not really working with boxes): Box contents, box weight, box ...

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...

SQL Server 2008 R2, which ships this month, allows end users to tap into the powerful business intelligence features of SQL Server via tight integration with popular Microsoft applications like Excel.