Useful tips for everyday
How do I restore my AG database? To restore this backup on a development instance, right-click on the development [SQLShackDemo] database and navigate to Tasks…
How is an SQL query evaluated? The EVALUATE operator is used in the WHERE clause of a SQL statement to compare stored expressions to incoming…
How to import a large sql file into MySQL? Open MySql Command Line Client from the Start menu. Enter your password used in install. That…
How many columns can be created in MySQL table? 4096 columns MySQL has hard limit of 4096 columns per table, but the effective maximum may…
Are there foreign data wrappers for PostgreSQL server? There are now a variety of Foreign Data Wrappers (FDW) available which enable PostgreSQL Server to different…
What is Mysqldump? The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database…
Is the average wait time for SQL too high? Recently we started to receive many alerts from SCOM : Alert: SQL 2008 DB Average Wait…
What are the causes of MySQL performance issues? 1. Resource bottlenecks (I/O, Memory, CPU) As part of our Server Management Services, we monitor our customers…
How do you sum within a table? Click the table cell where you want your result to appear. On the Layout tab (under Table Tools),…
Are database triggers good or bad? Triggers are a requirement for any complex data integrity rules. These cannot be enforced anywhere except the database or…