Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 270 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
SQL 2008 and "Rows Data"
cnicola
Member Posts: 181
Hi,
One of my clients bought a new server and installed SQL 2008 on it (64 Bit) and has transferred the db from the current SQL 2005.
When I look at the db properties in SQL 2008 I see that the datafile data type is set to "Rows Data" (in SQL 2005 used to be just Data and not even the help for SQL 2008 shows that option). Their IT guy says that SQL 2008 does that to support some (unnamed) features specific to 2008 (apparently it adds an unique row ID to every record according to him). It seems it is an option that you can select during SQL install.
Since I am paranoid by nature :oops: I do not like this new thing (I already have to worry about performance on the new server with Navision tuning) so I was wondering whether anybody knows anything about this and whether I should leave it as is or have the IT guy reinstall SQL without that option.
Thanks,
Cristi Nicola
One of my clients bought a new server and installed SQL 2008 on it (64 Bit) and has transferred the db from the current SQL 2005.
When I look at the db properties in SQL 2008 I see that the datafile data type is set to "Rows Data" (in SQL 2005 used to be just Data and not even the help for SQL 2008 shows that option). Their IT guy says that SQL 2008 does that to support some (unnamed) features specific to 2008 (apparently it adds an unique row ID to every record according to him). It seems it is an option that you can select during SQL install.
Since I am paranoid by nature :oops: I do not like this new thing (I already have to worry about performance on the new server with Navision tuning) so I was wondering whether anybody knows anything about this and whether I should leave it as is or have the IT guy reinstall SQL without that option.
Thanks,
Cristi Nicola
Apathy is on the rise but nobody seems to care.
0
Comments
I use SQL Server 2008 on my portable and I have seen row data.
I hit F1 on the field and found this:
Conclusion : I think that the Microsoft SQL server guys were bored of seeing "Data" and changed it to "Rows Data".
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!