Early in September Andy posted an article that explained how to use DMO to reattach a lot of MDF's in a hurry AND challenged our readers to accomplish the same task in T-SQL. Today we announce the winning solution!
This is an update to a recent article that provides a step-by-step guide to clustering SQL Server 2000 and Windows 2000.
Pre-sliced peanut butter is on its way to U.S. store shelves in test markets - fact or fiction??
Download the source code today for a great method for SQL Server live monitoring.
If you are like me, you probably get lots of telemarketing calls. Here's a good one to use the next time you get called by a phone company.
This article examines some of the undocumented stored procedures that exist in SQL Server 7.0
A look at files and filegroups in SQL Server 7.0, including some optimization tips.
Learn how to take advantage of AWE memory to boost the performance of SQL Server 2000.
Tired of lugging all those reference books around? Check out this site that is sure to find a permanent home in your favorites list.
If your bookshelf looks like most in the technology field, you tons of tech books. This new product by IQ Destination allows you to virtually rent books.
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
Recently I received a cry for help over Teams. The issue was that an...
Hi - I'm looking for advice regarding the best & quickest way to establish...
Hello. I am looking for a tool Data cleansing/conversion, was recommended HPE any...
I have a query that runs in a job to check on orphaned users....
I have this data in a SQL Server 2022 table:
player yearid team HR Alex Rodriguez 2012 NYY 18 Alex Rodriguez 2013 NYY 7 Alex Rodriguez 2014 NYY NULL Alex Rodriguez 2015 NYY 12 Alex Rodriguez 2016 NYY 9If I run this code, what are the results returned in the hrgrowth column?
SELECT player , yearid , hr , hr - LAG (hr, 1, 0) IGNORE NULLS OVER (ORDER BY yearid) AS hrgrowth FROM dbo.playerstats;See possible answers