• Home
  • SQL Server
    • Articles
    • T-SQL Puzzles
    • Output Puzzles
    • Interview Questions
    • Performance Tuning
    • SQL SERVER On Linux
    • Resources
  • SSRS
    • SSRS Articles
    • Interview Questions
  • SSAS
    • SSAS Articles
    • DAX
  • SQL Puzzles
  • Interview Questions
    • SQL Interview Questions
    • Data Interview Questions
  • Python Interview Puzzles
  • New Features(SQL SERVER)
    • SQL SERVER 2017
    • SQL SERVER 2016
    • SQL SERVER On Linux
  • Social
    • Expert Exchange
      • Top Expert in SQL
      • Yearly Award
      • Certifications
      • Achievement List
      • Top Expert of the Week
    • HackerRank (SQL)
    • StackOverflow
    • About Me
      • Contact Me
      • Blog Rules

Improving my SQL BI Skills

Improving my SQL BI Skills

Monthly Archives: April 2015

T-SQL Query | [ The Shortest Distance Puzzle / Graph Shortest Path Puzzle ]

29 Wednesday Apr 2015

Posted by Pawan Kumar Khowal in SQL SERVER, T SQL Puzzles

≈ 2 Comments

Tags

Complex SQL Challenges, Complex TSQL Challenge, Interview Qs.SQL SERVER Questions, Interview questions on Joins, Interview Questions on SQL, InterviewQuestions, InterviewQuestions for SQL, Joins, Joins Interview questions, Joins Puzzle, Learn complex SQL, Learn SQL, Learn T-SQL, Objective Puzzle, PL/SQL Challenges, Puzzles, Queries for SQL Interview, SELECT Puzzle, SQL, SQL 2012, SQL 2014, SQL 2014 Interview Questions, SQL Challenge, SQL Challenges, SQL Joins, SQL pl/sql puzzles, SQL Puzzles, SQL Queries, SQL SERVER Interview questions, SQL Skills, SQL Sudoku, SQLSERVER, T SQL Puzzles, T-SQL Challenge, Tough SQL Challenges, Tough SQL Puzzles, TSQL, TSQL Challenge, TSQL Challenges, TSQL Interview questions, TSQL Queries


T-SQL Query | [ The Shortest Distance Puzzle ] / [ Graph Shortest Path Puzzle ]

Puzzle Statement

  1. Input table “Area” contains Distance FromPoint , ToPoint and the distance between these points or Areas.
  2. The Puzzle is that you have find out the shortest distance between FromPoint to ToPoint considering all the Paths
  3. Please check out the sample input and expected output for details.

Sample Input

ID FromPoint ToPoint Distance
0 NULL SECTOR 5 0
1 SECTOR 5 SECTOR 22 5
2 SECTOR 5 SECTOR 23 10
3 SECTOR 22 SECTOR 23 15
4 SECTOR 23 SECTOR 14 20
5 SECTOR 22 SECTOR 14 25
6 SECTOR 5 SECTOR 14 35
6 SECTOR 22 SECTOR 31 40
6 SECTOR 23 SECTOR 31 45

Expected Output

Paths Distance
.SECTOR 5..SECTOR 23..SECTOR 14. 30
.SECTOR 5..SECTOR 22..SECTOR 14. 30

Rules/Restrictions

  • Your solution should be should use “SELECT” statement or “CTE”
  • Your solution should be generic in nature.
  • Add your solution(s) in the comments section or send you solution(s) to pawankkmr@gmail.com

Script

Use the below script to generate the source table and fill them up with the sample data.


--

CREATE TABLE Area
(      

 ID  INT
,FromPoint VARCHAR(10)
,ToPoint VARCHAR(10)
,Distance INT

)
GO

INSERT INTO Area VALUES
(0 ,NULL       , 'SECTOR 5'  ,0),
(1 ,'SECTOR 5' , 'SECTOR 22' ,05),
(2 ,'SECTOR 5' , 'SECTOR 23' ,10),
(3 ,'SECTOR 22', 'SECTOR 23' ,15),
(4 ,'SECTOR 23', 'SECTOR 14' ,20),
(5 ,'SECTOR 22', 'SECTOR 14' ,25),
(6 ,'SECTOR 5' , 'SECTOR 14' ,35),
(6 ,'SECTOR 22', 'SECTOR 31' ,40),
(6 ,'SECTOR 23', 'SECTOR 31' ,45)

--

Update Apr 29 | Solution 1


--

DECLARE @StartingPoint AS VARCHAR(50) = 'SECTOR 5'
DECLARE @EndingPoint AS VARCHAR(50) = 'SECTOR 14'
;WITH CTE1 AS
(
	SELECT ToPoint ,
		CASE WHEN FromPoint IS NULL THEN CAST('.'+ISNULL(FromPoint,ToPoint)+'.' AS VARCHAR(MAX))
		     WHEN FromPoint IS NOT NULL THEN CAST('.'+FromPoint+'.'+ToPoint+'.' AS VARCHAR(MAX))
		END  FullyQualifiedName
	, Distance FinalDistance
	FROM Area WHERE ( FromPoint = @StartingPoint )
	UNION ALL
	SELECT a.ToPoint , c.FullyQualifiedName+'.'+a.ToPoint+'.' FullyQualifiedName
	, FinalDistance + a.Distance FinalDistance
	FROM Area a INNER JOIN CTE1 c ON a.FromPoint = c.ToPoint
)
,CTE2 AS
(
	SELECT * , RANK() OVER (ORDER BY FinalDistance) rnk FROM CTE1
	WHERE ToPoint = @EndingPoint AND PATINDEX('%'+@EndingPoint+'%',FullyQualifiedName) > 0
)
SELECT FullyQualifiedName, FinalDistance FROM CTE2 WHERE rnk = 1
--

Add a comment if you have any other solution in mind. We all need to learn.

Keep Learning

Http://MSBISkills.com

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

SQL SERVER Interview Questions – SET 1

27 Monday Apr 2015

Posted by Pawan Kumar Khowal in Download SQL Interview Q's

≈ 1 Comment

Tags

Advanced SQL interview questions, Advanced SQL Queries, Advanced SQL tutorial, Advanced SQL tutorial pdf, Difficult SQL Interview Questions, Download SQL Questions, Download SQL Server Interview Question in PDF, Download SQL SERVER Interview questions, Download SQL Server Interview questions and answers, download sql server interview questions and answers pdf, download sql server interview questions by Pawan Khowal, download sql server interview questions by Pawan Kumar, download sql server interview questions by Pawan Kumar Khowal, Download T-SQL Interview Questions, Free Download SQL SERVER Interview questions, Interview Qs.SQL SERVER Questions, Interview questions on Joins, Interview Questions on SQL, InterviewQuestions, InterviewQuestions for SQL, Joins, Joins Interview questions, Joins Puzzle, Objective Puzzle, Puzzles, Queries for SQL Interview, SELECT Puzzle, SQL, SQL 2012, SQL 2014, SQL 2014 Interview Questions, SQL Common Interview Questions, SQL Common Interview Questions and answers, SQL FAQ, SQL FAQs, SQL Interview Q & A, SQL Interview Questions, SQL Joins, SQL Puzzles, SQL Queries, SQL Queries asked in interviews, SQL Questions, SQL Server, SQL Server - General Interview Questions and Answers, SQL Server developer Interview questions and answers, SQL Server developer Interview questions with answers, SQL SERVER Interview questions, SQL SERVER Interview questions & Answers, SQL Server Interview questions and answers, SQL Server Interview Questions and Answers - Free PDF, SQL SERVER Interview questions and answers for experienced, sql server interview questions and answers for net developers, SQL SERVER Interview questions for experienced, SQL SERVER Interview questions pdf, SQL SERVER Tips, SQL SERVER Tricky questions, SQL Skills, SQL Tips & Tricks, SQL Tips and Tricks, SQL Tricks, SQL Tricky question, SQL Tutorial, SQLSERVER, T SQL Puzzles, T-SQL, T-SQL Interview questions, T-SQL Programming, T-SQL Server Interview Questions, T-SQL Tutorial, TOP 100 SQL SERVER INTERVIEW QUESTIONS, Top 50 SQL Server Questions & Answers, Tough PL SQL Interview Questions, Tough SQL Interview Questions, Tough SQL Queries, Tough SQL Queries Interview Questions, Tough SQL Questions, Tricky SQL Interview Questions, Tricky SQL Interview Questions and answers, Tricky SQL Queries for Interview, Tricky SQL SERVER Interview Questions and answers, TSQL, TSQL Interview questions, TSQL Queries


SQL SERVER Interview Questions – SET 1 ( 100+ Questions )

CLICK HERE (SQL SERVER Interview Questions) to download the questions in PDF format.

I have been collecting interview questions from the people who have given interviews at various organizations. Please go through these questions before attending any technical Interview. Below are the list of questions on SQL Server. Please add a comment if you have any question in mind , will add that also.

Sr No Question
1 What are statistics? Where they are used and how to check statistics.
2 What are the types of Fragmentations
3 Can we use GUID as Primary key in a table ?
4 Difference between Unique Index vs Unique Constraint
5 What are RED Flags in SQL Server and what is there usage ?
6 What are the types of physical joins in SQL Server ? What are the different join operators in SQL Server?
7 What is a Latch in SQL Server ?
8 Difference between Latch and Lock ..
9 2014 New Features in DB Engine.
10 In which scenarios we should not use CTE’s.
11 What do you mean by Cardinality in SQL Server.
12 What are Histogram and Density Vector.
13 Why we can’t put Order by inside the view?
14 What is a cross apply and how to use this?
15 Can we use more than one CTE in a single select query?
16 I have opened a nested transaction inside an outer transaction, if i do rollback which transaction will be undone?
17 How do you know the total transaction count?
18 I have created a table variable can we use it in a nested stored procedure? If not what is the scope of a table variable?
19 If suppose we have a user defined data type. If we can modify the length of the data type does it effects in all places across the database?
20 Can we fire a trigger manually?
21 What are the magic tables? Do we have “Updated” magic table?
22 What is the difference between UnionAll and Merge?
23 Basic difference between stored procedure and user defined function?
24 See we have a simple query that’s calling a static function, like “Select * from employee where joiningdate < getstaticdate()”? Does it call function for every time or only for matched rows? How you tune this query?
25 Why should we use CTE?
26 What is the difference between sub query and correlated query
27 What is the difference between pessimistic locking and optimistic locking?
28 What is XACT_ABORT ON?
29 How to filter nested stored procedure code from profiler?
30 What happens when a rollback happens in inside a nested stored procedure?
31 What is a bitmap index?
32 How to avoid bookmark lookup in execution plan?
33 When index scan happens?
34 Does temp tables and table variables both stored in tempdb?
35 Why cursors are so costly?
36 Can we call a procedure from a function?
37 Can we write DML inside a function?
38 What is the best value for MAXDOP value?
39 Which is better “Left Outer” Or “NOT EXIST”?
40 How to find the statistics are outdated?
41 How to find the query running on a given SPID?
42 What are the limitations on “SET ROWCOUNT”?
43 While creating a “Include” columns on which basis we should consider main column and include columns?
44 How to find the last statistics update date?
45 An indexed view is referring only one base table. Both view and table are having index defined on them. Which index would be utilized when a query executed against the table.
46 I have an indexed view, now base table data has been modified, does the modified data reflected in view automatically?
47 Does “TRUNCATE” DDL or DML command?
48 I have written a recursive CTE, it’s been running infinitely and failed with an error. The requirement is that the recursion required for 45000 times. How could you be able to handle the situation?
49 What is index reorganization?
50 How sql engine knows which index has to be used while dealing with indexed views?
51 How to prevent bad parameter sniffing? What exactly it means?
52 What dll file that handle the transaction logs in logshipping?
53 How to find all dependent objects of a table?
54 Which is better a CTE or a subquery? Why?
55 How to rebuild a master database? Ho to restore a master database?
56 Any alternative to triggers?
57 Top performance tuning tools
58 What events need to be added to capture execution plan in sql profiller?
59 What is the new lock escalation in sql 2008?
60 What is a filtered index?
61 What happens when a transaction runs on SQL server? Let’s say simple update statement “Update Table set col1 = value where col2 = value”
62 What is fragmentation? How it happens?
63 I have a log file which is of 250 GB. Log is full. We don’t have a disk space on any other drive for creating .ndf, auto growth is ON , and essentially there are no options to allocate new space for the file. What’s your action plan?
64 How B-Tree formed for Clustered and non clustered indexes?
65 How B-Tree forms for indexes with included column?
66 Does alzebrizer tree stores in memory for stored procedures, views and constraints?
67 How to design TempDB files? And what is the limit?
68 How VLF’s created for tempDB?
69 When the checkpoint can happen? What it exactly do?
70 When the lazywriter happens and what it’ll do?
71 What is memory grant in SQL Server?
72 Why resourceDB introduced?
73 How to move master database?
74 How to rebuild master database and what are the considerations?
75 What is a boot page?
76 What is .TUF file? What is the significance of the same? Any implications if the file is deleted?
77 What are the different shrink options?
78 How do you know whether statistics are latest or expired?​
79 How to create linked server
80 Can you give some examples for One to One, One to Many and Many to Many relationships?
81 How to capture a trace from production without any impact on performance?
82 How to capture the long running queries?
83 You have any idea on Table Partitions?
84 You have got a request to execute a query which is an “Update” query. That update is updating 5 million rows, after an hour it’s still executing and you are getting lot of requests from report users that their things are getting slow down. What’s your action plan?
85 See we have a view which is getting data from different tables. One day it’s starts executing infinitely. I have seen no blocking , no bulk operation happened. I have stopped all jobs and maintenance plans on the server. No one is connected to the database but still it’s been taking longer time. What might be the possible reasons?
86 Can you explain sql server transaction log architecture?
87 What are the phases of sql server database restore process?​
88 Do you have any idea about sparse column?
89 We have a procedure which is running fine till today afternoon. Suddenly it started taking long time to execute and there of it leads to a timeout error from application. What might be happening? How you troubleshoot?
90 What are the critical issues you faced in your career?
91 How to change the port number for SQL Server? Default port no of SQL SERVER
92 Difference between ISNULL and COAELSCE
93 Difference between partition by and patindex
94 What is the difference between CROSS / OUTER APPLY AND JOINS in T-SQL?
95 What is stuff function? Difference between stuff and replace?
96 We have a query which is running fine in development but facing performance issues at production. You got the execution plan from production DBA. Now you need to compare with the development execution plan. What is your approach?
97 What is lock Escalation
98 How do you retrieve random 5 rows from a table
99 What exactly you check in the query execution plan window?
100 What is the output of len(1234.56)
101 Where in MS SQL Server is ’100’ equal to ‘0’?
102 Explain clearly about all the normal forms with proper example
103 I have a table with millions of rows. I want to retain only last 5% of the rows ? How do u do it ? (Expectation :- transfer last 5% to temp table
104 Considerations  while designing a DB
105 Considerations while creating tables and its naming conventions
106 Explain transaction log in detail
107 I have a 500 GB Table which is performing slow ? Your plan of action ?
108 Explain Column Store Index
109 Explain Isolation Levels ? Default one ?

 

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

Different Methods to generate Row Numbers without using Row_Number function

25 Saturday Apr 2015

Posted by Pawan Kumar Khowal in SQL Concepts, SQL SERVER, SQL Server Interview Questions

≈ Leave a comment

Tags

Different Methods to generate Row Numbers without using Row_Number function, generate Row Numbers in SQL 2000, generate Row Numbers without using Row_Number function, generating row number with Plain SQL, Interview Qs.SQL SERVER Questions, Interview Questions on SQL, InterviewQuestions, InterviewQuestions for SQL, Queries for SQL Interview, SELECT Puzzle, SQL, SQL 2012, SQL 2014, SQL 2014 Interview Questions, SQL Joins, SQL Puzzles, SQL Queries, SQL SERVER Interview questions, SQL Skills, SQLSERVER, T SQL Puzzles, TSQL, TSQL Interview questions, TSQL Queries


Different Methods to generate Row Numbers without using Row_Number function

Well as far as I know there are two methods-

Method 1 | Using Temp Table


--

-----------Method 1----------------
--In this method we are generating row numbers while inserting data in a temp table

SELECT 
	  IDENTITY(INT,1,1) rowNum
	, dt 
INTO #temp FROM testRowNumber


SELECT * FROM #temp


DROP TABLE #temp

--

Output of the above query is –

RowNum1

Method 2 | Using SQL Statements

Adding a row number for each row is not easy using SQL. Below method only works if there is at least one unique column or the combination of column is unique in the table.


--

-----------Method 2----------------
--Here we are generating row number with Plain SQL

SELECT 
	  (SELECT COUNT(*)  FROM testRowNumber i WHERE o.dt >= i.dt) rowNum 
	, dt
FROM testRowNumber o
--

Output of the above query is –

RowNum2

Add a comment if you have any other solution in mind. We all need to learn.

Keep Learning

Http://MSBISkills.com

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

Different Methods to get Row Numbers WITHOUT Order By Clause in SQL Server

25 Saturday Apr 2015

Posted by Pawan Kumar Khowal in SQL Concepts, SQL SERVER

≈ Leave a comment

Tags

%%physloc%%, Different Methods to get Row Numbers WITHOUT Order By Clause in SQL Server, How to get row numbers in SQL SERVER, Interview Qs.SQL SERVER Questions, Interview Questions on SQL, InterviewQuestions, InterviewQuestions for SQL, MS SQL, New (undocumented) physical row locator function, Queries for SQL Interview, Row Number, Row Numbers WITHOUT Order By Clause in SQL Server, SELECT Puzzle, SQL, SQL 2012, SQL 2014, SQL 2014 Interview Questions, SQL Joins, SQL Puzzles, SQL Queries, SQL Server, SQL SERVER Interview questions, SQL Skills, SQLSERVER, sys.fn_PhysLocCracker, T SQL Puzzles, TSQL, TSQL Interview questions, TSQL Queries


Add Row Number Based on Physical Location in SQL Server
OR
 Add Row Number WITHOUT Order By Clause in SQL Server

Adding a row number to your SQL code is very common and pretty easy. We can also say that it is almost very common now a days to use a Row Number ( Ranking Functions )

Note – Flag referred in all the queries is a sample table created by me.

Sample Example


--

SELECT 
ROW_NUMBER() OVER ( ORDER BY Tim ASC ) AS RowNumber
, f.*
FROM flag f  

--

Now lets say we want Row Numbers with out this ORDER BY Column Clause. We can use below methods to get row numbers without ORDER by Column.

Different Methods to Get Row Numbers without ORDER BY Column


--

--METHOD 1 | Using SELECT NULL
SELECT * , ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) RowNumber FROM Flag


--METHOD 2 | Using %%physloc%%
SELECT * , ROW_NUMBER() OVER (ORDER BY %%physloc%%) RowNumber FROM Flag


--METHOD 3 | Using SELECT 1 (You can use any number here)
SELECT * , ROW_NUMBER() OVER (ORDER BY (SELECT 1)) RowNumber FROM Flag


--Method 4 | Using %%lockres%%
SELECT * , ROW_NUMBER() OVER (ORDER BY %%lockres%%) RowNumber FROM Flag


--Method 5 | Using sys.fn_PhysLocCracker(%%physloc%%) , file_id, page_id, slot_id
--Row Number Based on Physical Location in SQL Server

SELECT f.*,
ROW_NUMBER() OVER(ORDER BY file_id, page_id, slot_id) AS Row
FROM flag f 
CROSS APPLY sys.fn_PhysLocCracker(%%physloc%%)
ORDER BY Row

--

What is %%physloc%%

%%physloc%% is a Virtual Column. This column is undocumented. Hence you can use it at you own risk.The %%physloc%% virtual column returns a record locator value similar to the one you can find in the different lock related trace events. Actually each table has a “hidden” column called %%physloc%% which stores a row’s physical location in hexidecimal form. That’s pretty hard to understand. SQL Server offers a way for us to read this information a little more easily: the sys.fn_PhysLocFormatter function, which is present on sqlskills.com. According to Paul Randal of sqlskills.com – It gives the database file, page within the file, and slot number on the page in the format (file:page:slot).

sys.fn_PhysLocCracker – This function cracks the output of %%physloc%% virtual column. If you want to go in detail about this function use below link-

http://www.sqlskills.com/blogs/paul/sql-server-2008-new-undocumented-physical-row-locator-function/#comment-218767


--

-----------Method 1----------------

SELECT * ,%%physloc%% PhysicalLocation
FROM flag f 
CROSS APPLY sys.fn_PhysLocCracker(%%physloc%%)


-----------Method 2----------------
SELECT * , %%physloc%% PhysicalLocation FROM flag

--

Output of Method 1 given below-

PhysicalLocation

Add a comment if you have any other solution in mind. We all need to learn.

Keep Learning

Http://MSBISkills.com

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

T-SQL Query | [ The ASCII Puzzle ]

25 Saturday Apr 2015

Posted by Pawan Kumar Khowal in SQL SERVER, T SQL Puzzles

≈ 2 Comments

Tags

Complex SQL Challenges, Complex TSQL Challenge, Interview Qs.SQL SERVER Questions, Interview questions on Joins, Interview Questions on SQL, InterviewQuestions, InterviewQuestions for SQL, Joins, Joins Interview questions, Joins Puzzle, Learn complex SQL, Learn SQL, Learn T-SQL, Objective Puzzle, Perfect Numbers, PL/SQL Challenges, Puzzles, Queries for SQL Interview, SELECT Puzzle, SQL, SQL 2012, SQL 2014, SQL 2014 Interview Questions, SQL Challenge, SQL Challenges, SQL Joins, SQL pl/sql puzzles, SQL Puzzles, SQL Queries, SQL SERVER Interview questions, SQL Skills, SQL Sudoku, SQLSERVER, T SQL Puzzles, T-SQL Challenge, Tough SQL Challenges, Tough SQL Puzzles, TSQL, TSQL Challenge, TSQL Challenges, TSQL Interview questions, TSQL Queries


T-SQL Query | [ The ASCII Puzzle ]

Puzzle Statement

We have characters A to Z if the input is A then it should be print Z, if the input is B then o/p will be Y.

Sample Input & Corresponding Expected Output

Sample Input  Expected Output
Z A
A Z
B Y
C X

UPDATE – 25-Apr-2015 – Solution 1


--

DECLARE @t AS VARCHAR(1)= 'C'
SELECT CHAR(ASCII('A') + ASCII('Z') - ASCII(@t)) 

--

Add a comment if you have any other solution in mind. We all need to learn.

Keep Learning

http://MSBISkills.com

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email
← Older posts

Blog Stats

  • 1,074,522 hits

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,131 other subscribers

Pawan Khowal

502 SQL Puzzles with answers

Achievement - 500 PuzzlesJuly 18, 2018
The big day is here. Finally presented 500+ puzzles for SQL community.

200 SQL Server Puzzle with Answers

The Big DayAugust 19, 2016
The big day is here. Completed 200 SQL Puzzles today

Archives

April 2015
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
27282930  
« Mar   May »

Top Articles

  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…

Archives

  • October 2020 (29)
  • September 2018 (2)
  • August 2018 (6)
  • July 2018 (25)
  • June 2018 (22)
  • May 2018 (24)
  • April 2018 (33)
  • March 2018 (35)
  • February 2018 (53)
  • January 2018 (48)
  • December 2017 (32)
  • November 2017 (2)
  • October 2017 (20)
  • August 2017 (8)
  • June 2017 (2)
  • March 2017 (1)
  • February 2017 (18)
  • January 2017 (2)
  • December 2016 (5)
  • November 2016 (23)
  • October 2016 (2)
  • September 2016 (14)
  • August 2016 (6)
  • July 2016 (22)
  • June 2016 (27)
  • May 2016 (15)
  • April 2016 (7)
  • March 2016 (5)
  • February 2016 (7)
  • December 2015 (4)
  • October 2015 (23)
  • September 2015 (31)
  • August 2015 (14)
  • July 2015 (16)
  • June 2015 (29)
  • May 2015 (25)
  • April 2015 (44)
  • March 2015 (47)
  • November 2012 (1)
  • July 2012 (8)
  • September 2010 (26)
  • August 2010 (125)
  • July 2010 (2)

Article Categories

  • Analysis Services (6)
    • DAX (6)
  • Data (2)
    • Data warehousing (2)
  • Integration Services (2)
  • Magazines (3)
  • Python (29)
  • Reporting Services (4)
  • SQL SERVER (820)
    • Download SQL Interview Q's (212)
    • SQL Concepts (323)
    • SQL Performance Tuning (155)
    • SQL Puzzles (331)
    • SQL SERVER 2017 Linux (6)
    • SQL Server Interview Questions (308)
    • SQL SERVER Puzzles (332)
    • T SQL Puzzles (547)
    • Tricky SQL Queries (439)
  • UI (30)
    • ASP.NET (5)
    • C# (13)
    • CSS (9)
    • OOPS (3)
  • Uncategorized (5)

Recent Posts

  • Python | The Print and Divide Puzzle October 30, 2020
  • Python | Count consecutive 1’s from a list of 0’s and 1’s October 30, 2020
  • Python | How to convert a number into a list of its digits October 26, 2020
  • Python | Validate an IP Address-IPV6(Internet Protocol version 6) October 26, 2020
  • Python | Print the first non-recurring element in a list October 26, 2020
  • Python | Print the most recurring element in a list October 26, 2020
  • Python | Find the cumulative sum of elements in a list October 26, 2020
  • Python | Check a character is present in a string or not October 26, 2020
  • Python | Check whether a string is palindrome or not October 26, 2020
  • Python | Find the missing number in the array of Ints October 26, 2020
  • Python | How would you delete duplicates in a list October 26, 2020
  • Python | Check whether an array is Monotonic or not October 26, 2020
  • Python | Check whether a number is prime or not October 26, 2020
  • Python | Print list of prime numbers up to a number October 26, 2020
  • Python | Print elements from odd positions in a list October 26, 2020
  • Python | Print positions of a string present in another string October 26, 2020
  • Python | How to sort an array in ascending order October 26, 2020
  • Python | How to reverse an array October 26, 2020
  • Python | Find un-common words from two strings October 26, 2020
  • Python | How to convert a string to a list October 26, 2020
  • Python | Find unique words from a string October 26, 2020
  • Python | Calculate average word length from a string October 26, 2020
  • Python | Find common words from two strings October 26, 2020
  • Python | Find the number of times a substring present in a string October 26, 2020
  • Python | Find maximum value from a list October 26, 2020
  • Python | How to find GCF of two numbers October 26, 2020
  • Python | How to find LCM of two numbers October 26, 2020
  • Python | How to convert a list to a string October 26, 2020
  • Python | Replace NONE by its previous NON None value October 26, 2020
  • Microsoft SQL Server 2019 | Features added to SQL Server on Linux September 26, 2018

Create a website or blog at WordPress.com

  • Follow Following
    • Improving my SQL BI Skills
    • Join 231 other followers
    • Already have a WordPress.com account? Log in now.
    • Improving my SQL BI Skills
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...
 

You must be logged in to post a comment.