How to make SSMS uppercase keywords
I recently started using Management Studio 2012. When using MySQL Workbench, a handy feature was that I could stay all in lowercase and any reserved…
1 Answer · 1.7K Views · Answered ✓
I recently started using Management Studio 2012. When using MySQL Workbench, a handy feature was that I could stay all in lowercase and any reserved…
1 Answer · 1.7K 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 practices, I would…
1 Answer · 1.3K Views · Answered ✓
Why does MS SQL Server refuse using supporting filtered indexes in this scenario?-- demo data CREATE TABLE #Test ( ID INT IDENTITY(1,1) NOT NULL…
1 Answer · 2.2K Views · Answered ✓
Say I have a Customers table, and an Emails table. The emails table has these fields: Id CustomerId EmailValue Now, I want to create a constraint so…
1 Answer · 1.6K Views · Answered ✓
I've heard (I am pretty sure) that Developer Edition is free of charge and for downloading its registration is not required. But when I started…
2 Answers · 5.4K Views · Answered ✓
Why MS SQL Server refuse using supporting filtered index in this scenario?-- demo data CREATE TABLE #Test ( ID INT IDENTITY(1,1) NOT NULL CONSTRAINT…
1 Answer · 1.5K Views · Answered ✓
I have always assumed that it is better to use a Set in my query filters instead of a List. For example: Set parentIds = generateParentIds(); List…
1 Answer · 2.0K Views · Answered ✓
So I'm a noob here and have been doing some research on why my internet (cable modem) locks up about once or twice a week ever since installing a…
1 Answer · 1.8K Views · Answered ✓
I want to install SQL Server Configuration Manager in order to configure SQL Aliases, but I don't want to install the entire SQL Server. I expected…
1 Answer · 1.5K Views · Answered ✓
What is the CHECK constraint in SQL Server? I have some auto-generated T-SQL, which is probably valid, but I don't really understand. ALTER TABLE…
1 Answer · 2.1K Views · Answered ✓
My application currently has "soft delete" built-in to most tables with a BIT "deleted" column. There is now a requirement for "hard delete"…
2 Answers · 6.7K Views · Answered ✓
I recently added a NULL-able bit column to a table that has close to 500 million rows. There's no default on the column, however, all inserts are…
1 Answer · 1.7K Views · Answered ✓
Learners asking and answering questions on the same topics — follow their questions and join in.
Cyber Security learner
159Questions 203AnswersCyber Security learner
147Questions 179AnswersCyber Security learner
136Questions 158AnswersCyber Security learner
106Questions 142AnswersSalesforce learner
102Questions 162AnswersSalesforce learner
97Questions 128AnswersGuides, 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.…
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