In this blog we are going to learn interesting things about the Sytem Databases.
The value of SQL Server system databases cannot be underestimated due to the significant amount of information residing in these databases. 1,779 more words
If you’ve never worked with windowing functions they look something like this:
SELECT name, max(create_date) OVER -- No this isn't meant to make sense (PARTITION BY lower(left(name,1)) ORDER BY owner_sid) FROM sys.databases; 312 more words
— By Lori Brown @SQLSupahStah
We recently were troubleshooting an issue where one client reported that the SQL instance was suddenly very slow. One of the things we do is check to see what queries are currently running in SQL by using the following query: 642 more words
— by Ginger Keys
According to best practices for a SQL environment, you should never place your test or development databases on a production server. However sometimes best practices are ignored, sometimes the DBA’s advice is disregarded ( 506 more words