SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
286 questions with SQL Server | SQL Server Transact-SQL tags
3 answers
Running total for grouped data
Given input data similar to: Month Region Store Sales Jan R1 S1 10.00 Jan R1 S1 15.00 Jan R1 S1 30.00 Jan R1 S2 5.00 Jan R1 S2 1.00 Jan R2 S3 17.00 Jan R2 S3 …
SQL Server | SQL Server Transact-SQL
asked 2026-06-11T18:57:56.56+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 59%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Peter Bishop
256
Reputation points
commented 2026-06-12T16:08:15.3066667+00:00
Erland Sommarskog
134.6K
Reputation points MVP
Volunteer Moderator
2 answers
Does UPDATE WITH (ROWLOCK) guarantee row-level locking, or can SQL Server still acquire page/table locks and perform lock escalation?
Hi Team, I would like clarification on SQL Server locking behavior for an UPDATE statement when the ROWLOCK table hint is explicitly specified. Example: From Microsoft documentation, I understand that: ROWLOCK is a table hint that requests row-level…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2026-06-11T15:39:08.5766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 79%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVA%3C/text%3E%3C/svg%3E)
Vinith Ankam
0
Reputation points
commented 2026-06-11T22:42:29.04+00:00
Erland Sommarskog
134.6K
Reputation points MVP
Volunteer Moderator
2 answers
How to install SQL Server Management Studio for Personal Use
Hello, I would like to download the latest SQL Server Management Studio locally on my machine for personal use and training. I have been unemployed since Nov-2025 and I would like to maintain and increase my SQL skills. I would also like some basic…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2026-06-10T20:59:13.63+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 41%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELV%3C/text%3E%3C/svg%3E)
Luigi Vitale
0
Reputation points
edited an answer 2026-06-10T21:25:50.6466667+00:00
Erland Sommarskog
134.6K
Reputation points MVP
Volunteer Moderator
2 answers
What is SQL error ID 8179 and how to fix it?
The customer often found NAV Server error at Event Viewer (Application log), Event ID 216, MicrosoftDynamicsNavServer$MBKNAV. It was NavSqlException, SQL error ID 8179 (“Could not find prepared statement with handle …”). This issue often occurs when…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2026-02-18T02:58:30.2366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 86%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECT%3C/text%3E%3C/svg%3E)
Chirayu Traihirun
0
Reputation points
commented 2026-06-10T04:51:14.0866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Akhil Gajavelly
1,830
Reputation points Microsoft External Staff
Moderator
1 answer
BULK INSERT cannot access UNC path, error code 5 (Access is denied) using gMSA unless locally triggered
Running a stored procedure to bulk insert from a UNC path works locally via SSMS and via SQL agent job but if run remotely I receive Operating system error code 5 (access is denied). Please help as this workaround is not suitable for our…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2026-04-28T02:03:11.9766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 53%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Michelle
0
Reputation points
commented 2026-06-08T05:49:06.44+00:00
Akhil Gajavelly
1,830
Reputation points Microsoft External Staff
Moderator
2 answers
Alternative to UNION
I have a UNION Query that is combining information from a History Table and the current Master Table. We are talking about a few million rows here. The problem is the amount of [tempdb] space it is allocating and using for the UNION. So we thought if we…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2026-04-22T20:14:11.0866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 79%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
Bobby P
271
Reputation points
recommended 2026-06-04T19:09:07.2433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 39%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Table constraint design to avoid a cycle
In the minimal reproducible example below, table C is invalid as it results in a cycle. I understand I can simplify C by removing the constraints, however the number of triggers required after goes up significantly if I want to preserve the cascading…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2026-04-30T17:15:13.18+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 93%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
ritmo2k
911
Reputation points
commented 2026-05-26T05:10:55.8933333+00:00
Akhil Gajavelly
1,830
Reputation points Microsoft External Staff
Moderator
2 answers
Stored Procedure running longer hours
Hello, I am facing currently issue as stored procedure running very longer hours although my DB is not that big means around 20 GB. We are also running OLA's maintenance solution for Update Stats Daily and Index maintenance weekly basis. Stored procedure…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2026-03-21T16:55:37.63+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
pdsqsql
436
Reputation points
commented 2026-05-18T05:14:52.69+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 10%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Anjan Kumar Chippa (Quadrant Resource LLC)
0
Reputation points Microsoft External Staff
Moderator
3 answers
Latest security update has caused SS debugger to fail... 2008 r2 windows 10 - Windows Firewall
Getting: The WIndows Firewall on this machine is currently blocking remote debugging. RD requires... TCP Port 135... UDP 4500/ 500 be unblocked. Can't Cancel, Unlock for local or Unlock for Computer. Trying to "Debug>Start Debugging".
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2025-07-12T01:50:50.6933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 87%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
M Douglas Martin
0
Reputation points
recommended 2026-04-28T16:15:35.55+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
How do I fix SQL Select Query?
image0.jpeg SSMS 22 generated select top 1000 rows produces an error as shown in the attached image. How do I fix this?
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2026-04-22T17:04:30.7466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 56.00000000000001%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SuperCoder
376
Reputation points
accepted 2026-04-22T19:19:23.0466667+00:00
SuperCoder
376
Reputation points
4 answers
Copying a 32-Million Row Table From Production Server to Test Server
So we believe we're having tempdb issues with a very wide table that has 32-Million Rows on it. There is no Primary Clustered Index, No Indexes defined on it at all. We have tried an INSERT SELECT going across a Linked Server to our Test Server to copy…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2026-03-13T19:43:14.18+00:00
Bobby P
271
Reputation points
recommended 2026-04-21T11:12:13.7333333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Implementing User-Defined Sort via Trigger
Hi, Running SQL Server 2008 R2. We have a requirement to implement an arbitrary sort for a table using a numeric sort column. DDL and DML below: CREATE TABLE [dbo].[Test] ( [TestID] [bigint] IDENTITY(1,1) NOT NULL, …
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2025-10-20T12:47:59.12+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 2%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV7%3C/text%3E%3C/svg%3E)
VDT-7677
171
Reputation points
recommended 2026-04-21T03:25:09.1166667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
what data type i should use for roversion col and can i use less than greater than with it.
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to run the following query to find all inseted after this @LastKnownRowVersion; SELECT * FROM YourTable WHERE RowVersionCol > @LastKnownRowVersion; data type i should use for…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2026-04-02T07:54:36.2033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 75%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERY%3C/text%3E%3C/svg%3E)
rajesh yadav
291
Reputation points
recommended 2026-04-20T12:37:35.11+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
SQL error -An expression of non-boolean type specified in a context where a condition is expected
Thanks in advance for any help folks can offer. I've been pulling my hair our all day yesterday trying to figure out how to fix this. I received the error below after I added 3 new lines (line 60, 61 and 62). The original code without these 3 new lines…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2026-01-26T18:29:09.99+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 26%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DW
0
Reputation points
commented 2026-04-15T05:00:24.9933333+00:00
Akhil Gajavelly
1,830
Reputation points Microsoft External Staff
Moderator
3 answers
One of the answers was accepted by the question author.
DBCC TRACEOFF 3604
Good afternoon SQL 2022 Standard I would like to better understand: DBCC TRACEOFF 3604 DBCC TRACEON 3604 How to use it? How to activate it? How and when should it normally be used? Thank you Urantia
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2025-11-18T14:52:31.8666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 64%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
MadUrantia
200
Reputation points
accepted 2026-04-13T14:04:50.2166667+00:00
MadUrantia
200
Reputation points
2 answers
Sequel server licensing
My distributer is telling me that SQL Server Standard 2022 - 2 Core License Pack - 3 yearSQL Server Standard 2022 - 2 Core License Pack - 3 year billed annually is a perpetual license? I have query with this as it has a termed subscription time?…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2026-03-02T03:07:55.3166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 15%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEC%3C/text%3E%3C/svg%3E)
Esther Cleave
0
Reputation points
recommended 2026-04-13T13:00:18.85+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Identity Column jumps massively from 168712 to 9999993
I have table with identity column id. There was massive jump from id 168712 to 9999993. It has happened twice in different servers. Its not identity cache/transaction rollback/manual insert/ reseed. Why its happening. Please guide me on this.
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2025-10-17T16:06:46.38+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 62%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPG%3C/text%3E%3C/svg%3E)
Perumal, Gowthami
5
Reputation points
recommended 2026-04-05T11:14:03.4466667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
how to fix error 1205 on mssql 2022
Riscontro vari errori 1205 nei log e dopo alcuni di questi, si verifica l'errore 824
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2026-02-23T19:02:26.01+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 83%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
Luca Benedetto
20
Reputation points
recommended 2026-03-20T12:23:16.2066667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
SQL query across linked servers
Hi All, I have a number of linked servers. In each server I have the same table Q_TESTS. I would like to run t-sql script across all the servers, select * from Q_TESTS where Act = 1 How can I achieve this? Kindly advise Many thanks
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2026-03-17T09:13:39.18+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 39%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Rontech10111
221
Reputation points
accepted 2026-03-18T06:40:08.0366667+00:00
Rontech10111
221
Reputation points
1 answer
One of the answers was accepted by the question author.
Best, Most Efficient DATETIME filtering
I have seen many discussions regarding doing filtering against a DATETIME Data Type. Some suggest to use a true DATTETIME format. WHERE <DATETIME_Column_Name> >= '2026-02-17 00:00:00.000' Others suggest to use just a quoted Date... WHERE…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions