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've found several sources that state ALTER TABLE ... DROP COLUMN is a metadata-only operation. Source How can this be? Does the data during a DROP…
1 Answer · 2.1K Views · Answered ✓
SQL Server 2014, Std Ed I have read that percent_complete in dm_exec_requests does not work for CREATE INDEX, and in practice, percent_complete…
2 Answers · 3.0K Views · Answered ✓
I have a CSV file with 350,000 rows. Would like to insert data to the temporary table in the same order as is in the CSV file. I am trying to BULK…
1 Answer · 5 Views · Answered ✓
In SQL Server 2005, is there a way to find users that either don't exist at the server level (an account that was deleted at server level but wasn't…
1 Answer · 595 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 · 619 Views · Answered ✓
Can someone guide me in on what this option actually does and what would it affect if I were to suddenly uncheck it in an established production…
1 Answer · 4 Views · Answered ✓
I have a database on SQL Azure and I am looking to create a database diagram for same. But I don't want to have to install an SQL server and copy the…
1 Answer · 348 Views · Answered ✓
I have code that is working okay in PostgreSQL and I now have to port this code to MS SQL Server. It involves tables with potential cycles on…
1 Answer · 722 Views · Answered ✓
I have rebuilt all indexes in my database setting a fill factor of 95 (5% free space) using a certain maintenance plan. After the reindex the…
1 Answer · 413 Views · Answered ✓
I have made a script that, one at a time, deletes all the foreign keys from a database, just like this:ALTER TABLE MyTable1 DROP CONSTRAINT…
1 Answer · 461 Views · Answered ✓
I have inherited a SQL server {2012 (SP3), but this question is intended to be generic} . We are using SCOM to monitor it. Previously I was getting…
1 Answer · 1.6K Views · Answered ✓
I face recently a problem when starting SQL Server Management Studio. As it can't start, I uninstall it. When trying to install it again, I am asked…
1 Answer · 374 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.
