<?xml version="1.0" encoding="UTF-8"?><rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	xmlns:georss="http://www.georss.org/georss" xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#" xmlns:media="http://search.yahoo.com/mrss/"
	>

<channel>
	<title>DECISION STATS</title>
	<atom:link href="https://decisionstats.com/feed/" rel="self" type="application/rss+xml" />
	<link>https://decisionstats.com</link>
	<description>Better Decisions === Faster Stats</description>
	<lastBuildDate>Mon, 10 Aug 2026 06:35:48 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>
	hourly	</sy:updatePeriod>
	<sy:updateFrequency>
	1	</sy:updateFrequency>
	<generator>http://wordpress.com/</generator>
<site xmlns="com-wordpress:feed-additions:1">2245452</site><cloud domain='decisionstats.com' port='80' path='/?rsscloud=notify' registerProcedure='' protocol='http-post' />
<image>
		<url>https://secure.gravatar.com/blavatar/d336d6df5f72ded22bce06883a2ee2c996d78ac0ad720272c24535dd705a9fc9?s=96&#038;d=https%3A%2F%2Fs2.wp.com%2Fi%2Fwebclip.png</url>
		<title>DECISION STATS</title>
		<link>https://decisionstats.com</link>
	</image>
	<atom:link rel="search" type="application/opensearchdescription+xml" href="https://decisionstats.com/osd.xml" title="DECISION STATS" />
	<atom:link rel='hub' href='https://decisionstats.com/?pushpress=hub'/>
	<item>
		<title>SQL Window Functions: Ranking, Running Totals, LAG, LEAD and Moving Averages</title>
		<link>https://decisionstats.com/2026/08/10/sql-window-functions-ranking-running-totals-lag-lead-and-moving-averages/</link>
					<comments>https://decisionstats.com/2026/08/10/sql-window-functions-ranking-running-totals-lag-lead-and-moving-averages/#respond</comments>
		
		<dc:creator><![CDATA[Aviral Gupta]]></dc:creator>
		<pubDate>Mon, 10 Aug 2026 06:35:48 +0000</pubDate>
				<category><![CDATA[Analytics]]></category>
		<category><![CDATA[data]]></category>
		<category><![CDATA[sql]]></category>
		<guid isPermaLink="false">http://decisionstats.com/?p=14615</guid>

					<description><![CDATA[SQL window functions are one of the most powerful tools for analytical queries because they calculate values across related rows without collapsing the original result set. Unlike GROUP BY, which reduces many rows into a smaller number of groups, a window function returns one value for every input row while adding an analytical column. The &#8230; <a href="https://decisionstats.com/2026/08/10/sql-window-functions-ranking-running-totals-lag-lead-and-moving-averages/" class="more-link">Continue reading<span class="screen-reader-text"> "SQL Window Functions: Ranking, Running Totals, LAG, LEAD and Moving&#160;Averages"</span></a>]]></description>
		
					<wfw:commentRss>https://decisionstats.com/2026/08/10/sql-window-functions-ranking-running-totals-lag-lead-and-moving-averages/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">14615</post-id>
		<media:content url="https://2.gravatar.com/avatar/283eba774214f34e58e5bc32c2ce8d9a28f5ab203bfa2c074415f226f01478af?s=96&#38;d=wavatar&#38;r=G" medium="image">
			<media:title type="html">aviralgupta0310</media:title>
		</media:content>
	</item>
		<item>
		<title>SQL Views &#038; Materialized Views: Designing, Securing and Optimizing Database Reporting</title>
		<link>https://decisionstats.com/2026/08/10/sql-views-materialized-views-designing-securing-and-optimizing-database-reporting/</link>
					<comments>https://decisionstats.com/2026/08/10/sql-views-materialized-views-designing-securing-and-optimizing-database-reporting/#respond</comments>
		
		<dc:creator><![CDATA[Aviral Gupta]]></dc:creator>
		<pubDate>Mon, 10 Aug 2026 06:33:08 +0000</pubDate>
				<category><![CDATA[Analytics]]></category>
		<category><![CDATA[data]]></category>
		<category><![CDATA[sql]]></category>
		<guid isPermaLink="false">http://decisionstats.com/?p=14612</guid>

					<description><![CDATA[SQL views provide a reusable interface over database queries without physically storing their result, while materialized views store the computed result for faster reads. A regular view is expanded into the calling query and is therefore always current, but the underlying computation is performed whenever the view is queried. A materialized view, in contrast, behaves &#8230; <a href="https://decisionstats.com/2026/08/10/sql-views-materialized-views-designing-securing-and-optimizing-database-reporting/" class="more-link">Continue reading<span class="screen-reader-text"> "SQL Views &#38; Materialized Views: Designing, Securing and Optimizing Database&#160;Reporting"</span></a>]]></description>
		
					<wfw:commentRss>https://decisionstats.com/2026/08/10/sql-views-materialized-views-designing-securing-and-optimizing-database-reporting/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">14612</post-id>
		<media:content url="https://2.gravatar.com/avatar/283eba774214f34e58e5bc32c2ce8d9a28f5ab203bfa2c074415f226f01478af?s=96&#38;d=wavatar&#38;r=G" medium="image">
			<media:title type="html">aviralgupta0310</media:title>
		</media:content>
	</item>
		<item>
		<title>SQL Transactions &#038; Concurrency: ACID, Isolation Levels, Locking, Deadlocks and Safe Patterns</title>
		<link>https://decisionstats.com/2026/08/10/sql-transactions-concurrency-acid-isolation-levels-locking-deadlocks-and-safe-patterns/</link>
					<comments>https://decisionstats.com/2026/08/10/sql-transactions-concurrency-acid-isolation-levels-locking-deadlocks-and-safe-patterns/#respond</comments>
		
		<dc:creator><![CDATA[Aviral Gupta]]></dc:creator>
		<pubDate>Mon, 10 Aug 2026 06:30:36 +0000</pubDate>
				<category><![CDATA[Analytics]]></category>
		<category><![CDATA[data]]></category>
		<category><![CDATA[sql]]></category>
		<guid isPermaLink="false">http://decisionstats.com/?p=14610</guid>

					<description><![CDATA[SQL transactions provide the foundation for reliable database operations by grouping multiple statements into a single logical unit of work. The ACID properties describe the guarantees that make transactions dependable: atomicity ensures that all statements succeed or none do, consistency preserves database constraints, isolation controls what concurrent transactions can observe, and durability ensures committed changes &#8230; <a href="https://decisionstats.com/2026/08/10/sql-transactions-concurrency-acid-isolation-levels-locking-deadlocks-and-safe-patterns/" class="more-link">Continue reading<span class="screen-reader-text"> "SQL Transactions &#38; Concurrency: ACID, Isolation Levels, Locking, Deadlocks and Safe&#160;Patterns"</span></a>]]></description>
		
					<wfw:commentRss>https://decisionstats.com/2026/08/10/sql-transactions-concurrency-acid-isolation-levels-locking-deadlocks-and-safe-patterns/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">14610</post-id>
		<media:content url="https://2.gravatar.com/avatar/283eba774214f34e58e5bc32c2ce8d9a28f5ab203bfa2c074415f226f01478af?s=96&#38;d=wavatar&#38;r=G" medium="image">
			<media:title type="html">aviralgupta0310</media:title>
		</media:content>
	</item>
	</channel>
</rss>
