A list of the most frequently asked generic interview questions, from why you left your last job to what co-workers say about you. Think through your answers.
SQL SERVER – Quick Note on CROSS APPLY
A quick note on CROSS APPLY: think of it as an inner join to a table valued function that takes parameters, something a regular JOIN cannot do.
SQL SERVER – 2005 – Last Ran Query – Recently Ran Query
Want to see the last ran query on SQL Server 2005? This quick script uses sys.dm_exec_query_stats to list recent queries with the time each one ran.
SQLAuthority New – Best Practices for Speeding Up Your Web Site
Steve Souders of Yahoo! shared Best Practices for Speeding Up Your Web Site. I list his 14 rules, from fewer HTTP requests to Gzip and cacheable Ajax.
SQL SERVER – Fix : Error 15281 SQL Server blocked access to STATEMENT OpenRowset/OpenDatasource of
Error 15281: SQL Server blocked OpenRowset/OpenDatasource because Ad Hoc Distributed Queries is off. Turn it on in Surface Area Configuration or with sp_configure.
Adding a New Year Partition Before the Calendar Rolls Over
Add a new year partition before January data arrives by checking boundaries, preparing NEXT USED, splitting an empty range, and scheduling the work.
SQLAuthority News – Thank You to Blog Readers
Thank you very much to all my blog readers for reading SQLAuthority.com through 2007. I wish you the very best for the year 2008.
SQL SERVER – Remove Duplicate Characters From a String
A follow up to my Remove Duplicate Chars From String post: Madhivanan shows how to remove duplicate characters from a string with a Number table approach.
SQL SERVER – Change Password of SA Login Using Management Studio
How to change password of SA login using Management Studio: log in with Windows Authentication, open the SA login properties, set the new password and test it.
SQL SERVER – Difference Between Quality Assurance and Quality Control – QA vs QC
A Tea Time chat at our India office turned into a debate on Quality Assurance vs Quality Control. Here is a simple way to tell QA and QC apart.