[SQL Server 2008 issues] How to Design Data Staging Area in a Data Warehouse

---

• How to Design Data Staging Area in a Data Warehouse
• Problem in 1 Billion Records Table
• How to merge below two SQL query in single one..?
• backup
• SSRS EMAIL subscription not working in 2008 r2
• prerequisites to install SQL cluster
• Giving permission for each table within a database
• fragmentation in database
• instead of triggers
• instead of triggers

How to Design Data Staging Area in a Data Warehouse Posted: 24 Mar 2013 07:21 PM PDT HI I am a trainee in Business Intelligence, I was asked to list the Best Practices of Designing a Data Staging Area. The Best Practices including the Architecture, Development and Maintenance. What infrastructure is needed and should it be on the same database as the Data Warehouse.

Problem in 1 Billion Records Table Posted: 24 Mar 2013 03:34 PM PDT Hi,I have one huge table which has 1Billion records. I tried to delete unnecessary records but it took a lot of time to delete and the delete was unsuccessful.Now my data is 26,491,552KB and index 20,569,168KB. Now inserting and updating process become very slow. What is the best way to handle the table to make it faster read and write access.Thanks in advance.

How to merge below two SQL query in single one..? Posted: 24 Mar 2013 06:14 PM PDT [size="2"][font="Courier New"]Hi All,I have these two queries and I want to merge into single sql query..Select KWMENG, NETWR, NTGEW, MATNR, AUDAT, KUNNR from vbap where matnr = 'FG153765464081221' and KUNNR = 'HA127' and AUDAT >= '2013-01-01 00:00:00.000' AND AUDAT <= '2013-02-13 00:00:00.000'Select FKIMG, NTGEW, NETWR, MATNR, FKDAT, KUNRG from SALES_DATA where FKDAT >= '2013-01-01 00:00:00.000' AND FKDAT <= '2013-02-13 00:00:00.000' and AUBEL = '0000042644' and AUPOS = '110'[b]Output of these queries are[/b]KWMENG NETWR NTGEW MATNR AUDAT KUNNR2.000 256.80 45.594 153765464081221 2013-01-24 00:00:00.000 127 FKIMG NTGEW NETWR MATNR FKDAT KUNRG[b]Required Output[/b]FKIMG NTGEW NETWR KWMENG NETWR NTGEW MATNR KUNNR0 0 0 2.000 256.80 45.594 153765464081221 127How to do this to get above output..?Note:- Just to make it easy I have stated above two scripts by passing Hardcore values but actually this I am doing dynamically.. [/font][/size]

backup Posted: 24 Mar 2013 04:52 PM PDT I have transactions 1,2 ,3 and 4 .1,2 are committed and the rest are uncomitted , when i take t-log backup whether all transactions are recorded in t-log or else only the 1&2 are recorded ?

SSRS EMAIL subscription not working in 2008 r2 Posted: 24 Mar 2013 05:35 PM PDT reports email subscription is not working in SQL 2008 r2 error we are getting 'sending mail the requested body part was not found'.Please help me on this

prerequisites to install SQL cluster Posted: 24 Mar 2013 04:54 PM PDT prerequisites to install SQL cluster?

Giving permission for each table within a database Posted: 21 Mar 2013 01:37 AM PDT I want to give different permission for different tables within a single database for a user.For example a user has full permission to a table while for another table only read permission.How it can be done within a database?

fragmentation in database Posted: 24 Mar 2013 01:59 AM PDT Hi apart of avg_fragmentation_in_percent in dm_db_index_physical_stats what other factor should be considered while considering table to be defragmentated eg table size , its row count ,size of data ?

instead of triggers Posted: 24 Mar 2013 01:25 AM PDT I came across this example regarding instead of triggersCREATE OR REPLACE VIEW dept_employees AS SELECT dname, ename FROM emp, dept WHERE dept.deptno = emp.deptno/Now there they explained that "Normally this view would not be updatable, because the primary key of thedepartment (dept) table (deptno) is not unique in the result set of thejoin view. "Can someone please explain as to what this statement tries to convey?

instead of triggers Posted: 24 Mar 2013 01:23 AM PDT I came across this example regarding instead of triggersCREATE OR REPLACE VIEW dept_employees AS SELECT dname, ename FROM emp, dept WHERE dept.deptno = emp.deptno/Now there they explained that "Normally this view would not be updatable, because the primary key of thedepartment (dept) table (deptno) is not unique in the result set of thejoin view. "Can someone please explain as to what this statement tries to convey?

You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 - General To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610