How to solve Rollback Committed transaction in SQL Server?
Is it possible to roll back a committed transaction?I have deleted all the data in a table. The delete statement is inside Begin Transaction and I…
1 Answer · 7 Views · Answered ✓
Get a modern-day SQL Developer Training that will help you learn the basics of database querying, Microsoft SQL and the best-practices of Database Management to gain confidence with our Online SQL Certification and surmount a trending career field
Is it possible to roll back a committed transaction?I have deleted all the data in a table. The delete statement is inside Begin Transaction and I…
1 Answer · 7 Views · Answered ✓
I Can NOT combine table hint Index and forceseek with two joins and the joins are not on the PK. How to make the first query compile? How to use sql…
1 Answer · 7 Views · Answered ✓
I am trying to use a MERGE statement to insert or delete rows from a table, but I only want to act on a subset of those rows. The documentation for…
1 Answer · 6 Views · Answered ✓
From this Microsoft doc,+ n defines the string length and can be a value from 1 through 8,000. max indicates that the maximum storage size is 2^31-1…
1 Answer · 5 Views · Answered ✓
As per the msdn, Subscriber version depends on the type of publication: A Subscriber to a transactional publication can be any version within two…
1 Answer · 775 Views · Answered ✓
I am inserting values from one SQL table/column into another. The datatypes are different for these columns due to other reasons but I do not…
1 Answer · 1.3K Views · Answered ✓
I am trying to install SQL Server 2019 on a Raspberry Pi 4 running Ubuntu 18.04. I am trying to follow the installation guide from Microsoft:…
1 Answer · 656 Views · Answered ✓
SQL Server 2012. Sample query at the bottom of this post. I'm trying to create a simple report for when a given database was last backed up. When…
2 Answers · 2.7K Views · Answered ✓
I have an MSSQL (2016) DB with multiple tables for accounts of customer that have similar names like bandwidth_timeseries_ACC_1111111,…
1 Answer · 2.4K Views · Answered ✓
I want to execute DESCRIBE query to view database table, but i am not able to as it shows error 'Incorrect syntax the keyword DESC' Query : DESC…
1 Answer · 1.3K Views · Answered ✓
I am tasked with devising a maintenance plan for our Sql Server 2005 databases. I know for backups I want to do a daily full database backup and…
1 Answer · 2.9K Views · Answered ✓
I am trying to avoid data loss when the insert trigger on a table fails. I am trying this with the following scenario and my code is failing. When an…
2 Answers · 2.5K Views · Answered ✓
Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.
Step-by-step SQL Server guides from industry experts
Common SQL Server interview questions, answered
Guides, tips and career advice on SQL Server from JanBask experts.
SQL Server Top 75 SSAS Interview Questions and Answers For Beginners & Experts
Prepare for your SSAS interview with our comprehensive guide featuring 75 top SQL Server Analysis Services interview questions…
SQL Server How to Become a SQL Database Administrator?
How to become a sql database administrator In 2025, discover what these professionals do, explore how much they earn and learn…
SQL Server OLAP vs OLTP: Key Differences, Architectures, Performance & Real-World Examples
Compare OLTP vs OLAP with clear definitions, architecture diagrams, real-world examples, and FAQs. Learn when to use each system…
SQL Server 70+ Most Asked SSIS Interview Questions for Freshers & Experienced
Prepare for your next SQL Server Integration Services (SSIS) interview with our top 70+ SSIS interview questions and answers.…
Pick another topic to find answers, interview questions, and real-world tips.