momentueel (12/16/2016)

---

For this model I see the following dimensions:

1. Account

2. Transaction Type

3. Spending category (household, rent, income etc)

What have I done:

- I've created a staging table called stg_transactions...Datatypes are only...

I don't think there's anything built in to do that. It is pretty easy to get this kind of information on a scheduled basis and store it in a...

Ditto on the Lego building with the kids as someone else mentioned. We probably have way too much, as I have all the Legos from when I was a...

That dynamic management view shows you aggregated execution statistics for cached queries. SQL Server doesn't store information about each individual execution of the query. If someone is currently...

you can try looking in the Event Viewer at the System Windows Log, and look for items with a Source starting with Kernel

ps_vbdev (12/15/2016)

---

That's a good read thanks and I'm currently dissecting it. It looks to be what I'm after but I'm not sure how to apply it to my model. Our...

Senchi (12/14/2016)

---

MS SQLServer 2014

Correct me if I am wrong : I have to run 3 stored procedures to add a user to server and database ?

However, when adding a user...

the original post said both the source table and destination table are on SQL Server...

ps_vbdev (12/14/2016)

---

...Ive built a FactItemOrder table that displays everything at the lowest grain possible i.e. everything on users order. now the business will want to do analysis at this level...

Some housekeeping things to consider:

- if you use SQL Agent, clean old job history in MSDB https://msdn.microsoft.com/en-us/library/ms175044.aspx

- clean old backup history in MSDB https://msdn.microsoft.com/en-us/library/ms188328.aspx

- if you use DB mail, clean...

etl2016 (12/12/2016)

---

Hi,

I have a source table which is under SQL 2014 and I am doing ETL on it (no transformation logic - just one to one mapping). And this gets...

I guess I'm confused as to what has changed from last week? You still have this...

xsevensinzx (11/8/2016)

---

Interesting debate came up on data warehousing. Is it good to have multiple data warehouses or just one?...

Personally, I see no problem with multiple data warehouses if there is...

Offhand, I'm thinking the problem is the use of the @Counter variable in the recursive part of the CTE query. Maybe something like this instead:

with cte as (

...

If you're just sending the results of a query, you can...