[SQL server issues] Created Issue: AdventureWorksDW2012 Download file corrupt [19063]

Created Issue: AdventureWorksDW2012 Download file corrupt [19063]

There seams to be an issue with the AdventureWorksDW2012 Data file download. When I try to run this SQL statement:

CREATE DATABASE AdventureWorksDW2012 ON (FILENAME = 'E:\MSSQL11.SQL02\MSSQL\DATA\AdventureWorksDW2012_Data.mdf') FOR ATTACH_REBUILD_LOG;

This is the error I get:

Msg 5172, Level 16, State 15, Line 1
The header for file 'E:\MSSQL11.SQL02\MSSQL\DATA\AdventureWorksDW2012_Data.mdf' is not a valid database file header. The FILE SIZE property is incorrect.

Thanks,Dan

.

sqlserversamples.codeplex.com

[SQL Server Data Warehousing] How to make sure that Reporting services can access data during ETL of database

How to make sure that Reporting services can access data during ETL of database

We have SQL Server 2008R2, SSRS and SharePoint 2010. We don't have OLAP cube for reportings.

We have need to Truncate all tables and import all data every night. We are doing this during night, but SSIS tasks takes about 2h.  We do lot of calculations in SSIS and we have milions of rows in tables.

What is simple way to make sure that Reporting Services can get data 24/7?

Analyses Services OLAP is not available for us.

Ken

---

Kenny_I

.

social.technet.microsoft.com/Forums

[SQL Server Data Warehousing] Hai all,

Hai all,

Manish,Thank you so much.

I have one more question,

how do we refresh a database? is it that at once we refresh only one db at a time or we can refresh multiple db's at once?

so can u plz explain the process of refreshing database?

 

Raj,

You are welcome and thanks for visiting MSDN forum,

how do we refresh a database.

This following thread discussed about the same http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/d8b6990f-e851-4015-90a4-7b751d6b80a6

Its up to you, if you want to refresh occasionally you can do it manually for a single DB by following certain steps, else you can have automated scripts for multiple DBs too.

Please refer http://weblogs.sqlteam.com/tarad/archive/2009/02/25/How-to-refresh-a-SQL-Server-database-automatically.aspx

---

Thanks
Manish

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

.

social.technet.microsoft.com/Forums

[SQL 2012] Full Text - Confused

---

• Full Text - Confused
• Update Statistics Maintenance Plan
• SQL 2012 SSIS execution via stored procedure

Full Text - Confused Posted: 04 Jun 2013 01:17 AM PDT We implemented Fulltext on our system. No customization, no added stoplist. We turned off Stoplist on the FT Index.I have a data column that contains the following text "Point 5 CAD" defined nvarchar(255). We dont understand if we do [code="sql"]select * from Table where contains(column,'"Point" and "5" and "CAD"')[/code] we get no resultsif we do [code="sql"]select * from Table where contains(column,'"Point 5 CAD"')[/code] - we get rows returnedif we do [code="sql"]select * from Table where contains(column,'"Point 5 cad"')[/code] - we get no rows returned

Update Statistics Maintenance Plan Posted: 03 Jun 2013 05:59 PM PDT Hi AllI am using SQL 2012 SP1I have set up an update statistics maintenance plan to update the stats on all tables in my database - The job seems to be stuck at the beginning phase of the maintenance, this is where it queries the tables - It's been there for 10 hours and hasn't even got to the part where it actually updates any stats.I'm not seeing any waitsHas anyone else seen this before?Thanks

SQL 2012 SSIS execution via stored procedure Posted: 08 May 2012 01:50 AM PDT I have a SSIS package that I am try to execute via the stored procedures found in SSISDB.Here is my T-SQL:[code="plain"]DECLARE @execution_id BIGINTEXEC [SSISDB].[catalog].[create_execution] @package_name = N'PackageName.dtsx' , @execution_id = @execution_id OUTPUT , @folder_name = N'FolderName' , @project_name = N'ProjectName' , @use32bitruntime = False , @reference_id = NULLSELECT @execution_idDECLARE @var0 SMALLINT = 1EXEC [SSISDB].[catalog].[set_execution_parameter_value] @execution_id , @object_type = 50 , @parameter_name = N'LOGGING_LEVEL' , @parameter_value = @var0EXEC [SSISDB].[catalog].[set_execution_parameter_value] @execution_id , @object_type = 50 , @parameter_name = N'SYNCHRONIZED' , @parameter_value = 1EXEC [SSISDB].[catalog].[start_execution] @execution_idGO[/code]It says that it executes successfully, but when we check the tables where we are expecting the new records to be there is nothing. Although, if we just run the package via SSDT, all the records are there.Am I missing something stupid? We have tried calling this code from within our web app, and via SSMS, but niether "work".I am running SQL 2012 (obviously), I have granted the test user (that is calling the package) Read, Modify, Execute, and Manage Permissions on the Project, as well as Read, Execute Objects, and Read Objects on the Folder. These didn't help, the user continually got this message:[quote]Msg 27146, Level 16, State 1, Procedure create_execution, Line 167Cannot access the package or the package does not exist. Verify that the package exists and that the user has permissions to it.[/quote]Not until I added the user to the SSIS_Admin role was he able to execute the code, which as stated just returned that it was successful.Thanks in advance for you help.

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

[SQL Server Data Warehousing] How do delete a part data from partition

How do delete a part data from partition

We want to delete data (switch partitions) older than 2006 from a partitioned table. There is 2003, 2004, 2005 data that we want to switch, this comes to about 1.5 Billion rows.

While working on switching partitions, found out that up until 20071229, all the data is in one partition,

select @partition.TF_TBL_Fact_Store_Satles_trans(20071229) is 1. and switching partition, will switchout data up until this point.  I need to retain 2006 and 2007 data.

What is the best approach to this?

2006 and 2007 data is about 1.05 billion rows and older than 2006 is about 1.4 billiion rows(need to get rid of this 1.4B data and keep 2006/7).

How best can I handle this situation? Any inputs is much appreciated.

Thanks,

Suresh.

---

Suresh Channamraju

.

social.technet.microsoft.com/Forums

[SQL Server Data Warehousing] EXAMPLES OF DATA WAREHOUSE

EXAMPLES OF DATA WAREHOUSE

Hey I'm doing a University Work about Data Warehouse and one of the points is examples of data warehouse.

Someone can help me to develop this subject please??

.

social.technet.microsoft.com/Forums

[SQL Server Data Warehousing] Hai,

Hai,

What is  HP service manager  tool? is it ticketing tool, incident tool or release management tool?

Can anybody share your knowledge about what it is mainly used for and how does it work in real time scenario?

Thanks in advance

Raj.

.

social.technet.microsoft.com/Forums