Useful tips for everyday
How do I run SQL Tuning Advisor in SQL Server? To start the Database Engine Tuning Advisor from the SQL Server Management Studio query editor…
How do I make an RDS file read only? Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/ .…
How do you find where a stored procedure is called? To view the dependencies of a procedure in Object Explorer Expand Databases, expand the database…
What is transaction recovery in distributed system? Transaction recovery is done to eliminate the adverse effects of faulty transactions rather than to recover from a…
How do you calculate distance using latitude and longitude in SQL? This query calculate the distance in miles. DECLARE @sourceLatitude FLOAT = 28.58; DECLARE @sourceLongitude…
How does the SQL Server import and Export Wizard work? The Wizard uses SQL Server Integration Services (SSIS) to copy data. In SSIS, the basic…
How can I check table lock status? SHOW OPEN TABLES to show each table status and its lock. SHOW OPEN TABLES WHERE `Table` LIKE ‘%[TABLE_NAME]%’…
What size varchar should I use? Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 65,535.…
Why is MY SQL Server Configuration Manager not working? I also have this problem with the following series of events: I download the Windows Azure…
Is outer join allows null value? Since bit columns do not permit null values, a value of 0 appears in an outer join when there…