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...

Matt Miller (#4) (8/24/2015)

---

Eric M Russell (8/24/2015)

---

When I write unit tests, it gets run in both development and QA. Each unit test is a script that maps to a specific...

When I write unit tests, it gets run in both development and QA. Each unit test is a script that maps to a specific functional requirement. A test plan lists...

All of the functionality you just mentioned (logging record counts, event handling, scheduling, email alerts, etc.) are basic functionality of SSIS and SQL Server Agent.

Jeff Moden (8/24/2015)

---

Eric M Russell (8/24/2015)

---

It seems to me that, even in the event of a catastrophic computer system failure, an airplane should still be functional enough to make an...

It seems to me that, even in the event of a catastrophic computer system failure, an airplane should still be functional enough to make an emergency landing under manual control.

maxlezious (8/24/2015)

---

Eric M Russell (8/24/2015)

---

maxlezious (8/24/2015)

---

Thanks for your reply!

I currently have a job setup which runs the stored procedure every week and inserts the usage figures in a table. All...