Constraints in SQL Server play a big role in keeping data accurate in a database. Within SQL Server there are several methods of doing this and one way is using constraints • NOT NULL – Indicates that a column cannot store a NULL value • UNIQUE – Ensures that each row for a column must …
CROSS APPLY vs INNER JOIN vs LEFT JOIN vs OUTER APPLY So you want to improve your SQL skills and have come across some new operators like JOIN and APPLY and are wondering when you should use them. In this blog, I will focus on the following operators in the simplest terms and show you …
SQL Server Functions Sometimes you read books on subjects about SQL Server and you just want to learn the basics, well here are the basics of SQL Server Functions Functions can be Scalar or Table-valued Scalar returns one value and Table-valued functions (TVF) returns…well a table of results and this are usually found in the …
So you have come across a problem in a SQL Server query where you want to find out if a value is null and if it is, use another value. Which function should you use, ISNULL or COALESCE? Well if you just want to do something simple and to evaluate the value to see if it’s …
I hate when a database in SQL Server goes into Suspect mode. If you a database administrator in SQL Server, one of the worst things that could happen to you is that you arrive at work one day and find out that one of your databases is in ‘Suspect’ mode in SQL Server. What does Suspect …
It’s still useful to know a DBCC command that you may need to perform on a server when your server is acting funny. Here are some common DBCC commands that you may need. DBCC Commands 1.DBCC CHECKALLOC DBCC CHECKALLOC checks page usage and allocation in the database. Use this command if allocation errors are found …
Use the discount code 30PEROFF until 15 March 2020 to get 30% off the yearly subscription. Use the discount code M10PEROFF until 15 March 2020 to get 10% off the monthly subscription. Join our Affiliate Program and earn 35% commission GUESS WHAT! SQL Server 2017 Developer Edition is free! Yes that is right, you can …