As I have informed you earlier in this post, there are some interesting tips I have contributed in August 2011. You may find them interesting if you follow them. The following are some of my tips I posted there
Most Learned Posts of all time
You can drop multiple tables using single DROP statementGoogle is also a calculatorSSMS Allows you to ask a question in the MSDN forum directly from SSMSUsing Partition Switching you can move millions of rows from one table to another in less than a second
Just Learned Posts for the month of July 2011
System databases cannot be mirroredYou can not create a new database without having model database in the serverGetdate(a) can be used as combination of tablename and alias nameRenaming a procedure using sp_rename is not recommendedUsing YEAR() function for a column in Where Clause will make query non-sargableFun in MathematicsSum of digits of the product multiplied by 9 is always 9Time to take to write the result of 10^10^10Result of 0/0General
Type domain name and press CTRL+ENTER to go to website directly
Tags: t-sql, sql_server, sqlserver, tsql, just_learned,