• they tie together, right

• /* https://docs.microsoft.com/en-us/sql/relational-databases/partitions/create-partitioned-tables-and-indexes */
  -- Creates a partition function called myRangePF1 that will partition a table into four partitions  
  CREATE PARTITION FUNCTION myRangePF1...

Even opletten :

prv.value is a boundary value, left or right according to your partitioning definition.

It is the tipping point to put data in the next partition. ( in case of...

-- http://www.davidemauri.it/DasBlog/CategoryView,category,Sql%20Server%202005.aspx
--create schema ALZDBA


/* Welke query(s) uitvoeren ? */
Declare @WelkeQuery int


/* 0 = alles , (1,2,3,4,5) is enkel die query */
set @WelkeQuery = 4

if @WelkeQuery in (...

You could use a scheduled task to run this Powershell script

( save it as e.g. C:\Powershell\SQLServer_Backup_Full.ps1 )

<#
Create sqlserver backup for all databases of the local default instance

Johan...

Check todays featured atricle "Monitor SQL Server Error Logs with PowerShell" to get you started

do not drink e.g. orange juice as it is very sour and sweet which is bad for your voice.

Database Mirroring in SQL Server 2008

SQL Server 2008 R2 Database Mirroring with Automatic Failover Across the Internet

It may be a bit late to start it all in 2021...

All nice and well,

How about:

declare @Data table (begin_time varchar(8), 
                 ...

• This reply was modified 4 years, 6 months ago by Johan Bijnens.

You are moving multiple files to the same...

Double check configuration setting 'optimize for ad hoc workloads'

exec sp_configure 'optimize for ad hoc workloads', 1;
reconfigure

There is a vivid SQLServer community in Germany!

Maybe that's the way to go on your quest: SQLPass.de

What version of SQLServer are you on ?

SELECT SERVERPROPERTY('ProductUpdateLevel') AS ProductUpdateLevel  -- SQL 2014 SP1 CU5
     , SERVERPROPERTY('ProductUpdateReference') AS ProductUpdateReference
  ...

If I were you, I would indeed test it in SQL2019 and see how it performs.

Start with "Data migration Assistant" !

Then migrate - and follow up as Grant pointed...

I should indeed have been a bit more thoughtful and provided the nice context as you did, Grant.

A couple of sentences providing the full set of activities that are actually...

FYI

SQL Server 2019 Editions Datasheet.pdf