Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383] [SQL server issues]

Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

pavanbarnala wrote Feb 23, 2012 at 10:47 AM

Hello,
Is this been taken care? If so, please share the latest data for DimDate. I'm working on some POC which requires dates in between 2008 and 2010 as well. If it is not already done, can someone let me know is there is any way I can generate the data for those missing dates in that table?

petermyers wrote Feb 26, 2012 at 5:21 AM

The attached script will fix the problem. Use the stored procedure to extend to future dates if needed.

Read more

sqlserversamples.codeplex.com

Created Issue: SQL Server 2008 Developer edition sample database install error [18174] [SQL server issues]

Created Issue: SQL Server 2008 Developer edition sample database install error [18174]

An unexpected error has occured.

description

I'm trying to install Adventureworks sample dB and i get an error.
I successfully downloaded the mdf file however when attach, add and click OK from SSMS I get the error:
 
Msg 5172, Level 16, State 15, Line 1
The header for file 'C:\Program Files\Microsoft SQL Server\AdventureWorks2012_Data.mdf' is not a valid database file header. The FILE SIZE property is incorrect.

Read more

sqlserversamples.codeplex.com

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

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

Read more

sqlserversamples.codeplex.com

Advanced SQL Server 2008 Extended Events with Examples [SQL Server]

Advanced SQL Server 2008 Extended Events with Examples

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

Read more

sqlteam.com

Testing with Profiler Custom Events and Database Snapshots [SQL Server]

Testing with Profiler Custom Events and Database Snapshots

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

Read more

sqlteam.com

Efficiently Reuse Gaps in an Identity Column [SQL Server]

Efficiently Reuse Gaps in an Identity Column

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

Read more

sqlteam.com

Using REPLACE in an UPDATE statement [SQL Server]

Using REPLACE in an UPDATE statement

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

Read more

sqlteam.com