Useful Undocumented SQL Server 2016 Stored Procedures (Part 1) SQL Server 2016 supports the following useful undocumented stored procedures: sp_MSforeachdb sp_MSforeachtable sp_MSindexspace sp_MStablespace sp_readerrorlog sp_MSforeachdb The sp_MSforeachdb database engine stored procedure is used to perform the same actions for all databases. Sometimes, you need to perform the same actions for all databases. You can create cursor for this purpose, or...
Standard Members
Troubleshooting problems with locking in SQL Server 2016
Troubleshooting problems with locking in SQL Server 2016 If you have problems with SQL Server 2016 locking, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many locking bugs were fixed in SQL Server 2016 service packs, you should install the latest SQL Server service pack. At the time this article...
How to Get Out of Your Own Way (And Make Faster Progress Towards Your Goals)
How to get out of your own way (and make faster progress towards your goals) Today’s question comes from a busy professional owner: How do I get out of my own way and make faster progress towards my goals? What are some steps I can take? What you are looking for is a CPS (Career Positioning System). Career Positioning System...
Troubleshooting SQL Server 2016 CLR Problems
Troubleshooting SQL Server 2016 CLR Problems If you have problems with SQL Server 2016 Common Language Runtime (CLR) objects, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 CLR bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At...
Can I Start a Business Without Money?
Can I Start a Business Without Money? Today’s question comes from a busy entrepreneur and small business owner: I’ve been unemployed for a few months now. Could I still start a business without money? I’m curious because I’ve read about it but never made a decision. So I do believe that the answer would help me. Without knowing your talents,...
Troubleshooting SQL Server 2016 Indexes (Part 2)
Troubleshooting SQL Server 2016 Indexes (Part 2) If you have problems with SQL Server 2016 indexes, review this troubleshooting checklist to find potential solutions. 1. You can get the error 1775 when create a foreign key constraint. This error indicates that you cannot create foreign key because it references object whose PRIMARY KEY index is disabled. To resolve this problem,...
A Holistic View of Database Management System (DBMS) – Part 8
A Holistic View of Database Management System (DBMS) – Part 8 ALGEBRA For Relations Relational database systems are supposed to be armed with a query language which can help its end users to execute any query on the database instances. There are basically two (2) types of query languages: 1. Relational algebra and 2. Relational calculus. 2. Relational Calculus –...
A Holistic View of Database Management System (DBMS) – Part 7
A Holistic View of Database Management System (DBMS) – Part 7 RELATIONAL DATA MODEL The relational data model is the main data model that is castoff commonly around the world for data storing as well as treating. This prototype is simple as well as it has every properties in addition to the abilities needed for processing data with storage competence....
How to Build an All-Star Team of Employees
How to Build an All-Star Team of Employees Today’s question comes from a busy entrepreneur and small business owner: What do you look for when you’re building an all-star team of employees? Do you seek out those who fit into your company culture, focus on skill sets, or look for enthusiasm? (Or maybe all of the above!) We’re a small...
Troubleshooting SQL Server 2016 Indexes (Part 1)
Troubleshooting SQL Server 2016 Indexes (Part 1) If you have problems with SQL Server 2016 indexes, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 indexes bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time this...