Frequently asked Scripts during Interviews

1.Select no of Months between two dates:

SELECT    DATEDIFF(MONTH,'4/1/2011','01/23/2013')+    CASE        WHENDAY('4/1/2011')<DAY('01/23/2013')        THEN 1         ELSE 0     END
Output:
----------------
22

2.What will be the
output of following...

If You Need To Fix Database Filename Extensions

In a recent post I showed how the file extension for a database doesn’t matter. It can be confusing, however,...

Missing Data Quality Service (DQS) buttons in Excel

The Master Data Services add-in for Excel has Data Quality Services functionality to help you match data before publishing it...

New Year Aspirations – Jonathan Allen – DBA

Thanks for agreeing to do this Jonathan, I know you’re busy with arrangements for SQL Saturday #194 in Exeter
 
Before we...

SQL Server – Check Enabled Trace Flags for Server

In SQL Server you can enable a Trace Flag at session (effective for current session only) level and global level....

SQLSaturday 194 (Exeter)

It’s an exciting time for SQL Server Professionals in the South West of the UK, we’re now just a few...

5 MCM Readiness Indexing Videos You Should Watch

Earlier this year, I finally passed the Microsoft Certified Master (MCM) for SQL Server 2008 certification.  In the process of...

A Rickety Stairway to SQL Server Data Mining, Algorithm 4: Logistic Regression

  by Steve Bolton
              In the last installment of this series of self-tutorials on SQL Server Data Mining (SSDM), A Rickety...

Cumulative Update – 9 for SQL Server 2008 Service Pack 3 Is Now Available !

The 9th cumulative update release for SQL Server 2008 Service Pack 3 is now available. Cumulative Update 9 contains all...

Day 18 of 31 Days of Disaster Recovery: How to CHECKDB Like a Boss

Day 18 of my 31 Days of Disaster Recovery series is drawing to a close. It’s 11:22 PM here, and...