How do I undelete sql server and get records back?
I mistakenly deleted around 2,000,000 records from a remote SQL Server 2008 table. The server is not granting me access to the backup files on the…
1 Answer · 622 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
I mistakenly deleted around 2,000,000 records from a remote SQL Server 2008 table. The server is not granting me access to the backup files on the…
1 Answer · 622 Views · Answered ✓
Many times I need to write something like the following when dealing with SQL Server. create table #table_name ( column1 int, column2 varchar(200)…
1 Answer · 0 Views · Answered ✓
I have a trigger (AFTER INSERT) that has been working in single inserts, and I believed it would work for multiples but its not. I researched it and…
1 Answer · 2.2K Views · Answered ✓
Here is a SELECT query of SELECT b.id, MIN(IFNULL(a.views,0)) AS counted FROM table1 a JOIN table2 b ON a.id=b.id GROUP BY id HAVING counted> How can…
1 Answer · 907 Views · Answered ✓
I need to recover my SQL Server sa password . The situation is: I don't know the SA password and Windows Authenticated user is no longer active user…
1 Answer · 1.8K Views · Answered ✓
When setting up a new SQL Server, I use the following code to determine a good starting point for the MAXDOP setting:/* This will recommend a MAXDOP…
1 Answer · 883 Views · Answered ✓
I find that most of my clients are not documenting their databases at all and I find that pretty scary. To introduce some better practice, I would…
1 Answer · 13 Views · Answered ✓
While generating some queries automatically with code I wrote to SELECT from a remote Pg database and insert into a local SQL Server database.…
1 Answer · 3.1K Views · Answered ✓
I want to the difference between Standard Server roles and Fixed server roles. I know Fixed Server roles include Sysadmin, Securityadmin, etc.I am…
1 Answer · 1.5K Views · Answered ✓
I am trying to create a new table with columns followed by their constraint as shown below. Create tblTest( columns.. .. .. Gender int, Constraint…
1 Answer · 1.8K Views · Answered ✓
In my query I am able to get column values as 1 and NULL. I would like to display True & False for 1 & NULL? /*Declare Variable*/ DECLARE…
2 Answers · 4.9K Views · Answered ✓
I have been following a SQL course for the past few weeks and I never have had this problem: my database is connected but I get the error message…
1 Answer · 3.0K 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.