Viewing 15 posts - 286 through 300 (of 1,354 total)
You're apparently taking a maintenance hit as well. I don't have a good system of maintaining schemabound chained views as I don't use them. But as already said, that's not...
January 19, 2018 at 12:19 pm
I'm assuming although you don't explicitly tell us that you have schemabound views on schemabound views. The views for which I use schemabinding are directly related to the base tables. ...
January 19, 2018 at 12:09 pm
Preppingfor an interview shouldn't be a cram session to learn more, but really a reviewof concepts you understand.
Exactly. At the moment I would...
January 12, 2018 at 9:15 am
If I understand the original question, the poster wants primarily to know if it can be used for training/demonstration purposes. There was an aspect of showing High Availability, but that...
January 9, 2018 at 8:58 am
Glad I didn't try to answer. I had it narrowed down to the two incorrect ones. Very useful information. Thanks!
December 13, 2017 at 7:24 am
reason I suggested that is because
I gathered your reasons from your brief statement. That doesn't change the fact that it is not a good idea. A...
December 12, 2017 at 4:02 pm
If you know they're enforced in the source data and you aren't modifying the data in the DW there is no reason to keep them.
There are...
December 12, 2017 at 9:35 am
Aliases should be short but representative of the table is some manor. For instance, I will use ospr as the alias for the table OperationsSIGACTPublishedReport.
I do it...
December 11, 2017 at 11:11 am
I would push back on anything that prefixes an object to tell you what type of object it is such as tbl, vw, fn, usp etc
I would...
December 8, 2017 at 7:31 am
First, it doesn't matter much.
Second, when I get to design to my naming convention, I use singular. Primarily because it's less typing, but secondarily because it's what the entity...
December 8, 2017 at 5:20 am
This is a pretty open question. You may want to consider hiring a consultant to get you started. Even that, unfortunately, can be a hit and miss. I got started...
December 4, 2017 at 7:13 am
Analysis Services gets very little love. I would love to see some tools built into Visual Studio to assist with cube development and troubleshooting especially around MDX calculations.
December 1, 2017 at 10:20 am
quote]
RonKyle - Friday, December 1, 2017 8:18 AM
December 1, 2017 at 10:19 am
I would like to be able to create a folder structure in the stored procedures folder to help with organization. I used to use the semi-colon numbering system, but that...
December 1, 2017 at 8:18 am
I'd like to see a showdown article on guids versus int identities since it is so hotly debated.
I'd like to see SEQUENCE numbers used in that evaluation. ...
November 28, 2017 at 1:02 pm
Viewing 15 posts - 286 through 300 (of 1,354 total)