Random Number Generator. There are many methods to generate random numbers in SQL Server.
Method 1: Generate Random Numbers (Int) between Rang
SQL SERVER – Replication Keywords Explanation and Basic Terms
A quick reference of Replication keywords I wrote for Jr. DBAs: publisher, subscriber, distributor, publication and article, each explained in plain words.
SQL SERVER – Explanation SQL SERVER Merge Join
What a Merge Join needs and when it is fast: two sorted inputs with matching column types. Presorted B-tree indexes make it quick, extra sorts make it costly.
SQL SERVER – Restrictions of Views – T SQL View Limitations
SQL Server views come with many rules, like ANSI_NULLS and QUOTED_IDENTIFIER being on. My list of view limitations, corrected with help from Ben Taylor.
SQL SERVER – Good, Better and Best Programming Techniques
My notes for a programmers meeting on Good, Better and Best Programming Techniques in SQL Server, plus a funny bug ticket about a client who got no email.
SQL SERVER – Query to Retrieve the Nth Maximum Value
A query to retrieve the Nth Maximum Value from a table with a correlated subquery. Replace Employee and Salary with your own table and column, then set N.
SQL SERVER – Locking Hints and Examples
Locking Hints and Examples are as follows. The usage of them is the same but the effect is different. Let us learn it today together.