With all the new features in SQL 2008 R2, here are the major ones getting all the press: PowerPivot Parallel Data Warehouse Application and Multi-Server Management StreamInsight 256
Today, I have faced a very simple but still annoying problem. I was asked by a client that queries are not working correctly with given WHERE clause. Actually
One of the repetitive tasks that DBA need to perform is create maintenance plan for database. Maintenance plans enables you to automate maintenance activities for a database, backups,
Creating relationship between tables is not a big task, but I have noticed that many of us (especially I) want to create these relation in minimum time. We
Microsoft SQL Server Express 2008 R2 SQL Server 2008 R2 database is a a free and feature-rich database for developing and deploying desktop, web, and small server applications