Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Why is max dop recommended value related to the number of NUMA nodes?

D
derk last edited by

Sql server recommendation is to decide max dop based on number of processors in a single Numa node.

Given a system with 4 Numa nodes, each having 6 processors, the max dop recommended hence would be 6.

Why is max dop related the number of NUMA nodes?
Reply Quote 0
1 Reply Last reply
F
fbio last edited by

Why is max dop related the number of NUMA nodes?

Accessing memory on the NUMA node that the threads are running on is somewhat faster than accessing memory on other NUMA nodes. And parallel plans will run on a single NUMA node if it has enough cores (aka schedulers).

So it's a nice compromise to enable parallel queries while limiting their system-wide impact and promoting efficient query execution.

It's not at all mandatory, however, as you may have jobs that need MAXDOP 0. Also remember you can override the server MAXDOP at the database, workload group, or query level.
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

Please explain what does "for xml path(''), TYPE) .value('.', 'NVARCHAR(MAX)')" do in this code
SQL, Database Testing • sql server t sql unpivot • • Alberto

2

0
Votes

2
Posts

0
Views

C

A common technique for aggregate string concatenation before SQL Server 2017 is using XML data type methods along with STUFF to remove the extra delimiter. In SQL Server 2017 and later, STRING_AGG makes this task much cleaner and easier. The STRING_AGG equivalent: select @colsUnpivot = STRING_AGG(quotename (C.name),',') from sys.columns c where c.object_id = OBJECT_ID('dbo.result2') The components of the XML expression technique for aggregate string concatenation are as follows. This subquery will generate a result set with one row per column in the source table with a comma preceding each column name: select ',' + quotename (C.name) from sys.columns c where c.object_id = OBJECT_ID('dbo.result2') Example result: ,[column1] ,[column2] ,[column3] Adding the FOR XML PATH(''), TYPE converts these rows into a single strongly-typed XML text node with the concatenated rows, allowing XML methods like value to be used on the type: select ',' + quotename (C.name) from sys.columns c where c.object_id = OBJECT_ID('dbo.result2') for xml path(''), TYPE Result (XML type): ,[column1],[column2],[column3] Invoking the method value('.', 'NVARCHAR(MAX)') on that XML node converts the XML node to an nvarchar(MAX) string. The value XML data type method takes an XQuery expression with '.' representing the current node (only node here) and the second argument being the desired SQL data type to be returned. SELECT (select ',' + quotename (C.name) from sys.columns c where c.object_id = OBJECT_ID('dbo.result2') for xml path(''), TYPE).value('.', 'NVARCHAR(MAX)') Result (nvarchar(MAX)): ,[column1],[column2],[column3] Finally, the STUFF function removes the extraneous leading delimiter from the string. There is an error in your original example; the length should be 1 instead of 8 so that only the comma is removed: SELECT STUFF((select ',' + quotename (C.name) from sys.columns c where c.object_id = OBJECT_ID('dbo.result2') for xml path(''), TYPE).value('.', 'NVARCHAR(MAX)'),1,1,'') Final result (nvarchar(MAX)): [column1],[column2],[column3] I sometimes see folks omit the , TYPE).value('.', 'NVARCHAR(MAX)') when using this technique. The problem with that is that some characters must be escaped with XML entity references (e.g; quotes) so the resultant string will not be as expected in that case. EDIT: Incorporating Mister Magoo's recommendation to use (./text())[1] instead of just . as the node spec, the query below will improve performance with large data sets. SELECT STUFF((select ',' + quotename (C.name) from sys.columns c where c.object_id = OBJECT_ID('dbo.result2') for xml path(''), TYPE).value('(./text())[1]', 'NVARCHAR(MAX)'),1,1,'');
A

Using a NULL value to signify that the value does not mattter. Not that it isn't known
SQL, Database Testing • database design null • • amarantha

2

0
Votes

2
Posts

0
Views

G

My approach for this is to think of what the fields are, which is storing information on computers. There is no case ever where having a fan would result in NULL, just a yes or no. In your case of using it as a major category for computers, I would avoid that, and instead use your queries and stored procedures to consider the filters. In the stored procedure you can have the WHERE clause look for the different combinations; Only Computers with fans -- SELECT [recommendations] FROM table WHERE [has_fan]=1 Only computers without fans --SELECT [recommendations] FROM table WHERE [has_fan]=0 All computers\don't care -- don't use a WHERE clause;SELECT [recommendations] FROM table
N

MySQL Node not Connecting to Management Nodes in NDB Cluster
SQL, Database Testing • mysql mysql c languageluster ndbc languageluster • • Nykeriab

2

0
Votes

2
Posts

0
Views

I would remove the [mysql_cluster] section in the my.cnf file entirely, as it's redundant and can only lead to confusion (you already have two different settings for ndb-connectstring there). So I would go from this config block: ndb-connectstring=dbc1.enhancier.net,dbc2.enhancier.net [mysql_cluster] ndb-connectstring=dbc1.enhancier.net,dbc.enhancier.net To this: ndb-connectstring="10.80.45.5:1186,10.80.45.7:1186" That should eliminate a number of potential causes by specifying the same IP addresses that the management server lists, explicitly specifying the port, and wrapping the string in quotes. If things still don't work, then at least we've eliminated a few basic things. The next thing to double check is to ensure that the mysqld processes can communicate with the data nodes over the network, given the specified IP address and port combinations. But now that I look at the ndb_mgm SHOW output again, and what you even noted yourself, the data nodes are not running! When the mysqld (SQL API) node starts up, it contacts the management server (ndb_mgmd) in order to discover the data nodes (ndbd/ndbmtd processes). It then attempts to contact the data nodes in order to retrieve the data dictionary (pulls in .frm blobs for the tables) and other object and cluster metadata. That's what is timing out after 30 seconds: [Warning] NDB : Tables not available after 30 seconds. Consider increasing --ndb-wait-setup value Of course it's not able to pull in the table metadata because the data nodes are not responding as they're not running. The management nodes only serve as a discovery mechanism in this sequence, they don't hold any data. FWIW, the docs aren't very good on this topic, so I don't blame you for getting confused here. P.S. If you just want to get a running and working system, I would also recommend trying the Auto Installer.
D

Finding the last record within three years of the first record with subqueries
SQL, Database Testing • sql server sql server 2014 subquery • • Duquan

2

0
Votes

2
Posts

0
Views

My solution makes the following assumptions (please let me know if I have misunderstood your requirements) SequenceId is like an Identity value and represents the chronological order of student changes. You want to find the enrollment row for each student where the SequenceId is the MAX(SequenceId) for each student where the SchoolYear is within 3 years of the initial enrollment year for that student. SET NOCOUNT ON DROP TABLE IF EXISTS [dbo].[Enrollments]; CREATE TABLE [dbo].[Enrollments]( [SequenceID] [bigint] NULL, [SchoolYear] [int] NULL, [StudentID] [varchar](8) NULL, [ProgramID] [varchar](10) NULL, [DepartureCode] [varchar](2) NULL ) ON [PRIMARY] GO INSERT [dbo].[Enrollments] ([SequenceID], [SchoolYear], [StudentID], [ProgramID], [DepartureCode]) VALUES (29735, 2012, N'9800384', N'5331', N'10') GO INSERT [dbo].[Enrollments] ([SequenceID], [SchoolYear], [StudentID], [ProgramID], [DepartureCode]) VALUES (33183, 2013, N'9800384', N'5331', N'01') GO INSERT [dbo].[Enrollments] ([SequenceID], [SchoolYear], [StudentID], [ProgramID], [DepartureCode]) VALUES (33549, 2013, N'9800384', N'5331', N'01') GO INSERT [dbo].[Enrollments] ([SequenceID], [SchoolYear], [StudentID], [ProgramID], [DepartureCode]) VALUES (37105, 2014, N'9800384', N'5331', N'01') GO INSERT [dbo].[Enrollments] ([SequenceID], [SchoolYear], [StudentID], [ProgramID], [DepartureCode]) VALUES (37810, 2015, N'9800384', N'5331', N'22') GO INSERT [dbo].[Enrollments] ([SequenceID], [SchoolYear], [StudentID], [ProgramID], [DepartureCode]) VALUES (29544, 2012, N'9100926', N'5729', N'01') GO INSERT [dbo].[Enrollments] ([SequenceID], [SchoolYear], [StudentID], [ProgramID], [DepartureCode]) VALUES (37320, 2014, N'9100926', N'5729', N'01') GO ; WITH YearFirstEnrolled AS ( SELECT StudentID ,min(SchoolYear) AS YearFirstEnrolled FROM Enrollments GROUP BY StudentID ) SELECT * FROM YearFirstEnrolled fe JOIN Enrollments e ON e.StudentID = fe.StudentID AND e.SequenceID = ( SELECT max(SequenceID) FROM Enrollments WHERE StudentID = e.StudentID AND SchoolYear < fe.YearFirstEnrolled + 3 ) order by e.SequenceID | StudentID | YearFirstEnrolled | SequenceID | SchoolYear | StudentID | ProgramID | DepartureCode | |-----------|-------------------|------------|------------|-----------|-----------|---------------| | 9800384 | 2012 | 37105 | 2014 | 9800384 | 5331 | 01 | | 9100926 | 2012 | 37320 | 2014 | 9100926 | 5729 | 01 | Select your desired columns from the result.
K

Setting up Availability group for report server databases
SQL, Database Testing • sql server availability groups sql server 2017 ssrs powerbi report server • • kalena

2

0
Votes

2
Posts

0
Views

R

The reason the documentation states that automatic failover is not supported is that there are post-failover tasks that must be carried out to ensure the Report Server is completely online. See this section for information on exactly what tasks need to be completed. Essentially it boils down to needing to stop the SQL Agent on the old primary and restart the Report Server service. I am thinking to create the listener first with 2ips for those multi subnet so that we can use same while installing reporting services and point the listener name in instance and it's report server database to it so that it is aware of primary replica even after failover. Is my above understanding correct? Is that how it's suppose to work? Yes, build your AG and configure the listener first, then when you'r configuring the report server you can point it at the listener. Secondly, document says automatic failover is not supported even when I use sync mode between N1 and N2 ? Is that true? And why would that be the case only with SSRs? Also if it is , can we automate the faiover or does it have to be manual everytime since I am thinking data source application string can use the option multi subnet failover = true ? There seems to be some crossover here where you're talking about report data sources and Report Server databases. RS databases are the databases used by report server to manage and maintain the report server. They're typically named ReportServer and ReportServerTempDB. These databases do not support automatic failover because there are post-failover tasks you must complete to bring the service back to a 100% normal state. These tasks can be automated through scripts easily enough, but that is is what the documentation means by not supported. For your report data sources, these only need AG specific parameters in the connection string (such as MultiSubnetFailover or ApplicationIntent) if the source databases are in an AG as well. If they are then adding those keys to your connection strings will ensure the reports continue working post-failover. They should handle failover automatically. Something to note is this line from the documentation: The use of MultiSubnetFailover, with the report server databases, is not supported. What this means for you, given you have a multi-subnet cluster, is that you should set the RegisterAllProvidersIP setting to 0. This setting is 1 by default and means that each IP assigned to the listener is registered in DNS. If MultiSubnetFailover is enabled, the client will try to connect to each IP in parallel and return the connection from the first IP that responds. As this setting is not supported by the RS service for connections to the RS databases, after a failover you will likely encounter timeouts trying to connect. The solution is to set RegisterAllProvidersIP to 0 and set a low TTL for that host record. This ensures that only the active IP is registered with DNS for the listener, and after failover the new IP is registered with DNS. This means new connections to the listener use the correct IP and you avoid timeouts.
How to get first value from list of value
SQL, Database Testing • postgresql aggregate • • carriann

2

0
Votes

2
Posts

0
Views

C

You can use the DISTINCT ON of SELECT as in the documentation SELECT DISTINCT ON (id) id, col1, col2 FROM TABLE ORDER BY id, col1, col2 The difference between SELECT DISTINCT and SELECT DISTINCT ON () is that the first gives you unique rows across all selected columns .. the second gives you one unique row per column set defined within the parenthesis, but allows for additional columns to be returned. To specify WHICH additional data is returned, you need to ORDER BY.. DISTINCT will then return the first row for each DISTINCT ON set of columns.
C

sp_whoisactive @get_locks parameter xml error
SQL, Database Testing • sql server sp whoisac languagetive • • Cleofas

2

0
Votes

2
Posts

0
Views

B

I can't fully answer your question as to which object is causing the issue, but I can offer you some troubleshooting, and possible workarounds. Note that I can't distribute a "fixed" script to you because of its licensing, but you're free to try the edits locally. Troubleshooting If you ctrl+f through sp_WhoIsActive for @get_locks = 1, you'll hit this code section: A bit further down here, you'll see that a rather complicated select inserts into a table called #locks: If you scroll down to line 1670 or so (assuming you have line numbers enabled in SSMS), you'll reach the end of the SELECT INTO that populates it. You could try adding a simple SELECT * FROM #locks; here to see what ends up in the table. This could at least potentially point you to the correct object. Workarounds One workaround, without changing any code might be to run the procedure like this: EXEC sp_WhoIsActive @get_task_info = 2, @get_additional_info = 1; The intent of these parameters is documented here. If that doesn't run without error, you're stuck doing a ctrl+f for FETCH NEXT FROM locks_cursor. This will bring you to the section of code where your error pops up. Within this block of cursor code, you'll find a dynamic query, a catch block, and an update with nested REPLACE blocks to clean out bad characters (except yours, it appears). You'd have to add an additional nested REPLACE across all of them with NCHAR(0x0001) here I believe, in order to fix it. I haven't tested this, so YMMV. Hope this helps!
How do you know there's a line in the OBD system?
Software Programming • c sharp sql server entity framework • • Mystic

2

0
Votes

2
Posts

0
Views

C

Usually, this is decided by UNIQUE Constraint at the base level.But if you need to be straight at ORM level, use the method. https://msdn.microsoft.com/library/bb534972(v=vs.100).aspx ♪ It's usually the most effective for such checks. In particular, when using SQL Server, it is converted into https://msdn.microsoft.com/en-us/library/ms188336.aspx With a sample of data in your sub-acquisition, the CBD ceases the search operation immediately after the first match is found (as opposed to the COUNT, which tries to find all the matches by selecting the indices/records from the beginning to the end).
E

Associating large numbers of Items with large numbers of Users in Mongo
SQL, Database Testing • database design mongodb nosql • • emran

2

0
Votes

2
Posts

0
Views

A

Consider two collections (or entities) users and items. And, they are in a one-to-many relationship - users is the 'one' side and the items is the 'many' side. items: [ 1.. millions ] itemId: , name: , description: , other_fields: users: [ 1.. millions ] userId: , name: , email: , items: [ 1.. 10000 ] Embed the item id's in each User, but then i'd be often pulling out more than I need, and inserting/deleting ID's would also be inefficient. This is a often used approach - embedding the items ids within the users document. This is done by storing the items ids within the users document as an array. For example: items: [ itemId-1, itemId-2, ..., itemId-5000 ] With this approach: You can retrieve all items associated with a user. For more details of specific item, lookup the items collection (this can be an aggregation lookup operation which queries both collections as a "join"). All the related information for a user is within one document. For efficient querying, create indexes on the most used query filter fields for the users (e.g., userId, name) and the items array field. Indexes on array fields are called as Multikey Indexes. Another Approach: You can also consider storing more information (as sub or embedded documents) about the items in the items array. For example, items: [ { itemId: , itemName: }, { itemId: , itemName: }, ... ] In this use case, the itemName is often used when you query a user and related items. This way you can avoid accessing the items collection for the item's name. This approach works when the field like itemName does not change and mostly stable (fields like item price and quantity can change often, and description might not change often). ... but then i'd be often pulling out more than I need, and inserting/deleting ID's would also be inefficient. When you query for a user (users collection), you have the option to restrict the fields (user related and also items array) to get as result of a query. MongoDB's projection allows this restricting the fields to retrieve within a single document. This also applies to the items array field - only specific item(s), specific number of items, specific fields for an item, etc. Regarding the inserting / deleting / updating operations - MongoDB has methods to update a single or multiple fields (including array fields) for a document as atomic operation. There are specific operators (referred as array operators) to work with arrays (with scalar or composite values) - for inserting, updating, deleting and querying (CRUD operations) on the array fields. Creating indexes on array fields will make these operations efficient.
M

How to check if a view exists before you have it created?
Software Programming • sql server sql tsql • • meriah

2

0
Votes

2
Posts

0
Views

If you do not want to change or delete the View that already exists, just check if it exists, if there is any action or do nothing. IF NOT EXISTS ( SELECT * FROM sys.views v INNER JOIN sys.schemas s on v.schema_id = s.schema_id WHERE s.name = 'dbo' and v.name = 'vw_types' ) EXEC sp_executesql @statement = N'CREATE VIEW vw_types AS SELECT codigo AS code, nome AS description, abreviacao AS abbreviation, statusRegistro AS status FROM tipos;' ; ELSE print 'ja exixte uma view com esse nome' GO In this case I am just bringing a message informing that it already exists in ELSE print 'ja exixte uma view com esse nome', but this is optional. You can delete, or send another action.
Y

How to reference Assembly in Visual Studio?
Software Programming • c sharp sql server visual studio • • yajahira

2

0
Votes

2
Posts

0
Views

N

It is necessary to add the file System.Data.dl to your project.Click on dependencies, add and choose the assembly.
K

An INSERT statement triggers the SQL Server Audit to write it down in the logs although INSERT is not listed as an Audit Action
SQL, Database Testing • sql server audit sql server 2019 logs • • Kadir

2

0
Votes

2
Posts

0
Views

K

The optimal approach would be to disable the INSERT audit for that table, but since you seem to have a peculiar situation, here's one way of dealing with it: Once you made sure the INSERT audit is not enabled by connecting to the audited database and running this query: -- List enabled database specifications SELECT a.audit_id, a.name as audit_name, s.name as database_specification_name, d.audit_action_name, s.is_state_enabled, d.is_group, s.create_date, s.modify_date, d.audited_result FROM sys.server_audits AS a JOIN sys.database_audit_specifications AS s ON a.audit_guid = s.audit_guid JOIN sys.database_audit_specification_details AS d ON s.database_specification_id = d.database_specification_id WHERE s.is_state_enabled = 1 You can filter that audit to avoid the inserts from being registered. The Create a Server Audit and Server Audit Specification doc says: Optionally, on the Filter page, enter a predicate, or WHERE clause, to the server audit to specify additional options not available from the General page. Enclose the predicate in parentheses; for example: (object_name = 'EmployeesTable'). The Filter page can be found by right click the audit > properties. If you prefer, the T-SQL to alter the audit not to register the inserts would be something like this: USE [master] GO ALTER SERVER AUDIT [Your_Audit_Name] WHERE (NOT [statement] LIKE 'INSERT%') GO Some relevant content: Filter SQL Server Audit on action_id / class_type predicate sys.fn_get_audit_file (Transact-SQL) How to analyze and read SQL Server Audit information
P

Why has my database connection failed?
SQL, Database Testing • sql server sql server 2012 connect • • Pearlaqua

2

0
Votes

2
Posts

0
Views

T

This is an extremely common error, with literally millions of search results online. The typical troubleshooting steps include: Make sure the SQL Server service is actually running (SQL Server Configuration Manager > SQL Server Services > check the State of the specific instance and make sure it says "Running", otherwise right-click > Start). Make sure the SQL Server Browser service is running, you can check this in Configuration Manager as above, or using sc query sqlbrowser from the command line (if it is not running, right-click > Start or run net start sqlbrowser from the command line). If you are trying to connect to a different machine (or using a name that forces you to route outside of your machine for some reason), make sure the server is configured to allow remote connections. You can fix this by using remote desktop to connect to that server and running this locally: EXEC sys.sp_configure N'remote access', 1; GO RECONFIGURE WITH OVERRIDE; Of course this might be hard to do if it's the local instance you can't connect to, so you'll have to get connected locally using other steps in this list first before you'll be able to talk to the server to change this setting. Make sure the port SQL Server is running on is open, and that TCP/IP is enabled (SQL Server Express Edition, for example, expects Named Pipes for remote connections by default). You can see this in Configuration Manager > SQL Server Network Configuration > Protocols for > TCP/IP, right-click, properties, IP Addresses tab, scroll all the way down to see (a) that TCP/IP is enabled (and if not, right-click > Enable, may as well try enabling Named Pipes too), and check what port is listed under IPAll > TCP Dynamic Ports or TCP Port. Note that if it's using dynamic ports, that port could change, and if SQL Browser is not configured to start automatically, you'll be right back here potentially on your next reboot. Make sure the server name is correct, and be sure to try IP address, simple server name, and fully-qualified domain name. If the server is local, try localhost and 127.0.0.1 in addition to the server name. Make sure you can traceroute/tracert to the server and telnet to the running port. If you can connect to one of these hosts but not others, either change your connection string, change your hosts file and/or DNS, or consult your network administrator. Make sure the instance name is correct. Often people type their machine name and don't realize that they are trying to connect to a named instance, which requires syntax like server_name_or_ip\SQLEXPRESS - a common one as SQLEXPRESS is typically the instance name in use when running SQL Server Express Edition. If you can't connect using any of those methods, it is likely a firewall issue. You'll need to determine which ports to open and for whom (of course your SQL Server should be secured from external traffic whenever possible), but you can quickly test if this is the problem by momentarily disabling the firewall altogether. A lot of this is documented much more elaborately here (found in Paul White's wiki post here How to Troubleshoot Connecting to the SQL Server Database Engine
N

Update Query DeadLock in SQL Server when ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT are enabled
SQL, Database Testing • sql server sql server 2008 update deadloc languagek concurr • • nishika

2

0
Votes

2
Posts

0
Views

J

Writers block other writers of the same row regardless of isolation level. To avoid blocking during data modifications, examine execution plans to ensure only needed rows are touched by the query and perform query and index tuning as needed. The READ_COMMITTED_SNAPSHOT database option avoids readers from blocking writers in the default READ COMMITTED isolation level by using row versioning instead of locking for statement level read consistency but at the cost of additional overhead for the row version store and in-row version data. You do not need to set ALLOW_SNAPSHOT_ISOLATION to use READ_COMMITTED_SNAPSHOT. ALLOW_SNAPSHOT_ISOLATION allows use of the separate SNAPSHOT isolation level, which provides transaction level (not just statement level) consistency using row versioning.
Y

Migrating from text and image to varchar(max) and varbinary(max)
SQL, Database Testing • sql server database design blob • • yajahira

2

0
Votes

2
Posts

0
Views

E

Just a note: these new data types support the same sizes as the deprecated types they replace, e.g. 2GB of data (which means a different number of characters depending on Unicode and other factors). One thing for sure is you should parse all of your existing application code, stored procedures, functions etc. for instances of built-ins like UPDATETEXT, READTEXT, TEXTPTR, WRITETEXT, TEXTSIZE and @@TEXTSIZE - all of which will likely have to be changed. You can identify those stored in SQL Server this way: SELECT s.name, o.name FROM sys.sql_modules AS m INNER JOIN sys.objects AS o ON m.[object_id] = o.[object_id] INNER JOIN sys.schemas AS s ON o.[schema_id] = s.[schema_id] WHERE UPPER(m.definition) LIKE N'%UPDATETEXT%' OR UPPER(m.definition) LIKE N'%WRITETEXT%' OR UPPER(m.definition) LIKE N'%READTEXT%' OR UPPER(m.definition) LIKE N'%TEXTPTR%' OR UPPER(m.definition) LIKE N'%TEXTSIZE%'; Note that this could yield false positives (e.g. those terms may be in a comment or naturally occur in an entity name) and it could miss some (e.g. the commands could be constructed using parameters / dynamic SQL). You're on your own for searching your application codebase and/or source control for instances of the same. Also make sure you find all modules that accept or output parameters of these types: SELECT DISTINCT s.name, o.name FROM sys.parameters AS p INNER JOIN sys.objects AS o ON p.[object_id] = o.[object_id] INNER JOIN sys.schemas AS s ON o.[schema_id] = s.[schema_id] WHERE system_type_id IN (34,35,99); You might also want to consider that you may have logic in jobs and other maintenance routines that currently avoid these tables or treat them differently because of the limitations inherent in these data types. When you move to the newer types (and especially on the most modern versions of SQL Server), a lot of these limitations go away. Finally, other than the syntax above, I can't think of a single feature the old types support that the new types don't.

Why is max dop recommended value related to the number of NUMA nodes?

Suggested Topics

Please explain what does "for xml path(''), TYPE) .value('.', 'NVARCHAR(MAX)')" do in this code SQL, Database Testing • sql server t sql unpivot • • Alberto

Using a NULL value to signify that the value does not mattter. Not that it isn't known SQL, Database Testing • database design null • • amarantha

MySQL Node not Connecting to Management Nodes in NDB Cluster SQL, Database Testing • mysql mysql c languageluster ndbc languageluster • • Nykeriab

Finding the last record within three years of the first record with subqueries SQL, Database Testing • sql server sql server 2014 subquery • • Duquan

Setting up Availability group for report server databases SQL, Database Testing • sql server availability groups sql server 2017 ssrs powerbi report server • • kalena

How to get first value from list of value SQL, Database Testing • postgresql aggregate • • carriann

sp_whoisactive @get_locks parameter xml error SQL, Database Testing • sql server sp whoisac languagetive • • Cleofas

How do you know there's a line in the OBD system? Software Programming • c sharp sql server entity framework • • Mystic

Associating large numbers of Items with large numbers of Users in Mongo SQL, Database Testing • database design mongodb nosql • • emran

How to check if a view exists before you have it created? Software Programming • sql server sql tsql • • meriah

How to reference Assembly in Visual Studio? Software Programming • c sharp sql server visual studio • • yajahira

An INSERT statement triggers the SQL Server Audit to write it down in the logs although INSERT is not listed as an Audit Action SQL, Database Testing • sql server audit sql server 2019 logs • • Kadir

Why has my database connection failed? SQL, Database Testing • sql server sql server 2012 connect • • Pearlaqua

Update Query DeadLock in SQL Server when ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT are enabled SQL, Database Testing • sql server sql server 2008 update deadloc languagek concurr • • nishika

Migrating from text and image to varchar(max) and varbinary(max) SQL, Database Testing • sql server database design blob • • yajahira

Please explain what does "for xml path(''), TYPE) .value('.', 'NVARCHAR(MAX)')" do in this code
SQL, Database Testing • sql server t sql unpivot • • Alberto

Using a NULL value to signify that the value does not mattter. Not that it isn't known
SQL, Database Testing • database design null • • amarantha

MySQL Node not Connecting to Management Nodes in NDB Cluster
SQL, Database Testing • mysql mysql c languageluster ndbc languageluster • • Nykeriab

Finding the last record within three years of the first record with subqueries
SQL, Database Testing • sql server sql server 2014 subquery • • Duquan

Setting up Availability group for report server databases
SQL, Database Testing • sql server availability groups sql server 2017 ssrs powerbi report server • • kalena

How to get first value from list of value
SQL, Database Testing • postgresql aggregate • • carriann

sp_whoisactive @get_locks parameter xml error
SQL, Database Testing • sql server sp whoisac languagetive • • Cleofas

How do you know there's a line in the OBD system?
Software Programming • c sharp sql server entity framework • • Mystic

Associating large numbers of Items with large numbers of Users in Mongo
SQL, Database Testing • database design mongodb nosql • • emran

How to check if a view exists before you have it created?
Software Programming • sql server sql tsql • • meriah

How to reference Assembly in Visual Studio?
Software Programming • c sharp sql server visual studio • • yajahira

An INSERT statement triggers the SQL Server Audit to write it down in the logs although INSERT is not listed as an Audit Action
SQL, Database Testing • sql server audit sql server 2019 logs • • Kadir

Why has my database connection failed?
SQL, Database Testing • sql server sql server 2012 connect • • Pearlaqua

Update Query DeadLock in SQL Server when ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT are enabled
SQL, Database Testing • sql server sql server 2008 update deadloc languagek concurr • • nishika

Migrating from text and image to varchar(max) and varbinary(max)
SQL, Database Testing • sql server database design blob • • yajahira