Useful tips for everyday
Where is the MDF file located? Default Location of MDF File in SQL Server Files that are common and used by all instances on a…
What is pages and extents in SQL Server? The page is the fundamental unit of data storage in SQL Server. An extent is a collection…
How do I restore an SQL MDF file? Using Enterprise Manager Expand the registered SQL server. Right-click Databases, select All Tasks -> Attach Database… Click…
How to duplicate a schema in MySQL database? Duplicate a schema in mysql database, without dumping sql files and execute them. It would be great…
Is JOIN faster than 2 queries? Try running some database statistics against both the JOIN and the multiple SELECTS. See if in your environment the…
How do you find the maximum value in another column of a table in Excel? If you want to place the maximum value in another…
How do I query a datetime format in SQL? SQL Date Format with the FORMAT function Use the FORMAT function to format the date and…
Does the order of WHERE clause matter in SQL? No, that order doesn’t matter (or at least: shouldn’t matter). Any decent query optimizer will look…
How to do nested SQL SELECT COUNT Stack Overflow? Depending upon what you need you could do one of a couple things. Using your second…
WHY IS NULL values avoided in a good design Why are NULL values used? It states that the corresponding value is either unknown or undefined.…