It seems like SSMS has seen better days. Many developers I have worked with recently complain about Out of Memory issues and other bugs and I personally miss the days of Query Analyzer.
Maintaining a database is an important job of the DBA role. One of the many maintenance tasks is ensuring that the disk does not fill up and your files are able to grow over time.
Designing a rock solid application and database can be difficult. New features and overlapping features mean that you’re able to accomplish a single task in many ways. For instance the numeric and decimal data types. Which should you use?Read More »