|
|
-
|
|
As of now (this post written date) the Service Pack1 for SQL Server 2012 still in CTP4 stage for your own testing on enhancements, which will be ready in next few weeks time as a full RTM'd downloadable package.
During the preliminary testing the list of f...
|
|
-
|
|
Any statement that begins execution on a SQL instance, it will be compiled as a query plan which is taken care by query optimizer to produce the results (thinking an efficient manner). All such compiled query plans are stored in memory which is referred as...
|
|
-
|
|
As a DBA parallelism or MAXDOP terms do not need any special introduction, but it is highlgy essential to keep up the necessary settings (default value is 0) on your data platform. In many cases MAXDOP helps to achieve optimization for SQL Server processes...
|
|
-
|
|
It is very rare to see a hotfix or cumulative update for the product that is out of mainstream support (and soon out from extended support too). Also I don't normally blog on a Sunday, but 1 email from MS Security bulletin caught my eye and my knowledge sh...
|
|
-
|
|
When you attempt to connect to a SQL Server instance (freshly installed) and this is one of the commonly posted problem in the forums.
The first and foremost response from the forum post is to check whether Remote Connections option is enabled on that spe...
|
|
-
|
|
Until SQL Server 2005 SP3 I used to remember the version from the build number of SQL Server, however since 2008 version it was hard to remember due to the fact of cumulative update package releases.
Since the changes affected from SQL Server Release Servi...
|
|
-
|
|
The error was presented when one of the DBAs trying to setup a database maintenance plan for a newly deployed system which was looped into DB support. Just a background on the issue is the number of databases are defined here are setup by a third party too...
|
|
-
|
|
We got SQL Server 2008 R2 Service Pack2 to test and implement on your data platform, now you need to concentrate on Feature Pack for this version too that will help to enhance your programming/design/architecture/support projects.
Feature Pack as the name ...
|
|
-
|
|
Here is the news about another release of Service Pack for SQL Server 2008 R2 (10.5 version), service pack2.
This SQL Server 2008 R2 SP2 release consist all the hotfix and cumulative update package solutions from 1 to 5 (SQL Server 2008 R2 builds that wer...
|
|
-
|
|
Central Management Server (CMS), as the name suggests this feature enables the DBAs and System Administrators to administer multiple servers by designating a set of server groups, which maintain the connection information for one or more instances of SQL S...
|
|