Viewing 15 posts - 286 through 300 (of 1,353 total)
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
Adding my vote against the use of GUIDs except for certain circumstances. Replication comes to mind. With the sequence numbers, there's no longer any need to use them to maintain...
November 26, 2017 at 4:35 pm
Viewing 15 posts - 286 through 300 (of 1,353 total)