Tags » SQLSERVER
One of the things that I was frequently told during my schooling was to initialize the variables that I use in my programs and scripts. The obvious benefit of having such mentors is that it has now become a matter of habit for me to initialize every variable in my SQL scripts. 452 more words
There are few typical questions that developers ask when developing applications or when troubleshooting an issue:
What is the length of this string?
How many bytes does this string take for storage? 590 more words
By default SQL Server listens on TCP port number 1433, and for named instances TCP port is dynamically configured. There are several options available to get the listening port for SQL Server Instance. 701 more words