(Stephen Baron) We’ve released a number of great enhancements to further improve the DocumentDB management experience

(Koen Verbeeck) At a project we have multiple filegroups created in our SQL Server data warehouse. For example, there was a filegroup to store the fact tables on, a filegroup for the dimensions, a filegroup for heavy indexes and so on. This works great at first, but after a while when people come an

(Chris Shaw) Have you ever noticed when you are working on a query for SQL Server and the second time you execute the query it runs much faster than the first time you had executed it? There is a reason for this and most likely it is caused by your buffer.

(Matt Bowler) What is it about 4:45 pm on a Friday afternoon that makes CPUs spike, drives crash, databases corrupt? I wish I knew but I don’t. I do know that I have been on the receiving end a few times. Just shutting down the last applications when a call or a page comes in. Next minute you’re pho

(Prashanth Jayaram) This post is one of the request from OP.

(Marcin Policht) One of the primary benefits of Platform-as-a-Service (PaaS) offerings hosted by Microsoft Azure is considerably minimized management overhead. This principle also applies to Azure SQL Database, which eliminates the need to administer and maintain the underlying hardware, operating s

(Pinal Dave) I have been blogging for almost 8 years now. I believe I have seen pretty much every single kind of email and comments I can receive from users. However, there are sometimes few which just are so interesting that I feel like blogging about it.

(Jeremy Kadlec) In our SQL Server environment we have a mix of SQL Server and Windows versions not to mention a mix of applications, hardware and server locations (on site, off site, in the cloud, etc.). This makes management, disaster recovery, high availability, etc. very difficult with 24×7 dem

(Greg Larsen) In my last two articles I discuss using the INSERT and UPDATE statement. These two commands added new rows and modified existing rows. In this article I will explore how to remove rows from a table using the DELETE statement.

(Dinesh Asanka) QUOTENAME is function which has been available since SQL Server 2005. This function returns a Unicode string with the delimiters added to make the input string a valid SQL Server delimited identifier, such as in the below example