Useful tips for everyday
Is it safe to restart SQL Server Agent? No. SQL agent restart will in no way effect the SQL Database Engine access. SQL Agent is…
How do you select and insert? The SQL INSERT INTO SELECT Statement The INSERT INTO SELECT statement copies data from one table and inserts it…
How long should records of transactions be kept? Broadly, records of a particular transaction, either as an occasional transaction or within a business relationship, must…
How do I reindex a SQL Server database? Rebuild an index In Object Explorer, Expand the database that contains the table on which you want…
Is SQL getting obsolete? 1 Answer. SQL is not obsolete nor is it becoming so. There are plenty of programmatic interfaces that make it less…
How to calculate the sum of the months in Excel? To sum by month, you can use a formula based on the SUMIFS function, with…
How can I get list of column names in PostgreSQL using query? How can I get a list of column names and datatypes of a…
How do you use if if inside? ‘if’ Statement – if inside if if inside if. You can put an if statement inside another if…
How many connections can SQL handle? 32,767 user connections SQL Server allows a maximum of 32,767 user connections. How can I see who is using…
How do I skip a grant table in MySQL? DANGER: RISKY OPERATTION Start session ssh (using root if possible). Edit my. cnf file using. sudo…