(Manoj Pandey) In my [previous post] about Temporal Data I showed how to setup Temporal on an existing table. That was a simple scenario where the tables does not have historical data, and we added the 2 Period columns on that table, and we didn’t face any issues.
Tag: sql server
SQL Server 2016 – Introduction to Stretch Database
(Tim Radney) Beginning with SQL Server 2016 you will have the ability to store portions of a database in the cloud. This new ability is known as Stretch Database and the feature will be beneficial to those needing to keep transactional data for long periods of time and those looking to save money on
Quickly Pinpoint SQL Server Performance Issues with SolarWinds Database Performance Analyzer
(Jeremy Kadlec) My team needs to quickly pinpoint the performance issues in my SQL Server environment. With all of the demands at work, our team needs to find and understand the issues, then review the code and take corrective actions. We need to ensure our production SQL Server environment is runni
SQL 2016: Columnstore row group Merge policy and index maintenance improvements
(Denzil Ribeiro) A Columnstore index contains row groups that can that have a maximum of 1,048,576 rows. A row group can be closed and compressed due to multiple reasons before that maximum of 1,048,576 rows is reached.
SQL SERVER – How to do IF…THEN in SQL SERVER?
(Pinal Dave) Just another day I received following question –
Unable to run SQL query on GP data with dates – Conversion of a varchar to a datetime error
(Steve Endow) An interesting Dynamics GP query question came up on Experts Exchange. The user was asking how to select transactions for a given date range from the PM30300 table. Pretty straightforward–I recommended this query as a start:
Getting maximum consecutive years in #SQLServer T-SQL using Common Table Expressions #CTE
(Donabel Santos) This is an expansion (and slight variation) of Joe’s answer in StackOverflow regarding the thread Find the maximum consecutive years for each ID’s in a table (Oracle SQL) using SQL Server. I’ve tested this in SQL Server 2014, but should work from SQL Server 2005 onwards where the ra
SQL SERVER – How to do IF…THEN in SQL SERVER?
(Pinal Dave) Just another day I received following question –
Unable to run SQL query on GP data with dates – Conversion of a varchar to a datetime error
(Steve Endow) An interesting Dynamics GP query question came up on Experts Exchange. The user was asking how to select transactions for a given date range from the PM30300 table. Pretty straightforward–I recommended this query as a start:
Getting maximum consecutive years in #SQLServer T-SQL using Common Table Expressions #CTE
(Donabel Santos) This is an expansion (and slight variation) of Joe’s answer in StackOverflow regarding the thread Find the maximum consecutive years for each ID’s in a table (Oracle SQL) using SQL Server. I’ve tested this in SQL Server 2014, but should work from SQL Server 2005 onwards where the ra