Thanks Mike - that was quick!

I get it now... I assume we'll be looking at tables later, so on with the Stairway!

Thanks again

John

What do you mean by "only"? What log file growth are you seeing? What other index rebuilds occur in the hour between the previous transaction log backup and...

Thanks Mike. I've been following the series so far and it's very enlightening! There's just one bit I'm struggling with:

Structured data is data loaded into tables in a...

Since it's a DR server, you're going to need a way to propagate changes to live jobs into DR, so why not use that same technique to do the initial...

Is your server Windows 2008? Perhaps that limits the available feature set for SQL Server 2016? (Although I'd have thought you wouldn't get past the first couple of...

You can't do it like that, for two reasons. First, you can't use a variable to represent the name of the stored procedure. If you don't know at...

Go to the topic in Books Online for each of the views and functions you're using. There'll be a Permissions section, which will tell you what permissions you need...

Is it being created by another job or by a store procedure? Query the command column of msdb.dbo.sysjobsteps, and the definition column on sys.sql_modules in every database to see...

Jamie

You need to choose a different instance name for the new installation, even if you are installing different features.

John

sp_update_alert

John

Perhaps we can all agree on the following?

* There are storage formats and presentation formats

* The user/programmer cannot change the storage format, but he can change the presentation format

* The...

Well, that was just an example. You could have, for example, a start date and an interval as parameters to your report, and then calculate the other dates from...

Given that this is a data warehouse application, all the data is sourced from existing databases, so in theory it should be correct. That said I did work on an...

LTRIM only removes spaces. Use REPLACE to replace each "-" with a blank (""). Be careful if you have any non-leading "-"s that you want to keep, though.

John

Here's one way of doing it:

DECLARE @CurrentStartDate date = '20160718';

DECLARE @CurrentEndDate date = '20160724';

DECLARE @PreviousStartDate date = '20150718';

DECLARE @PreviousEndDate date = '20150724';

SELECT

(SELECT COUNT(WorkOrder)

FROM TableA

WHERE RequireByDate BETWEEN @CurrentStartDate AND @CurrentEndDate) As...