User Posts: Vimal Lohani
Interesting Query

Interesting Query

Hi Guys! Today one of trainee in my team asked me one strange question, he shows a table and data - Then he asked me to get first 7th id row then 15th id row then 10th id ...

READ MORE +
0
SQL Server Features

SQL Server Features

Sql Server 2000 : Version 8 Query analyzer & enterprise manager are separate We can create 65535 databases only Datetime datatype used for both date & time ...

READ MORE +
0
A simple question for you on T-Sql

A simple question for you on T-Sql

Hi guys, Today i have a simple question for you & my question is what would be the result of the query- USE tempdb GO CREATE TABLE #Employee (EmpId INT, NAME VARCHAR(15), ...

READ MORE +
0
Experiment With Nth Highest Or Lowest Salary Or Record in Sql

Experiment With Nth Highest Or Lowest Salary Or Record in Sql

I was reading about it so i searched it on so many blogs & websites. Each blog has described this for employees having unique salaries, but what if few employees have same ...

READ MORE +
0
BigData Really…

BigData Really…

Hi guys, I was thinking since a long time to write blogs on big data. So, it is my first blog on BIGDATA. As a DBA, I always think where will I be after 5 years or 10 years from ...

READ MORE +
0
Introduction to Windows PowerShell (Part3)

Introduction to Windows PowerShell (Part3)

Hi guys, I am sorry for late due to busy work schedule. But now i am here to fulfill my promise - Today we will discuss about PowerShell scripts & there execution- If ...

READ MORE +
0
Introduction to Windows PowerShell (Part2)

Introduction to Windows PowerShell (Part2)

In this session, We will learn how you can control the result or output of command prompt & will also learn few more commands- If you are new to PowerShell, Please read ...

READ MORE +
0
Introduction to Windows PowerShell (Part1)

Introduction to Windows PowerShell (Part1)

Windows PowerShell is a configuration management framework to perform administrative tasks.This tool is developed by Microsoft & available from 2006.This is one of the best ...

READ MORE +
0
SQL Server Setup Discovery Reports & Related Queries

SQL Server Setup Discovery Reports & Related Queries

Microsoft Sql Server has given so many options to check which version of SQL installed on server. With this Discovery Report we can check how many instances installed on the ...

READ MORE +
0
Browsing All Comments By: Vimal Lohani