|
|
-
|
|
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...
|
|
-
|
|
The first installment for SQL Server 2012 Services Pack1 - CTP4 is available to download and test.
Earlier CTP3 (first public CTP) revealed the Self-Service BI capabilities for Office & SharePoint 2012 compatibility features. IN addition to this featur...
|
|
-
|
|
You may know how to configure the listening port for SQL Server database engine service, via SQL Server Program Group --> Configuration Tools --> SQL Server Configuration Manager by looking into protocols and choose TCP/IP. The port number can be identifie...
|
|
-
|
|
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...
|
|
-
|
|
Since SQL Server 2005 the lock escalation has been more effective to provide database consistency and concurrency.
Like it represents the data is modeled as hierarchy of objects in SQL Server, database --> schema --> table (--> table partition) --> pages. ...
|
|
-
|
|
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...
|
|