Reserved Keywords (Transact SQL) SQL Server | Microsoft Docs
Transact SQL reserved keywords can be used as identifiers or names of databases or database objects, such as tables, columns, views, and so on.
Understanding SQL Server Backup Types sqlshack
Partial backups. Partial backups are one of the least used backup methods available in SQL Server. All database recovery models support partial backups, but partial backups are mostly used in the simple recovery model in order to improve flexibility when backing up large databases that contain read only filegroups.
Bug: database server 'shutdown due to ... Paul S. Randal
Yep hit this multiple times on SQL 2012 in 2015. Worst it was production and the log was multiple TBs so took about 6 hours to come online (compounded by slow disk issues).
Simple script to backup all SQL Server databases MSSQLTips
Sometimes things that seem complicated are much easier then you think and this is the power of using T SQL to take care of repetitive tasks. One of these tasks may be the need to backup all databases on your server. This is not a big deal if you have a handful of databases, but I have seen several
Troubleshooting SQL Server RESOURCE_SEMAPHORE Waittype ...
Today, one of our SQL Server instances was performing very slowly. When I logged in to the database server to do some initial checks I noticed it was memory pressure from the initial observation. Next we had to find what out was causing our instance to ha
A SQL Server DBA myth a day: (20 30 ... Paul S. Randal
Great post (loving the series btw). And, I hate to be an ass (okay, sometimes I enjoy it – just not here)… but I worry that some folks will read the title of this, and not bother to look at your explanation.
SQL Bad Practices
The main reason why Microsoft introduced table variable in SQL Server 2000 is to reduce stored procedure recompilations (a recompilation occurs when the stored procedure execution plan is recreated).
SQL Server TOP clause performance problem with parallelism
If you look at the data above, ProductID 3 and ProductID 4 aggregated sale Quantities are equal to 11. So actually both qualify for the 3rd place, but With regular TOP with ascending order by only 1 will be chosen randomly, of course, there are many ways to fulfill the requirement, but SQL Server has TOP with Ties which is useful when you want ...
Performance Tuning SQL Server Change Tracking Brent Ozar ...
Are the right tables in Change Tracking? You need to know which tables are being tracked. The more tables you track changes on, the more SQL Server has to hoard in other secret tables, and the more it will have to clean up.
Hash Match SQL Server Fast
Introduction. The Hash Match operator implements several different logical operations that all use an in memory hash table for finding matching data.