Interview Questions on sql server -Part-1
1. What is the Normalization?Normalization:-Normalization can be defined as the process of organization the data to reduce the redundant table...
2010-01-31
2,186 reads
Group by.....Having Clause
Group By:- Group By clauses is used to groups rows based on the distinct values of the specified columns.
The syntax...
2010-01-31
2,567 reads
Difference Between Having and Where Clause in Sql Server
Both Having Clause and Where clause is used to filter the data coming from the Select statement, but still there...
2010-01-31
11,972 reads
How to find duplicate values in a table
Sometimes duplicate values in tables can create a major problem when we do not make a primary key or a...
2010-01-31
4,054 reads
Sql Server View
Views:- View can be described as virtual table which derived its data from one or more than one table columns.It...
2010-01-31
1,732 reads
Stored Procedure to Get SQL Job Execution Status
Introduction
Ever need a programmatic way to figure out if a SQL Agent job is running? I did. After spending a...
2010-01-31
2,575 reads
Try Catch within an SSIS Script Tasks and Components
Using a Try/Catch/Finally within your Script Components and Script Tasks is just good coding practice. The thing you want to be able to do is push...
2010-01-30
2,606 reads
SEO my SQL Server Blog
I was going to spend today finishing off some SQL Server related blog posts, I currently have a list of...
2010-01-30
1,656 reads
SQLSaturday #41 Announced
Stuart Ainsworth will be coordinating the second SQLSaturday in Atlanta, this time on April 24th, 2010. Registration and call for...
2010-01-29
1,889 reads
Columbia Code Camp 2010
We're making a final push to let everyone know about the Columbia Code Camp 2010, which happens tomorrow, January 30....
2010-01-29
1,512 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Alamat BCA KCP Pondok Ungu Bekasi Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Sultan Agung No.19-20 Kavling Blok A, RT.007/RW.007, Medan Satria, Kecamatan Medan...
Alamat BCA KCP Central Park Telp:0821°8200°203
Telp/Wa 628218200203 Ruko GSA Blok Beufort 08 CB CC CD, RT.9/RW.5, South Tanjung Duren,...
Alamat BCA KCP Ruko Swadaya Telp:0821°7555°651
Telp/Wa 628217555651 Jl. Swadaya Raya No. 39 Ruko Swadaya City Square Blok 1. 11-23,...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers