My 2400th blog post is not a boast. After the sad event in Delhi, I write as a father and husband about women safety and why it matters to every Indian.
SQL SERVER – Generate Random Values – SQL in Sixty Seconds #042 – Video
There are many ways to generate random values in SQL Server. In this sixty second video I show a neat trick to get a random value between two numbers.
SQL SERVER – Fix: Error: 1505 The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name and the index name
Error 1505 says the CREATE UNIQUE INDEX statement terminated because a duplicate key was found. The word key confuses many developers, so I explain it simply.
SQL SERVER – Fix Error: 8111 – Cannot define PRIMARY KEY constraint on nullable column in table – Error: 1750 – Could not create constraint. See previous errors
New developers often hit Error 8111 when they try a PRIMARY KEY constraint on nullable column, followed by Error 1750. Here is why it happens and how to fix it.
Warning Before SQL Login Passwords Expire With DaysUntilExpiration
A Friday-night login failure is avoidable. One small query warns you weeks ahead, if somebody owns the warning.
Generating Random Numbers Per Row: RAND, NEWID and CRYPT_GEN_RANDOM
Generate random numbers per row with NEWID or CRYPT_GEN_RANDOM, compare seeded RAND, inspect bucket spread, and pick a row without a sort.
SQL SERVER – Difference Between NOLOCK and NOWAIT Hints
Should you use NOLOCK when NOWAIT errors out on a lock? Here is the difference between NOLOCK and NOWAIT, and why neither guarantees a valid answer.