In some of these cases we obviously don't have time to go thru a proper development/test/deploy cycle. When quick data changes are needed, and that same change/fix is needed on...

Interesting article; Dwain requires that, for a given product, the EffectiveStartDT of the next timeline matches the EffectiveEndDT of the previous. This helps to enforce no overlapping dates for a...

Phil Parkin (3/17/2015)

---

..maybe gaps are ok. Otherwise, it's unclear why you would ever...

No Phil, this is doing the trick. I'm seeing the overlaps. Thanks!

In a perfect world, there are several ways to keep the logs smaller; i.e. Don't do everything in one large transaction. Batch it into smaller transactions. Your log shouldn't need...

Perry Whittle (3/9/2015)

---

first thing I would ask is what is the recovery model in use on the DW database?

I'm sure you've heard a hundred times "don't shrink your transaction logs".

If...

We also run a DWH with almost all the DBs in simple recovery mode. I run a script like this every night though I don't take the extra check of...

When saving the package to SQL Server, did you specify the entire SQL instance name?

Ken

I didn't start a transaction so there's nothing to roll back. Must have been one of those implicit transactions.

Anyhow, when I checked this morning everything had cleared out of the...

sp_helprevlogin doesn't do users;...

Nice use of MS_ForEachDB here. We don't use it much here because it's undocumented and can be a little picky with syntax. We use this type of construct to loop...

We have data retention jobs that hang sometimes and decided to do something similar; automatically kill them at a certain point.

SELECT * INTO #JobInfo

FROM OPENROWSET('sqloledb', 'server=(local);trusted_connection=yes'

, 'set fmtonly off exec...

Thanks a lot! SUSER_SNAME() is doing it.

Ken

At a minimum I think SSIS (MsDtsSrvr.exe) would need to run on the box.

Ken

reuben.anderson (4/10/2013)

---

p.s. all of which has meant I struggle to understand why an Integration Server is needed at all. An engine to execute packages may as well be included in...