Browsing Category
Database Administration
Accessing Oracle database via Linked Server through 64bit SQL Server
Installing Oracle 11g 32bit & 64bit clients would be a resolution of the famous 64bit OraOLEDB issue.
Accessing an Oracle DB over a 64 bit system was a pain for many SQL Server DBAs. The purpose of this document is to explain how to…
Execute The Distributed Transaction in SQL SERVER
Implementing a distributed transaction across multiple instances of databases is one of the most commonly used items which are less known by developers and DBAs.
Here we intend to outline a method for executing distributed transactions…
How to Monitor TempDB usage
Running out of disk space in TempDB can cause significant disruptions in the SQL Server production environment and can prevent applications that are running from completing operations. You can use the sys.dm_db_file_space_usage dynamic…