SQL Server 2022 - Administration

• Topics

  Started by

  Posts

  Last post

• OLA's Maintenance scripts - should I be reorganizing?

  Hi These are my current params for nightly maintenance: USE MASTER EXECUTE dbo.IndexOptimize @Datab…

  krypto69

  4 replies

  1 year, 1 month ago

  By: ScottPletcher

• sqlserver services not stopping even after disconnecting from SSMS

  SQL server is installed in Win Server and accessed via SSMS from local. I noticed that even after I…

  Meera

  4 replies

  1 year, 1 month ago

  By: Mr. Brian Gale

• Use Polybase with ODBC to create external table

  I'm trying to use the installed Polybase service on an  SQL 2019 server to create an external table…

  blom0344

  12 replies

  1 year, 2 months ago

  By: Pablo Echeverria

• Error fetching data via Linked Server

  Hi, SS ver: SS 2017, SE; Oracle: 19.23 SE We have a nightly job that connects from our Sql server e…

  Ram

  1 replies

  1 year, 2 months ago

  By: Ram

• SQL 2022 performance

  Hello,   Can’t understand why simple script which utilize CPU single core on SQL 2022 Express …

  Janis

  13 replies

  1 year, 2 months ago

  By: Jeff Moden

• SQL Server 2022 Std edition eval version

  Hi We are planning to upgrade our SQL Server 2014 Ent edition to 2022 Standard and i want to test B…

  Barcelona10

  6 replies

  1 year, 2 months ago

  By: EdVassie

• Error: 18456 + SQL Server 2022 New Install

  We are seeing the below error after the SQL Server 2022 install. Not sure what is the purpose of th…

  tonytiger5812

  1 replies

  1 year, 2 months ago

  By: Ali Varzeshi

• SELECT PERMISSION DENIED ON Scalar function

  I have given examples of two ways of getting results from scalar function - one works the other doe…

  graham.measures

  4 replies

  1 year, 2 months ago

  By: Grant Fritchey

• Invalid Authorization Specification - running SSIS packages on SQL Server 2022

  Hi! Im trying to run an SSIS package on SQL Server 2022. It fails with the error: Invalid Authoriza…

  winston Smith

  1 replies

  1 year, 2 months ago

  By: winston Smith

• how to see the effect of Enable Scalar UDF Inlining in query plan

  hi, i read this artical https://learn.microsoft.com/en-us/sql/relational-databases/user-defined-fun…

  rajemessage 14195

  1 replies

  1 year, 2 months ago

  By: rajemessage 14195

• Hi any one please help in details about these below 

  Hi any one please help in details about these below 1.Database in recovery pending in SQL server ca…

  naga.rohitkumar

  5 replies

  1 year, 2 months ago

  By: Grant Fritchey

• Linked Server & Forced Encryption

  I recently updated our servers to force encryption. Force Encryption = Yes on the MSSQLSERVER Prope…

  r5d4

  2 replies

  1 year, 2 months ago

  By: Ken McKelvey

• Cannot Force Encryption - SQL Will Not Take Cert

  Hi there, I have a sql server on government AWS and we're trying to satisfy a requirement to force …

  amy26

  9 replies

  1 year, 2 months ago

  By: amy26

• should i make as many datafiles for temdb as many cpus i have

  hi, q1 As people said if u ghave GAM conention then u can go for adding as many datafiles of equal …

  rajemessage 14195

  9 replies

  1 year, 3 months ago

  By: rajemessage 14195

• Excel report issue after Datawarehouse migration

  Hello, I inherited data warehouse which was running on SQL server 2012 and dbs in 2008 compatibilit…

  Ashini Shah

  2 replies

  1 year, 3 months ago

  By: Emperor100