SQL Server 2012: Script to find uncontained objects of a Database

In this post, I am sharing a TSQL script to find the list of uncontained objects of a Database of SQL Server. SQL Server 2012 introduced a new concept of partial, contained databases to access few elements from outside its boundary. As per the MSDN official document, uncontained objects are those objects that cross the […]

February 11, 2016 SQL Server, SQL Server DBA Script

February 10, 2016

MySQL: Perform Case Sensitive string comparison

February 9, 2016

PostgreSQL: Important Parameters for better Performance

February 8, 2016

SQL Server 2012: Introduced LAG function, the best alternative of Self Join to compare Previous Row

February 7, 2016

SQL Server 2012: Introduced LEAD function, the best alternative of Self Join to compare Next Row

February 6, 2016

SQL Server: Find First NOT NULL Column using a COALESCE Function

February 5, 2016

SQL Server: The TempDB is Full, Shrink it or Move it

February 4, 2016

MySQL 5.7: Introduced EXPLAIN FOR CONNECTION to check the Execution Plan of Running Connections

February 3, 2016

SQL Server 2012: Create Sequence object to generate Alphanumeric Sequence Number

February 2, 2016

MySQL: Create FEDERATED Table using CREATE SERVER

Older posts Newer posts

About Me!