Replication in SQL Server
Replication is a way of distribution of database and their objects from one master database to one or more recipient databases...
2012-12-31
2,110 reads
Replication is a way of distribution of database and their objects from one master database to one or more recipient databases...
2012-12-31
2,110 reads
Log Shipping:- Log Shipping is a process of keeping the latest copy of the database of the primary database server...
2012-12-31
1,513 reads
Rebuild and Reorganization of Indexes:- SQL Server has the ability of maintaining the indexes whenever we makes changes (update, Insert,...
2012-12-31
2,725 reads
Fragmentation:- Fragmentation can be defined as condition where data is stored in a non continuous manner. In can be defined into...
2012-12-31
1,434 reads
HappyNewYear2013
May this new year bring lots of Happiness in all of your life. Let welcome 2013 together with lots of...
2012-12-31
1,290 reads
Wish you all a very happy and blessed festive season. May this festival of lights brings more brightness in your...
2012-11-13
687 reads
Boyce - Codd Normal Form (BCNF) :- A normal form is said to be a Boyce - Codd Normal Form if it is in...
2012-08-19
4,186 reads
Isolation levels :- Isolation level is required to isolate a resource and protect it from other transactions. This is achieved with...
2012-08-19
22,037 reads
Merge Command:- Merge command is a new feature introduced in the SQL Server 2008. It can perform Update, Insert and...
2012-04-17
1,727 reads
Many times we need to alter the table definition by adding , deleting or updating a column in the table. In...
2012-04-15
1,400 reads
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
By Steve Jones
mcfeely – adj. inexplicably moved by predictable and well-worn sentiments, even if they are...
How to install mysql-connector-python-8.4.0.zip it does not have setup.py. Checked also: mysql-connector-python-8.4.0.tar.gz
HI All, can any one reply on this when primary is down and not...
Comments posted to this topic are about the item The On-Call Load
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers