Viewing 15 posts - 361 through 375 (of 1,353 total)
I join the chorus in that the answer is 4. It's one of the reasons that you specifically set a default measure or else you might get the super sum...
May 23, 2017 at 7:50 am
May 23, 2017 at 7:43 am
I'd enjoy seeing a realistic example of when a natural key for an employees (or personnel) table would beat an identity column as well.
I'm not sure the...
May 18, 2017 at 7:08 am
If you run In a transaction without committing, yes
Try it for yourself
I can't think that I've ever run truncates in a transactions. I only ever truncate ETL...
May 15, 2017 at 1:59 pm
Truncate logs the page deallocations
What, if anything, does that get you from a practical point of view? Does that allow the undoing of a truncation?
May 15, 2017 at 1:49 pm
As a general rule with large staging tables, I truncate if there are no indexes, primary keys, etc that would have to be dropped during the table load. If these...
May 15, 2017 at 10:19 am
Temp tables are automatically dropped, so they don't have to remember to go back and drop the table that contains data that is only useful to them to help...
May 13, 2017 at 4:16 pm
Why does it have to be a temp table? I use a permanent table for my SLA calculations.
May 12, 2017 at 1:52 pm
I DO understand your point of view
That makes you smarter than me because I really don't understand why you would simply forfeit such vital tools. I've been...
May 5, 2017 at 6:09 am
Has not failed because like the PK constraints, SQL Server is not going to ignore WHERE NOT EXIST randomly.
This is like playing a game a soccer without the...
May 4, 2017 at 6:42 am
Use one cube and apply dimension permissions to each company for their data only.
Given that the initial description has some ambiguity and certain details would need to...
April 28, 2017 at 12:40 pm
use perspectives
I would not use perspectives in this case. Perspectives are not a security measure, and from what I gather from the initial description companies cannot...
April 28, 2017 at 12:20 pm
It doesn't sound like you're creating an OLAP solution, but rather creating the SSAS database on top of the OLTP solution. If this is the case, I would strongly recommend...
April 25, 2017 at 1:39 pm
Can you show me up an execution plan from Access?
The versions of Access that I used regularly (Access 95 - 2003) and learned TOP 1 * did not have...
April 25, 2017 at 7:21 am
I wonder if this would matter in MS Access. Up to now I've continued my use of SELECT TOP 1 * that I've used since using it in Access (which...
April 24, 2017 at 2:53 pm
Viewing 15 posts - 361 through 375 (of 1,353 total)