|
|
-
|
|
The 12th cumulative update release for SQL Server 2008 R2 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 12 contains all the hotfixes released since the initial release of SQL Server 2008 R2 SP1.
Those who...
|
|
-
|
|
In the last ten posts, we have discussed in details about the SQL server index and its storage structure. In this post I will consolidate all the ten post for easy reference.
What is index ?
In the first post, we have discussed about index in general. We...
|
|
-
|
|
Now we have discussed about different types of indexes in the last posts. In this post, let us discuss about the key column order (order of the column of indexes). The order of the key column of the index is decided based on the data access pattern an...
|
|
-
|
|
Better blog.mydomain.com or mydomain.com/blog? Good question! If got asked this question again via Twitter on the weekend so therefore I decide to share my experiences:
Choose a subdomain, if….
- You plan to offer “different services” which are “logic...
|
|
-
|
|
Recently I had to take care of the filestream corruption in SQL Server 2008 database, so I decided to share my experience. The error from DBCC CHECKDB was:
Msg 7903, Level 16, State 2, Line 1
Table error: The orphaned file “00005c8a-00006362-0001...
|
|
-
|
|
sys.dm_exec_query_memory_grants DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-IN/library/ms365393.aspx
Returns information about the queries that have acquired a memory grant or that still require a memory grant ...
|
|
-
|
|
I received an email from friend today asking how he can see when statistics were last updated in SQL Server. Well, in SQL Server, there are two ways to access the last modified date of a statistic, which are:
Through the header information using DBCC SHOW...
|
|
-
|
|
Microsoft SQL Server provides DBAs and Developers with several index related dynamic management views and functions, which they can use to maintain, modify, tune and identify missing indexes. Some of these dynamic management views (DMVs) and functions (DMF...
|
|
-
|
|
SQL Server stores all informational messages, warning messages, and errors in operating system and application log files. As a database administrator (DBA), it is our responsibility to review the information in the error log files on a daily basis for any ...
|
|
-
|
|
Before looking at the code, Read about – What is JumpStart?
We use Unity IoC container to achieve dependency injection for Web API. Create a ASP.Net MVC4 Project and its associated Class Library as shown in this tutorial – http://www.intstrings.com/r...
|
|