No announcements
-
0 Votes1TB - 2TB Reporting database how much ram is needed?
Will 16GB or 32GB of RAM be enough for a reporting database with a size around 1TB-2TB ? Assumptions about the reporting database: - Every six month this database ...Answered | 1 Replies | 134 Views | Created by Hani Dean - Tuesday, December 24, 2019 5:25 AM | Last reply by KevinBHill - Tuesday, December 24, 2019 1:49 PM
-
0 Votes
MDW - No Data Available
I've setup MDW for the first time, with data collectors on the same server as the MDW database. Disk usage, query statistics and server activity data collectors are running. SQL agent jobs ...Unanswered | 4 Replies | 1552 Views | Created by JayMeerdink - Wednesday, February 28, 2018 6:59 PM | Last reply by Marcin Woszczyna - Tuesday, December 17, 2019 6:59 PM -
0 Votes
modeling facts involved in multi overlapping date based relationships
Hi we run 2017 STD. I have an environment with a Project Starts entity/table, a Staff Team Schedule entity/table and a Non Project entity/table. I'd like to build relationships amongst them to ...Unanswered | 5 Replies | 1314 Views | Created by db042190 - Wednesday, November 27, 2019 6:00 PM | Last reply by db042190 - Friday, December 13, 2019 1:13 PM -
0 Votes
Like on all Columns
Hi All, I need a query where I can use Like operator on all columns of a table. I cannot do Name like 'A%' or Desc like 'A%' ,etc ...Unanswered | 1 Replies | 388 Views | Created by Amit_Jha1 - Wednesday, December 11, 2019 2:17 PM | Last reply by Vaibhav-Chaudhari - Wednesday, December 11, 2019 2:27 PM -
0 Votes
How to deal with newly added columns on the data warehouse tables.
Hello, I'm trying to build an enterprise data warehouse on which we can run the business reports like KPI's, KRI's, SLA's, etc.. I'm wondering how the ...Unanswered | 7 Replies | 822 Views | Created by guest369 - Thursday, December 5, 2019 9:15 PM | Last reply by Guoxiong - Tuesday, December 10, 2019 8:38 PM -
0 Votes
my record field to be a symbol (?)
HI... <ASK> Dear my Master Friends this is my first case, i have copy MDF File from different PC. and i attach the file it's work but when i check the data, ... -
3 Votes
Memory Configuration
which buffer pool is used by the SSIS and SSRS. SQL Server or OS? What memory configuration required for data ware house(SQL Server 2016)? NareshUnanswered | 2 Replies | 706 Views | Created by Naresh Mali - Tuesday, December 3, 2019 5:24 AM | Last reply by TiborK - Tuesday, December 3, 2019 12:59 PM -
0 Votes
Creating a sequence number based on another column(s)
I have the following example data: Location and Invoice # and I need to add a third column that is a sequence number of the invoice lines at a ...Unanswered | 1 Replies | 647 Views | Created by Ross Stanek - Tuesday, November 26, 2019 8:54 PM | Last reply by JoeDBA_HaHaHa - Monday, December 2, 2019 7:06 PM -
0 Votes
Modifying table with large number of records
I have a table with about 400 million rows. I need to drop a hash column, add some new columns, set them to default of 0, set them to not null, and re add the hash column. Its taking hours ...Unanswered | 1 Replies | 1017 Views | Created by jschroeder - Friday, October 11, 2019 11:57 PM | Last reply by André Renato Furtado - Tuesday, November 26, 2019 9:01 PM -
0 Votes
Reduce secondary (.ndf) file size after import
Hi When I create a secondary data file (.ndf) and move the previous day's data from production server (SQL2014) to the archive server (SQL2017), the secondary file size is 4 times ...Unanswered | 1 Replies | 946 Views | Created by jambaii - Wednesday, November 13, 2019 8:15 PM | Last reply by André Renato Furtado - Tuesday, November 26, 2019 8:51 PM -
0 Votes
Trying to push a dataframe to Azure SQL Server
"mysqlserver.database.windows.net", "databaseName" -> "MyDatabase", "user" -> "username", ... -
0 Votes
Displaying a column not in the aggregate group by clause
I am looking at location sales and want to display each locations best sales day in units. The table has every locations units sales per day. The code below displays a locations best ...Unanswered | 4 Replies | 749 Views | Created by Ross Stanek - Tuesday, November 19, 2019 4:44 PM | Last reply by Guoxiong - Wednesday, November 20, 2019 6:59 PM -
0 Votes
Getting error while getting data from source using ssis data flow task
I am getting data from ADO.net source to load into the table using ssis but in the data flow task while getting from the source its giving the following ...Answered | 3 Replies | 65597 Views | Created by Shailendra17 - Tuesday, January 22, 2013 11:53 AM | Last reply by Heshie Brody - Wednesday, November 6, 2019 9:55 PM -
0 Votes
Variables in SSIS for setting any connection string
Hi Experts Can some one explain me or provide me an example of the topic "variables in SSIS for setting any connection string". I tried to Google ...Answered | 6 Replies | 4048 Views | Created by muzokh - Wednesday, March 19, 2014 8:22 AM | Last reply by Paul playing with BI - Wednesday, November 6, 2019 9:27 AM -
0 Votes
Creating the time (hour/minute) dimension
Hello Currently we have a time (hour/minute) dimension like this (screenshot below). This design was done by a coworker that has since left the team. This dimension is ... -
0 Votes
script external file format as does not show first_row setting
I am using SSMS V17.3 to access an Azure SQL Data Warehouse GEN2 as per example E I can create an external file format and set FIRST_ROW = ...Unanswered | 1 Replies | 759 Views | Created by ChipDale66 - Friday, November 1, 2019 2:27 PM | Last reply by Vaibhav-Chaudhari - Saturday, November 2, 2019 8:49 AM -
0 Votes
Testing frameworks for Azure SQL Data Warehouse
We actively use Azure SQL data warehouse and would like to test our stored procedures as part of CICD. I have looked into several options like tsqlt and SQL unit tests but none of them seem to ... -
0 Votes
Views or UDFs (or something else) for Data Warehouse Reports?
We are working on a data warehouse with a star schema. Our reporting tools will be SSRS and Tableau. However, we are having a debate within the team. Some people want to use views ...Answered | 3 Replies | 927 Views | Created by James H. Robinson - Monday, October 28, 2019 7:01 PM | Last reply by Tom Phillips - Thursday, October 31, 2019 11:54 AM -
0 Votes
Shipment Status Dimension Design
Hi Guys, We have Shipment Table Shipment Status table, is Shipment will have around 37 status, Does we need to go with simple Shipment Status Dimension ...Unanswered | 2 Replies | 836 Views | Created by Navind - Wednesday, October 30, 2019 3:47 PM | Last reply by Navind - Wednesday, October 30, 2019 5:22 PM -
1 Votes
Bridge tables VS Star Schema Data Model
As known, the bridge table is a powerful way to handle dimensions that take on multiple values when associated with the grain of a fact table’s measurement event. In a simple way, a ...Unanswered | 6 Replies | 1295 Views | Created by Test test tes - Friday, September 20, 2019 12:24 PM | Last reply by Test test tes - Sunday, October 27, 2019 12:40 PM - Items 1 to 20 of 2157 Next ›
No announcements
