Useful tips for everyday
Is there a faster way to shrink a database? The last time I did a shrink using SQL Server Management Studio, it took a few…
How do I calculate age in MySQL? Always use CURRENT_DATE with dob to calculate the actual age . DATE_FORMAT(FROM_DAYS(DATEDIFF(CURDATE(),’1869-10-02′)), ‘%Y’)+0 AS age; Above MySQL query…
What is SQL Server logical name? Logical file name of SQL Server data or log file is to refer the file inside SQL Server scope…
How do I check permissions on an Oracle package? Access control for system views and supplied packages Use the following command to see the list…
How do I find the error code in SSIS? How to get error description in SSIS dataflow Choose the ErrorCode from the available Input columns.…
How do you update NULL? UPDATE [table] SET [column]=0 WHERE [column] IS NULL; Null Values can be replaced in SQL by using UPDATE, SET, and…
Which failover type is supported under the asynchronous commit availability mode? forced failover The only form of failover supported by asynchronous-commit mode is forced failover…
What is SQL Server capacity planning? Capacity planning isn’t just figuring out how much disk space we need, it also involves the resources that a…
How do I add a NOT NULL column to an existing table in DB2? Procedure To add a column, issue the ALTER TABLE statement with…
How the float data type values can be stored? In this case, the value is stored in its approximate form with the least significant digits…