How to differ datetime2(0) vs datetime2(2)?
According to the documentation datetime2 (Transact-SQL): Storage size bytes for precisions less than bytes for precisions 3 and 4. All other…
1 Answer · 297 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
According to the documentation datetime2 (Transact-SQL): Storage size bytes for precisions less than bytes for precisions 3 and 4. All other…
1 Answer · 297 Views · Answered ✓
I thought LocalDB was installed as a component of Visual Studio, which could be used for development purposes. However, it appears to be installed…
1 Answer · 475 Views · Answered ✓
When I want a column to have distinct values, I can either use a constraint create table t1( id int primary key, code varchar(10) unique NULL ); go…
1 Answer · 1.4K Views · Answered ✓
How do I find a list of tables that have a FULLTEXT INDEX applied to them on a given database? For example, you can enable and disable a FULLTEXT…
1 Answer · 1.2K Views · Answered ✓
How do I truncate the transaction log in a SQL Server 2008 database?What are possible best ways?I tried this from a blog as follows: 1) From the…
1 Answer · 1.4K Views · Answered ✓
I have a procedure that creates a clustered and a non-clustered index on a table in order to do a partition swap. The problem I have is the clustered…
1 Answer · 280 Views · Answered ✓
How to send email from SQL Server Jobs in SQL Server 2014. I want to implement email notification through stored procedures instead of Windows…
1 Answer · 443 Views · Answered ✓
This error occurs when I run the setup.exe of SQL 2014.It tried changing the compatibility mode of the setup from Windows 95 through Windows Vista…
1 Answer · 832 Views · Answered ✓
I just installed SSMS 18 GA on a computer with only VS2019 installed, and when I try to open SSMS the splash screen will come up, but then the…
1 Answer · 1.4K Views · Answered ✓
I would like the exact version mentioned since my application does not support the 11.0.5058 version of the SQL Server Native Client (sqlncli).
1 Answer · 467 Views · Answered ✓
When comparing the execution time of two different queries, it's important to clear the cache to make sure that the execution of the first query does…
1 Answer · 1.7K Views · Answered ✓
I have a table with an IDENTITY column. While developing I delete the rows from time to time and add them again. But the IDENTITY values always kept…
1 Answer · 3.3K 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.