Yesterday I wrote article about SQL SERVER – 2005 – Last Ran Query – Recently Ran Query. I had used CROSS APPLY in the query. I got email from one reader asking what is CROSS APPLY. In simpler words, cross apply is like inner join to table valued function which can take parameters. This particular operation is not possible to do using regular JOIN syntax You can see example of CROSS APPLY in my article here.
SQL SERVER – 2005 – Last Ran Query – Recently Ran Query
How many times we have wondered what were the last few queries ran on SQL Server? Following quick script demonstrates last ran query along with the time it was executed on SQL Server 2005. SELECT deqs.last_execution_time AS [Time], dest.TEXT AS [Query] FROM sys.dm_exec_query_stats AS deqs CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest…
Read MoreSQLAuthority New – Best Practices for Speeding Up Your Web Site
Steve Souders, Chief Performance Yahoo! Best Practices for Speeding Up Your Web Site. I suggest everybody should read this basic guidelines. They are extremely important for high performance websites. 1. Make Fewer HTTP Requests 2. Use a Content Delivery Network 3. Add an Expires Header 4. Gzip Components 5. Put…
Read MoreSQLAuthority New – Happy New Year 2008
Today is New Year and I wish you all Best for Year 2008. Let us all start our new year with motivational new year quote. We will open the book. Its pages are blank. We are going to put words on them ourselves. The book is called “Opportunity” and its…
Read MoreSQLAuthority News – Thank You to Blog Readers
Thank You very much for reading SQLAuthority.com for entire 2007 year. Wish you the BEST for year 2008. Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQL SERVER – Remove Duplicate Characters From a String
Follow up of my previous article of Remove Duplicate Chars From String here is another great article written by Madhivanan where similar solution is suggested with alternate method of Number table approach. Check out Remove duplicate characters from a string Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQL SERVER – Change Password of SA Login Using Management Studio
Login into SQL Server using Windows Authentication. In Object Explorer, open Security folder, open Logins folder. Right Click on SA account and go to Properties. Change SA password, and confirm it. Click OK. Make sure to restart the SQL Server and all its services and test new password by log…
Read More