Useful tips for everyday
How to start and use the database engine tuning advisor? On the Start menu, point to All Programs, Microsoft SQL Server, Performance Tools, and then…
How to create a default value for a column? In the Column Properties tab, enter the new default value in the Default Value or Binding…
What should I learn to be a DBA? In addition to certification from relevant software vendors, database administrators need to know the basics of computer…
How do I change the order of a column in Excel? Press and hold the Shift key, and then drag the column to a new…
Why does log _ reuse wait DESC remain log backup? Paul Randal has a great post that goes into details about the Log_Backup description. The…
How to convert a single column to multiple rows? Convert a single column to a range of data from row to row: 2. Then go…
What is Firebird Guardian? Firebird Guardian is a small application that is used to check whether the Firebird server is running and restarting or if…
How do I restore a database from restoring state in SQL Server? You need to use the WITH RECOVERY option, with your database RESTORE command,…
Can you group by month in SQL? SQL GROUP BY month is used to get the grouped data in a summarized way based on each…
How do you diagnose high CPU? The symptoms of high CPU usage are familiar: the cursor moves jerkily and slowly, and applications begin to lag…