David.Poole (8/27/2015)

---

I do take exception to the comment made in the article:

While I understand the pressure to adopt a SQL like language I do think it is a mistake to...

CDC is not available in Standard Edition.

There are other forms of SSIS DataFlow tasks that could do the job, but they put an unnecessary query load on the source...

That's a question I often ask a lot when someone speaks of a problem they are encountering...

greenclay (8/27/2015)

---

Sorry, but I have to ask - in the following sentence ---

I think that both the stick-in-the-mudes and fanboys have failed

That should be "muds" and not...

Wayne West (8/26/2015)

---

I think the most telling part of that comic is what the cursor hovertext describes. I've learned to ALWAYS read...

BTW, what exactly is a "Clock With Benefits" ?

Is that like a Friend With Benefits?

http://www.cafepress.com/+friends-with-benefits+clocks

I've found that well written set based T-SQL requires less time to code, runs faster, and is easier to read and maintain than spaghetti code. Unfortunately most organizations hire half...

dwain.c (8/25/2015)

---

Thank the Buddha for whoever came up with the idea of a Tally table in the first place! I just love 'em (but probably everybody knows that).

BTW. ...

So you're saying the number...

Welsh Corgi (8/25/2015)

---

WinMerge is very simple, just click File.. New.. which open two empty document tabs, and then paste result from two...

Using sys.dm_exec_procedure_stats or running procedure call with SET STATISTICS IO ON, can you determine if the number of logical or physical reads are significantly different between the two servers?

Maybe have your maintenance job leverage sys.dm_db_index_usage_stats to only update statistics on tables and indexes that received heavy updates since the last time the job ran. For example large but...

The following will return last update date for both table and index statistics.

SELECT 'TABLE' object_type, object_name(object_id)object_name, name AS stats_name,

STATS_DATE(object_id, stats_id) AS statistics_update_date

FROM sys.stats

UNION ALL

SELECT...

You've probably already considered this, but if you do go the route of summary tables, then perform incremental builds. In other words, if the fact table is inserted with daily...

The following query will return for each statement in a stored procedure:

execution plan, elapsed time, worker time (CPU), wait time (in blocked state), local reads, physical reads, and rows...