Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [sql-server-2016]

SQL Server 2016 (major build version 13.00.xxxx). Please also tag sql-server.

Major releases:

  1. 13.0.1601.5 - RTM, June 2016
  2. 13.0.4001.0 - Service Pack 1 (SP1), released November 2016

SQL Server 2016 will leave mainstream support on 2021-07-13 and extended support on 2026-07-14.

2772 questions
3
votes
1 answer

Cannot create a row of size 11842 which is greater than the allowable maximum row size of 8060

The suspect table has 299 nvarchar(max) columns, 1 integer column and 1 nvarchar(255) column. Please do not ask me why, this is 3rd party vendor database. Anyway, according to my math, in the worst case scenario we should be well within 8060…
Eternum
  • 115
  • 2
  • 6
3
votes
1 answer

Why no rows in sys.dm_os_cluster_* on Availability Group?

Running into some issues with failovers on an Availability Group with two nodes and a file share witness. I read a post and then I tried to get the HealthCheckTimeout value from sys.dm_os_cluster_properties and no rows are returned. My google…
SteveB
  • 235
  • 2
  • 10
3
votes
2 answers

Database User Securables Question

Learning sql server over here and I'm trying to figure out how to see the securable permissions I have added via T-SQL , in SSMS For example, I have a database user called "LoginUser1" in Database1 and I granted "grant create table, create view to…
cspell
  • 501
  • 7
  • 17
2
votes
1 answer

How to track or understand if a "timeout" was caused by SQL Server issues or network, server and etc?

This is a question that haunts me for ages. every job I got I see plenty of people complaining for the database administrators about "timeout" errors: System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior…
Racer SQL
  • 7,386
  • 14
  • 69
  • 128
2
votes
1 answer

DD/mm/yyyy in varchar(max) needs to be converted to yyyymmdd format

DD/mm/yyyy in varchar(max) needs to be converted to yyyymmdd format Thought to get the experts opinion. Below options to convert / cast didn't work: CONVERT(VARCHAR(19),CONVERT(DATETIME, wfm.date,3),112) convert(varchar(50), cast(wfm.date as…
Balaji Chandrasekar
  • 21
  • 1
2
votes
1 answer

Consistent drop in performance on SQL Server 2016 SP2

Recently upgraded from 2008R2 to 2016SP2. Have a slow process that I can't change. Application contacts the server back and forth constantly and runs tiny queries, including doing an update 30K+ times serially. I've tried any suggested indexes,…
Dbot
  • 63
  • 9
2
votes
1 answer

SQL Server 2016 CTP -> RTM, safe to attach CTP DB files (including SSISDB)?

I'm uninstalling an expired CTP build and installing RTM, because the CTP -> RTM upgrade path is not supported. Is there any word on: Whether it's supported to attach user database files from CTP to RTM. Whether it's supported to attach SSISDB from…
Cody Konior
  • 3,508
  • 12
  • 22
1
vote
1 answer

SQL Server Query to find nearest values

I have a table of X and Y values relating to points on a mapping grid where each pair of values reference the bottom left corner of each square which are spaced in 500 square metre increments for each value to form the points in a grid…
DynamoRanger
  • 13
  • 3
1
vote
1 answer

How to Select Distinct Group By With Exclusions

I have a large table similar to: The goal: For each UserID with a Y in the Access column, show UserID only as "Y" (exclude "N", "?") For each UserID without any Y's in the Access column, show UserID only as "N" (exclude "?") For each UserID with…
eleven11
  • 43
  • 5
1
vote
1 answer

We are using MSSQL 2016 / SSMS 18.9.2 and trying to script out a system versioned table with 2 hidden columns (is_hidden=1 is the sys.columns table)

When the table was created, we used this for the 2 columns in question: [EffectiveDateUTC] [DATETIME2](7) GENERATED ALWAYS AS ROW START HIDDEN NOT NULL, [ExpirationDateUTC] [DATETIME2](7) GENERATED ALWAYS AS ROW END HIDDEN NOT NULL, However, when…
coolbeanfred
  • 11
  • 1
1
vote
2 answers

Number of connections differ between performance monitor and SQL Server Profiler

WHAT I'M TRYING TO FIND OUT How many logins/s and logouts/s I'm having on my SQL Server 2016 Standard. WHAT I DID SQL SERVER PROFILER In SQL Server Profiler, I made a trace selecting only 'Audit Login' and 'Audit Logout'. The trace runned for about…
chesterman
  • 69
  • 1
  • 8
1
vote
1 answer

How to know what database user I'm using in SQL Server?

I'm learning SQL with SQL Server and I've see how to create users, I've created without login: CREATE USER Luis_Gerente WITHOUT LOGIN WITH DEFAULT_SCHEMA=dbo CREATE USER Mario_Supervisor WITHOUT LOGIN WITH DEFAULT_SCHEMA=dbo CREATE USER Ana_Vendedor…
Salvador Morales
  • 13
  • 3
1
vote
1 answer

SQL Server 2016 - “Always on” issue on secondary server , redo thread blocked

I need help for an always-on issue after upgrading to 2016 from 2014. Redo thread is causing blocking for all the select query on the secondary replica. all long running select queries are getting blocked by redo thread for a specific database. All…
user181726
  • 13
  • 3
1
vote
0 answers

Table row count throws an exception

I have a table named backupfile, this is a copy of sys.backupfile that I am inserting into from all of the servers on in my network. I was trying to see how big the table has gotten, and when I go to Properties - Storage it takes a while, and then I…
DForck42
  • 3,048
  • 3
  • 34
  • 65
1
vote
1 answer

SQL Cluster failover doesn't work after applying SQL Server 2016 Service Pack 2

I tried to apply SQL Server 2016 Service Pack 2 on the clustered instance of SQL Server (SQL Server 2016 SP1 CU7, 2 nodes, active-passive architecture). We did this patching previously on the other cluster with similar configuration and it went…
GrzegorzO
  • 338
  • 2
  • 12
1
2 3 4