Articles

SQLServerCentral Article

Alternatives to SQL Backups

All of do us regular backups. Ok, all of us SHOULD do regular backups. In this article Andy comments on why having a backup plan isn't enough and why you should look at some other options for when you need to fix data errors. This really speaks to the goal of minimizing down time using low tech, readily available solutions. If you're not interested yet, we'll add this - one of the alternatives he suggests is Microsoft Access!

You rated this post out of 5. Change rating

2002-10-28

8,392 reads

SQLServerCentral Article

Querying XML files using SQL 2000

One of the many useful features gained by SQL Server 2000 is the ability to handle XML documents. This means that any computer language capable of opening an XML files and calling SQL Server stored procedures can make use of this new ability. This article by David Poole shows you how!

4 (1)

You rated this post out of 5. Change rating

2002-10-11

11,998 reads

SQLServerCentral Article

Snapshot Replication

Now that Andy has converted Steve Jones to a DMO believer we asked him to spend some time discussing replication. In this kick off article he discussion snapshot replication at a very high level - and looking for reasons to use it. This article isn't about how to do snapshot replication, it's about whether you should.

5 (1)

You rated this post out of 5. Change rating

2002-10-10

11,944 reads

Blogs

Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions

By

I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...

Counting Groups with Window Functions: #SQLNewBlogger

By

I looked at row_number() in a previous post. Now I want to build on...

Read the latest Blogs

Forums

How to determine if a DB is currently being used

By dax.latchford

Hi - I'm looking for advice regarding the best & quickest way to establish...

Data cleansing/conversion tool HPE

By juliava

Hello.   I am looking for a tool Data cleansing/conversion, was recommended HPE any...

System views in a contained availability group

By mark4data

I have a query that runs in a job to check on orphaned users....

Visit the forum

Question of the Day

The LAGging NULL

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  9
If 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