SQL Server

Pro Members SQL Server Standard Members

Useful Undocumented SQL Server 2016 Stored Procedures (Part 1)

by

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting problems with locking in SQL Server 2016

by

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

How to Get Out of Your Own Way (And Make Faster Progress Towards Your Goals)

by

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2016 CLR Problems

by

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Can I Start a Business Without Money?

by

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,...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2016 Indexes (Part 2)

by

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,...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

A Holistic View of Database Management System (DBMS) – Part 8

by

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 –...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Amazon RDS Azure SQL Database Editorials SQL Server

I Don’t Need Backups – The Cloud Doesn’t Break!

by

Yes.  I’ve actually heard that several times lately.  We’ve been talking about recovery plans, backups, the “oh boy, Steve’s preaching test your backups again” documentation and so-on.  As we’re talking through the things they need to test and have experience with and document, they get this shifting-around, anxious to move on attitude. “But it’s the cloud.  It’s not like it’s […]

Continue Reading →
1 … 39 40 41 42 43 … 115