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.