T-SQL Window Functions on LessThanDot and at SQL Saturday 149
I recently completed a series of blog posts on www.lessthandot.com on T-SQL Window functions. The enhancements to SQL Server 2012...
2012-09-26
893 reads
I recently completed a series of blog posts on www.lessthandot.com on T-SQL Window functions. The enhancements to SQL Server 2012...
2012-09-26
893 reads
In this post, I will progressively go through processing a partition from full process, to incremental process, and finally to...
2012-09-19
790 reads
We are less than two weeks away from SQL Saturday #149 in Minneapolis on September 29, 2012 with two preconference...
2012-09-18
508 reads
First, I need to set the record straight – I am not a systems guy. When I need work done to...
2012-08-30
1,347 reads
When Jason ( B | T ) posted this assignment, I thought it would be a fun topic to write on. Before I...
2012-08-15
507 reads
As I started looking over my event calendar, I was amazed at how many events Magenic is sponsoring, hosting or...
2012-08-14
556 reads
The Open Data Protocol (OData) is an open specification created Microsoft to enable exposing data in a standard way from...
2012-07-23
1,278 reads
As noted in that great text, The Hitchhiker’s Guide to the Galaxy, “Don’t panic!” Excel 2013 will make even more...
2012-07-17
811 reads
This will be the easiest entry in this series. This is a reblog of an article I wrote last year....
2012-06-26
1,119 reads
I am pleased to announce that I will be speaking at the PASS Summit again after a four-year “break”. I...
2012-06-22
519 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Dipping my toes into the waters of Azure and of course before I get...
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers