Home > Database > SQL Azure (Page 2)

T-SQL Query Optimization in MS SQL Server, The all important WHERE clause

As an T-SQL Developer, we always tend to wonder why my query takes considerately more time when everything is set on the server including indexes, fragmentation, fill_factor, etc,... Well, these things are important for the performance of your query but another important thing that we usually miss is the structuring of

This Article is TAGGED in , , , , . Read more

Simple way to generate connection string from text file

Common issue generally every developer faces in his initial days of development is how to generate connection string that connects my application to the database. Especially when we don't have sql management studio installed or if we are facing licensing issues.Well, a text file can come to a rescue.  To overcome such

This Article is TAGGED in , , , , , , . Read more