What are the downsides of using a VIEW instead of the table direct?
I'm thinking of a VIEW which is…
1 week, 4 days ago
By: Jeffrey Williams
Hello, SQL newbie here. I've got a question about the proper use of primary keys, hoping someone ca…
3 weeks ago
We have a table definition below with a columnstore index and nonclustered row indices. The data in…
7 months, 1 week ago
By: Grant Fritchey
Hi guys and gals. forgive me if this questions is in the wrong place, new to the forum and sql deve…
1 year ago
By: MVDBA (Mike Vessey)
I'm trying to figure out if this star schema works for counting the quantity of products in the war…
1 year, 1 month ago
I need to design to register the purchase and enter the products into the warehouse, make transf…
1 year, 2 months ago
I'm new to the forum and am helping to get a little education on something. I'm helpin…
1 year, 3 months ago
We currently have a 2 node dev cluster which I need to dismantle and either keep onl…
1 year, 4 months ago
Please help me out to design the database for online examination system.
1 year, 7 months ago
The general synopsis is that, apart from our company’s core products, we are now offering our cus…
Last week I was asked to write a SSRS report against a MySQL database. Never having worked with MyS…
Doctor Who 2
1 year, 8 months ago
By: Doctor Who 2
What is a good design to store unit of measures ?
We have a measure dimension with all the m…
1 year, 9 months ago
I have the following tables:
Customer Credit Card,
But a customer can a…
By: Eirikur Eiriksson
Come up with two design ideas as shown in the image but would like to understand which s…
1 year, 11 months ago
I've been asked if there is risks with the following architecture.
This only supports reporting pro…
Viewing 15 topics - 1 through 15 (of 598 total)
You must be logged in to create new topics.