(Brad M. McGehee) There is one thing every DBA knows with certainty, and that is that databases grow with time. MDFs grow, backups grow, and it never stops. The more data we have, the more work SQL Server has to perform in order to deal with it all; whether it’s executing a query on a table with 10

(Itzik Ben-Gan) T-SQL is a declarative querying language that lets you phrase your request in a logical English-like manner. The SQL Server database engine then processes the query. The relational engine (the query processor) uses the query optimizer to translate the logical request into a physical

For any web application, paging of records is a necessary requirement. We have written several posts in the past on how to achieve paging in Oracle, SQL Server and DB2 LUW. Those posts showed how paging can be achieved using CTE/custom procedural code/row_number() function (SQL Server), using rown

(Jason Thomas) How fast time flies! Another new version of SQL Server has been launched and it seems like it was only a few days ago that SQL Server 2008 was released. Those days, I was mainly focussing on SSRS, and I can’t express in words how happy I was when I saw all the new features in SSRS 200

(Tibor Nagy) I have been using Graphical Query Plans for some time, but I know that Text Plans are also available. I have looked at them a few times, but I don’t really understand how to relate what I know about the Graphical Plans to the Text Plan format.

(Jaime Tarquino) Usually the setup logs are not important when you installation is successful , but when something goes wrong and the setup fails is important to know where you can get more information beside the error message that is shown in the user interface.

(Buck Woody) Windows Azure as a Platform as a Service (PaaS) means that there are various components you can use in it to solve a problem:

(Cathy Dumas) Power View is the primary reporting client for visualizing query results for DirectQuery models. After all, it is the only graphical client that issues DAX queries.

(Vadivel) Often I find people aren’t making use of the benefit of SET STATISTICS IO and SET STATISTICS TIME while trying to tune their queries.

(VidhyaSagar) As you know there are so many security measures are taken during every release of SQL Server. This version of SQL Server will be using Managed Service account to run SQL server related services. In other terms earlier versions we used Local system account as service account for all SQL