Just Learned summary - A Month of July, 2011

So many things I have learned for the SQL Server and I have posted as "Just Learned on beyondrelational.com." Really Just Learned give us the opportunity to learn, contribute and share so many things for all the technologies.

Here I would like to give a summary of all the posts for SQL Server, which I published in the month of July, 2011.

• Staging table must be created on same filegroup as Partition table while Partition Switching
• How to know which Partitions belongs to which Filegroups for Partition Tables
• How to create ASPState Database for Session State Management 
• NOT EXISTS vs LEFT OUTER JOIN to retrieve data from two tables
• DB_NAME(0) will return current database name
• We can change default Home page and Search page of Web Browser in SQL Server Denali
• Set default database for user in sql server to avoid any accidental mishaps
• SSIS - Set DelayValidation to "TRUE" in Send Mail Task to prevent file existance check
• CONCAT - Used to concatenate two or more strings
• EOMONTH - Returns End Date of Month
• FIRST_VALUE() and LAST_VALUE()
• IIF function - Returns one of two arguments, depending on the evaluation of expression
• FORMAT - Returns formatted value from specified format of DATETIME
• PERCENT_RANK() and CUME_DIST()
• sys.dm_server_services
• PERCENTILE_CONT() and PERCENTILE_DISC()
• LEAD() and LAG()
• TRY_CONVERT()
• PARSE()
• TRY_PARSE()
• FORCESEEK and FORCESCAN
• Plan Cache is now available with Database Engine Tuning Advisor (DTA)

You can read all my posts for Just Learned from the beginning. You should also share and contribute in just learned which you know something new. Finally, I would like to thank all the readers, learners, contributors and participators in "Just Learned" at beyondrelational.com.