Converting a History Table into a System-Versioned Temporal Table

Temporal tables were introduced with SQL Server 2016. To take advantage of this feature, you might start fresh with a brand new table. It is possible, however, to convert an existing table with accumulated history to the new functionality. In this article, Mala Mahadevan explains how to create temporal tables for both scenarios.

Indexed Views In Non-Enterprise Editions of SQL Server

CAN you create AND USE an indexed view in non-Enterprise Editions of SQL Server?

Indexed Views

Server Instances

RE: How to Determine Whole Dollar Amount

I'm trying to SELECT all records where the Amount is a whole dollar.  I need to exclude all records where the Amount field contains cents.  Using Dinakar's suggestion:SELECT * FROM Sales WHERE CAST(Amount AS int) = Amountappears to give me what I need.  I just need to verify that this is the correct syntax to […]

stored proc timeout question

I am using a stored proc to query a database and return values. The stored proc has to utilize several temp tables, including a table cursor. (Too long a story to explain.)The problem I am encountering is that I get a "timeout expired" message.This does not occur all the time...only when the returned record sets […]

RE: Crosstab aggregate error, A Stumper!

This have to do with how CASE works. One thing is that a CASE can only return one datatype - which one if there are multiple datatypes within the same CASE expression, is determined by prescedence. (if not explicitly casted) CASE also only evaluates if the expression is true or false. Now.... the column checked […]

RE: looping thru databases - not

Are you using : sp_MSforeachdb 'use ? dbcc showcontig with tableresults, all_indexes' Remember it coms back as Multiple RS HTH

RE: Lookup Table

I also agree with Melanie. As does my friend Joe. In his usual charming style from another list: quote: This is a common mistake that Newbies and idiots often make. They literally do not know what a table is. A table is a set of things of the same kind (as per 1NF and DKNF […]

RE: How much do you earn?

quote: hanslindgren: It is good i agree. I can give you the link for the company i use, i don't know if they operate outside the UK but it might point you in the right direction. Basically these umbrella companies were setup because of new tax laws in the UK relating to one person becoming […]