Tag: sql-server-2016

Found 677 results for 'sql-server-2016'.

1) t-sql - Subqueries for JSON path where outer query is part of a UNION result in strings rather than JSON
2) sql-server - Can I convert a VARCHAR field body to unquoted JSON result in SQL Server 2016 CTP 2.X?
3) sql-server - Can SQL Server 2016 validate JSON on insert?
4) sql-server - What's the most efficient way to load a csv file into SQL Server 2016?
5) sql-server - Import daily csv with varying available headers
6) sql-server - Tsql help - doing a large update from CSV file to a table in ssms
7) sql-server - Unclear update conflict
8) sql-server - Investigating errors from strange query
9) sql-server - Why high compile times for functions with XML on SQL Server 2016?
10) sql-server - Why can't I create a new schema with the owner set to dbo?
11) sql-server - Data Warehouse Kimball Customer and Customer Address Dimensions
12) sql-server - SQL Server FullText search on non-persisted columns
13) sql-server - Is there an operator or an easy way to match an expression one or more times with the LIKE operator in SQL?
14) sql-server - varchar(255) or varchar(256)?
15) sql-server - Is the 8KB row limit a "hard limit"?
16) sql-server - Is it possible to specify a different collation for the data vs the entities within a single database?
17) sql-server - join two tables, include one row from the parent table for each primary key
18) sql-server - SQL Server 2016 suddenly produces Error:402,State:1,Class:16 updating a sproc with DATETIME/DATE/TIME arithmetic, that was fine before
19) sql-server-2016 - What is the correct method to pass range of dates to a SQL Server 2016 temporal table query where you need a set returned for each day?
20) sql-server - Why can it take up to 30 seconds to create a simple CCI rowgroup?
21) sql-server - Row estimates always too low
22) sql-server - Cannot connect to <instance>. A severe error occurred on the current command
23) sql-server - Invalid Column Name on CONCAT_WS
24) t-sql - Simplifying Function with Recursive CTE and/or Window Function
25) sql-server - Is there any difference with specifying the primary key as an include column in a nonclustered index?
26) sql-server - Non-Unique Clustered Indexes Administration
27) sql-server-2012 - Update trigger fired before insert trigger upon insert of new row
28) t-sql - Can SQL Server 2016 extract node names from JSON?
29) sql-server - Invalid length parameter passed to the LEFT or SUBSTRING function when inserting data into a table that has computed columns
30) sql-server - Altering partition functions dynamically by utilizing triggers
31) sql-server - How can get this value with json sql server?
32) sql-server - sql server for json
33) sql-server - How To Tell if Trigger is failing
34) sql-server - specify delimiter in openrowset bulk insert
35) sql-server - Iterating through a record set and selecting certain records
36) sql-server - How to check if a column exists in a SQL Server table
37) sql-server - Columnstore Aggregate Pushdown doesn't work for float/real data types
38) sql-server - Add Constraint to check value exists in a non-unique composite key column
39) sql-server - Find Iteration of Day of Week in Month
40) sql-server - Calculate difference between current value and next value without CTE/ inline table
41) sql-server - Which kind of table design best suitable for normalization in SQL server?
42) sql-server - Why does CCI creation on an empty table request a huge memory grant?
43) sql-server - SQL Server Network Configuration node missing from Configuration Manager after install
44) sql-server - How to regenerate execution plans after clearing the plan cache?
45) sql-server - SQL Server - Prevent Clustered Index Scan on a specific table
46) sql-server - Why are the majority of cached plans missing from sys.dm_exec_query_stats?
47) sql-server - How can parse column names using ordinal position (not name) from XML data in SQL Server?
48) sql-server - SSMS 2016 CTP3.1 November Preview (v13.0.800.111) bug? properties error: missing column federated_service_account
49) sql-server - Select records with the same first column value and different second column value? SQL Server
50) t-sql - Will this trigger always complete before returning results of Insert to client?