SQL Server Interview Questions And Answers
This is post going to be more like a list of question for self assessment. So I will not be...
2016-09-12
231 reads
This is post going to be more like a list of question for self assessment. So I will not be...
2016-09-12
231 reads
This is post going to be more like a list of question for self assessment. So I will not be...
2016-09-12
42 reads
Special
Table Types
Objective of this post is to provide a list of special
tables available in Sql Server and brief description of...
2016-09-08
181 reads
If you are reading this article, I assume
that you have basic knowledge of Index, its types and usage.
Over the...
2016-09-08
183 reads
Sql Server – Statistics (Create, Update and delete Statistics)
If you are reading this Article, I assume that you know the basics...
2016-09-07
313 reads
Sql Server – Listing all
tables Metadata (Table Size, row count, Index Size)
Suppose you need to find out Table size, row
count , index...
2016-09-06
338 reads
Top
Slowest Queries or Resource Extensive Queries
Whenever your database is facing any performance issue or resource scarcity,
the first step should be...
2016-09-06
230 reads
Find and Replace a value across all tables in database
In my project I faced this problem due to typing mistakes....
2016-08-31
551 reads
Monitoring the Performance of All Stored Procedures
Every Project suffer from this problem, over the time they
have developed many stored procedure...
2016-08-31
571 reads
Monitoring the Performance of All Stored Procedures
Every Project suffer from this problem, over the time they
have developed many stored procedure...
2016-08-31
442 reads
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
By Kevin3NF
Can we normalize a couple of things? 1 – Trade Schools. Back in the...
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...
Hi, I have two tables: one for headers with 9 fields and another for...
We're trying to understand how quick new versions of SQL server can be. Obviously...
hi we run 2019 std. we saw this week that someone hid 3 important...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers