Microsoft has introduced an interesting and exciting new feature in SQL Server 2008; it is named the Resource Governor. It…
SQL Server divides the total memory dedicated to it into two parts referred to as Buffer Pool and Memory to…
Some Facts about TempDB The tempdb is a temporary workspace which is normally used for: • Storage of explicitly created…
SQL Server Concurrency Terminology Optimistic concurrency control inside the SQL Server 2005/2008 database engine technically means that row versioning is…
If you suspect that your SQL Server instance is having Disk I/O issues, these queries can help furnish proof that…
The query which can be used to identify Top Wait Stats is given below. It is used to Isolate top…
One of the important things I would recommend is not having transaction log VLFs be too large, with 500MB being…
Add article to Transactional Replication without Snapshot Re-initialisation To add a new article to a publisher efficiently without reinitializing whole…
SQL Server 2008 Transparent Data Encryption (TDE) A secure Environment can be built by designing a secure system, encrypting confidential…
Administration of Transactional Replication There are 3 types of Replication Types in SQL Server: 1. Snapshot Replication 2. Transactional Replication…
This website uses cookies.