Rohit Garg

I, Rohit Garg, am working as Consultant in IT Company. I am having an around 5 years of experience in MSSQL server & other Microsoft technologies. I am working as DBA in Microsoft SQL Server from last 5 years in e-Commerce, Telecom, Finance domain. In this tenure, I got a chance of working as Database administrator, Developer and trainer on SQL server 2000 to SQL Server 2012. I am holding Master’s degree in Computer Science along with certification in SQL Server & .Net. I like to learn new things by hand-on experience on regular basis. This journey is so far is delightful & valuable with the addition of wonderful friends.

Write-Host || Cannot invoke this function because the current host does not implement it

by Rohit Garg

MSSQLFUN

Issue: While running powershell in SQL job step, I am getting below error: –
A job step received an error at...

2017-02-01

1,464 reads

Error While running PowerShell code from SQL Agent job – “Path Does Not Exist”

by Rohit Garg

MSSQLFUN

Issue: When I am running code from PowerShell console its running fine but when I execute it through SQL agent...

2017-01-23

1,042 reads

What’s new in SQL Server 2016 installation?

by Rohit Garg

MSSQLFUN

1) As MS is kept increasing number of option while installation. To reduce no. of click, if setup pass Rules...

2017-01-16

562 reads

Sequence – Long awaited feature

by Rohit Garg

MSSQLFUN

As per BOL (https://msdn.microsoft.com/en-us/library/ff878058(v=sql.110).aspx) : A sequence is a user-defined schema-bound object that generates a sequence of numeric values according to...

2017-01-05

472 reads

What is “SET STATISTICS TIME”?

by Rohit Garg

MSSQLFUN

When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...

2016-12-19

401 reads

What is “SET STATISTICS TIME”?

by Rohit Garg

MSSQLFUN

When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...

2016-12-19

369 reads

What is “SET STATISTICS TIME”?

by Rohit Garg

MSSQLFUN

When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...

2016-12-19

446 reads

How to use DTA (Database Tuning Advisor) with Plan Cache option?

by Rohit Garg

MSSQLFUN

SQL Server 2012 comes up with new workload option in DTA (Database Tuning Advisor). In addition, on existing options File...

2016-12-12

2,615 reads

MSDB log file grown large – SLEEP_MSDBSTARTUP waittype

by Rohit Garg

MSSQLFUN

Issue: MSDB database log file is getting full very rapidly and became very huge. Currently, T-Log file is of 5GB...

2016-11-30

861 reads

We are Back Again..

by Rohit Garg

MSSQLFUN

After lots of crisis in last month, We are back again.
Sorry for inconvenience caused !
Reference : Rohit Garg (http://mssqlfun.com/)
You can find...

2016-11-15

515 reads

Blogs

How to find free space in Azure PosgreSQL

By hellosqlkitty

I wanted to figure out how big (or approximately how big) my dump file...

T-SQL Tuesday #180: Good enough is perfect Roundup

By hellosqlkitty

This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...

Using SQL Compare with Read-only Access

Recently a customer asked if SQL Compare and SQL Data Compare can be used...

Read the latest Blogs

Forums

Compare rows within the same table

I have a table. Structure in script below. I have to compare and see...

Microsoft Recommendations for Update Stats?

By Brandie Tarvin

I have an application team that is insisting on daily (and for some, weekly)...

how can i tell if our db2 driver is ms or ibm or other?

i see this in the definition of a linked server on our wh sql...

Visit the forum

Question of the Day

A Strange Result

What does this code return in SSMS 20 from SQL Server 2019?

select '|' + CHAR(0)+'abc' + '|';

See possible answers