Good article, very interesting.

In the meantime you can use the one that I created.

I am working on an article I plan to submit...

As a general note, I suggest looking through this free book (free when downloaded as PDF): SQL Server Transaction Log Management by Tony Davis and Gail Shaw. It's the best...

You can't (not without making serious changes to your...

I'm thinking something like this...

WITH

scores(ID, creationdate, score, MCC) AS--SAMPLE DATA

(

SELECT 1, '2014-08-02', 30, 7422 UNION ALL

SELECT 2, '2014-08-03', 40, 7422 UNION ALL

SELECT 3, '2014-08-01', 100, 7500 UNION...

It looks like John beat me to it, if you can post a query plan that would be a great help - see: How to Post Performance Problems[/url]

I would second both recommendations and add that you can't go wrong with any Itzek ben-Gan book.

Learn what a tally table is; that has changed my career.

This site...

... I was thinking, using the logic in my previous post you could create a dbo.SubstringBeforeSSI function (examples included in the code)...

ALTER FUNCTION dbo.SubstringBeforeSSI

(

@string varchar(1000),

@substring varchar(100),

@substring_index tinyint

)

/*

DECLARE @string varchar(1000)='10.0.1600.22',

@searchPattern varchar(100)='.',

@substring_index...

This wont perform as well as what Eugene posted but is a solid, set-based way to solve this problem dynamically...

Using my Ngrams8k function:

ALTER FUNCTION [dbo].[nGrams8K]

(

@string VARCHAR(8000),

@n TINYINT,

@pad BIT=0

)

/*--

Created by:Alan Burstein

Created...

Another Approach:

;with

CurrentResutSet(Period, Sense, mt, Total) AS

(

select '2014_S27', 'CPT', 1, 215 union all

select '2014_S27',...

As Louis said, DDL and what you have tried will help us help you faster. That said, I think you are looking for this:

WITH

your_data AS

(SELECT *

FROM (values ('ClassA',10001,'Y','Eligible',1,1),

...

dagnea (9/16/2014)

---

...he insisted that the log file on the publishing database will not get truncated and will grow until the stopped subscription is started and the subscriber synched.

Does this make...

A couple variations (these will get you the same query plan as what rxm posted).

SELECT isnull(cast(id as varchar(12)),'Total'), sum(cnt)

FROM @rollup

GROUP BY id with rollup;

or...

-- since we're only...

I suspect they were talking about:...

:Whistling: