SQL Tips and Tricks Archives - Page 237 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Generate Random Values – SQL in Sixty Seconds #042 – Video

February 6, 2013

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

Though it looks simple it is very difficult to generate random numbers which one can’t guess. There are many different ways to generate random values in SQL Server. I have previously blogged about it over here where I have demonstrated five different methods to generate random values in SQL Server.…

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

February 5, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Error Messages

Here is another example where the error messages are very clear but often developers get confused with the message. I think the reason for the confusion is the word “Key” used in the error message. After I explained this to a developer who sent me the error he realize that…

SQL SERVER – Fix Error: 8111 – Cannot define PRIMARY KEY constraint on nullable column in table – Error: 1750 – Could not create constraint. See previous errors

February 4, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

A very common error new developers receive when they begin with SQL Server and start playing with the keys. Let us first run following code which will generate an error 8111. -- Create Table CREATE TABLE test (ID INT, Col1 INT, Col2 VARCHAR(100)) GO -- Now create PK on ID…

SQLAuthority News – Reset Messaging (SMS/Text) Icon Count in Android Jelly Bean

February 3, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Personal Technology

Though, this blog post has nothing to do with SQL, this particular issue has been annoying me for a long time. I use Galaxy SIII updated with Android Jelly Bean. I am a big fan of this phone and I have written an efficiency tip about Android as well here…

SQL SERVER – Weekly Series – Memory Lane – #014

February 2, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…

SQL SERVER – Difference Between NOLOCK and NOWAIT Hints

February 1, 2013

Pinal Dave

SQL Tips and Tricks

Query Hint, SQL Lock, SQL Scripts, SQL Server

It is interesting to see how a blog evolves with the time and user interacts with each blog post. Earlier I wrote two of the blog posts on NOWAIT and SET LOCK_TIMEOUT. I have received very good response on this subject. Please read following two blog posts before continuing this blog post.

SQL SERVER – Significance of Table Input Parameter to Stored Procedure

January 31, 2013

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server, SQL Stored Procedure

SQL Server has introduced a functionality to pass a table data form into stored procedures and functions. This feature greatly simplifies the process of developing. The reason being, we need not worry about forming and parsing XML data. With the help of the table Input parameter to Stored Procedure we can save many round trips. Any SQL training will vouch for the fact that SQL is capable of accepting large, complex data in the form of parameters in a stored procedure.