How much difference is there between SQL server 2008 and 2012
-
I'm working on a PHP project, that started in SQL server 2000, and I just upgraded the PHP to support SQL Server 2008. Well now I would like to use OFFSET and FETCH to paginate long lists and I need 2012. I'm wondering if just next functions were added or if I need to change my dates again,
CONVERT(char(10) createDate, 126)to another format.If it ain't broke don't fix it Discover my world at jkirkerx.com
-
I'm working on a PHP project, that started in SQL server 2000, and I just upgraded the PHP to support SQL Server 2008. Well now I would like to use OFFSET and FETCH to paginate long lists and I need 2012. I'm wondering if just next functions were added or if I need to change my dates again,
CONVERT(char(10) createDate, 126)to another format.If it ain't broke don't fix it Discover my world at jkirkerx.com
Well, the major one would be that 2012 (v11) is still supported, while 2008 (10.5) isn't. I don't remember of breaking changes between those versions, though. A slightly better UI for SSMS, maybe. But nothing about date formats which would have changed. I just remember this was the time I started to install db systems on virtual machines rather than on physical ones. Regarding the date format you are talking about, the only way to be sure is to install a 2012 instance, copy the database, and test your queries and sp's against the new instance.
"Five fruits and vegetables a day? What a joke! Personally, after the third watermelon, I'm full."
-
Well, the major one would be that 2012 (v11) is still supported, while 2008 (10.5) isn't. I don't remember of breaking changes between those versions, though. A slightly better UI for SSMS, maybe. But nothing about date formats which would have changed. I just remember this was the time I started to install db systems on virtual machines rather than on physical ones. Regarding the date format you are talking about, the only way to be sure is to install a 2012 instance, copy the database, and test your queries and sp's against the new instance.
"Five fruits and vegetables a day? What a joke! Personally, after the third watermelon, I'm full."
Yeah your right, give it a test spin, instead of trusting someones word on this. Good call Phil. I'll call the computer company that created my remote DEV environment and have them ass that. The DB is 26 gigs and it would takes days to get it from a remote machine.
If it ain't broke don't fix it Discover my world at jkirkerx.com
-
Yeah your right, give it a test spin, instead of trusting someones word on this. Good call Phil. I'll call the computer company that created my remote DEV environment and have them ass that. The DB is 26 gigs and it would takes days to get it from a remote machine.
If it ain't broke don't fix it Discover my world at jkirkerx.com
Well, if you know precisely which datetime fields caused you troubles, you don't need 26 Gb of data. Having migrated a bunch of servers from MSSQL 2008 to MSSQL 2012, I don't remember having to modify any table, sp or query for it to just work. But, after all, I don't know anything about this database of yours, so these are just my 2 cents.
"Five fruits and vegetables a day? What a joke! Personally, after the third watermelon, I'm full."
-
Well, if you know precisely which datetime fields caused you troubles, you don't need 26 Gb of data. Having migrated a bunch of servers from MSSQL 2008 to MSSQL 2012, I don't remember having to modify any table, sp or query for it to just work. But, after all, I don't know anything about this database of yours, so these are just my 2 cents.
"Five fruits and vegetables a day? What a joke! Personally, after the third watermelon, I'm full."
Your right, if the data is stored the same, then it's just a matter of code adjustments, in which I have already made.
If it ain't broke don't fix it Discover my world at jkirkerx.com
-
I'm working on a PHP project, that started in SQL server 2000, and I just upgraded the PHP to support SQL Server 2008. Well now I would like to use OFFSET and FETCH to paginate long lists and I need 2012. I'm wondering if just next functions were added or if I need to change my dates again,
CONVERT(char(10) createDate, 126)to another format.If it ain't broke don't fix it Discover my world at jkirkerx.com
-
When you say "convert your dates again" - why are you using strings for dates - surely just casting as a Date would be better?
I'm working on a project written by 3 Chinese kids from China that were here at UC Irvine to study back in 2000 written in PHP over the course of 8 years. They made some bad choices in database design and I'm not about to change the database since I don't have a full understanding of how the program works. Well I do now after rewriting the PHP since Feb 2021. These kids had disrespect for HTML as well, and the worst programming disciplines I have ever seen. In PHP 7.4, converting the date to a ISO formatted string speed ed up the process of converting that date into a PHP date object for my Calculation.Factory.PHP to process formulas, which generates the cost of an activity or specific job in the construction industry. And for some reason, technical, writing a PHP date back to SQL server required a different date conversion in SQL. What was most frustrating was reading a date in SQL, and writing it back to another table in the same format, and SQL server would not write it unless it was in a certain ISO format. The main point of this project was to get the existing code re imagined and upgraded from PHP 4.2 to PHP 7.4+ to extend the life of the application another 20 years. I know why the dates had to be converted but I don't know how to work around this without altering the database design at this point in time. Excellent question which is making think about the dates again. The original SQL did cast the date, but I can't remember at the moment why I had to remove the CAST, that was 8 months ago.
If it ain't broke don't fix it Discover my world at jkirkerx.com
-
Well, the major one would be that 2012 (v11) is still supported, while 2008 (10.5) isn't. I don't remember of breaking changes between those versions, though. A slightly better UI for SSMS, maybe. But nothing about date formats which would have changed. I just remember this was the time I started to install db systems on virtual machines rather than on physical ones. Regarding the date format you are talking about, the only way to be sure is to install a 2012 instance, copy the database, and test your queries and sp's against the new instance.
"Five fruits and vegetables a day? What a joke! Personally, after the third watermelon, I'm full."
Buffer rate is less because there is no data redundancy in SQL Server 2008. Spatial features are not supported more in SQL Server 2008 R2. Instead a traditional way for geographical elements have been set in SQL Server 2008 192.168.1.1 Admin Login - 192.168.l.l[^] Panorama Charter - Employee Login Portal for Spectrum Charter[^]