be careful with the money data type - Vietnamese Dong tend to overflow after a certain value. (i'm talking building a hospital costs, not buying a chocolate bar)

one word "bitlocker", we've had laptops stolen - lesson learned!!! - even our company approved USB sticks have encryption now

but i still don't quite get Encryption at rest for sql

if space is the issue then look at stretch to azure - it's not cheap but it is a monthly cost that offsets you buying a new SAN/Server - and...

but why only in functions ?

i'm starting to worry quite a bit of code now - given that we are upgrading in the next 3 weeks

whereabouts ?...

do you have enterprise edition ? I would advise against the union solution - if you have enterprise then use table partitioning based on the date.

how often is the data...

looks like it's the function

if you just run

       declare @myNumber INT;
       select  @myNumber =...

if i'm understanding correctly then I don't think there is a way. transactional replication relies on the t-log from the publisher sending stuff to the distributor and the subscribers collecting...

you know the little dots of paper that you have to empty from the hole punch... that's chad...

Jeff's blood pressure just went...

you might need to "GRANT CONNECT"

Hey - I might live in Mansfield, but we don't have...

• This reply was modified 5 years, 8 months ago by MVDBA (Mike Vessey).

I absolutely agree that cooperation leads to learning.  That's why I sit with the Developers and have a symbiosis with them.  Cooperation does not mean letting bad stuff happen...

you need to give us a bit more - but if you are casting everything...

at a rough guess you might make a loop (i'm assuming you have a numerical sequential value for your row)

something like

declare @rc int=0

while @rc>0

begin

declare @lastrow int=1

select top 75000 * for...