The system DMV sys.dm_os_schedulers is an useful DMV to find such as running tasks & active workers threads etc. This is required to monitor the system state is heavily loaded or not, in particular this view will help you identify if there is any CPU bottleneck in the SQL Server machine. SELECT ...

Coming to the basics of Transactional Replication, that starts with a simple snapshot of publication database data. Similar to the name the process is carried upon the fashion of transactions and subsequent data changes and schema modifications made at the Publisher are usually delivered to the Subscriber as they occur (in near real time). So the ...

What advantages we took when deployed the 64-bit computing within SQL Server As you aware 64 bit computing with 64-bit processors have become the standard for systems ranging from the most scalable servers to desktop PCs. The way to take full advantage of these systems is with 64-bit editions of Microsoft Windows products. Same way SQL Server has ...

Error: An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes Provider,error:40-Could not open connection to SQL Server)) You might have seen the above error very ...