|
|
-
|
|
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...
|
|
-
|
|
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 ...
|
|
-
|
|
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...
|
|