I have a table that logs a record containing a userid, a fileid and a date, one record inserted every time that file is downloaded.<BR><BR>I want to get the top 10 downloads by count for a given date ...

I had the recent good fortune to undertake a speaking tour in which I talked to eight chapters of the Professional Association for SQL Server (PASS) throughout the American Midwest and South. (You can ...

Maintaining a SQL Server environment is a potentially complex endeavor. Here are 10 tips for ways you can minimize complexity and reduce stress. Based on my SQL Server consulting practice, here are ...

Microsoft has introduced SQL Server 2012 to the world and it's time for IT professionals to start to come to speed on what's new. Microsoft has introduced SQL Server 2012 to the world and it's time ...

I have taught several classes on the new features of SQL Server 2008, made a Web Seminar and written a Whitepaper on the subject. I have also attended the SQL PASS Summit in Seattle where there were ...