618 reputation
313
bio website
location New Delhi, India
age 29
visits member for 2 years, 5 months
seen yesterday

Sep
26
answered MongoDB: how to get the all the embedded data?
Jul
16
awarded  Yearling
Jul
2
awarded  Curious
May
27
awarded  Notable Question
Apr
3
comment How to solve the error Msg 547, Level 16, State 0, Line 1
Make sure first, you have no any such records in your child table and take care of that record otherwise it will conflict the constraint.
Apr
3
answered How to solve the error Msg 547, Level 16, State 0, Line 1
Apr
2
asked Optimizing MySQL query
Mar
25
answered How can I change the names of all tables to uppercase?
Mar
12
answered DMV queries for capturing most frequently used queries and worst performing queries
Feb
24
answered Agent Xps getting disabled automatically
Feb
20
answered SQL Server Table Backup
Feb
20
comment SQL Server Table Backup
DDL is not possible to rollback until you use BEGIN TRANSACTION. You have to recover these tables from old backups.
Jan
8
awarded  Popular Question
Nov
6
comment Alternative of a query
My problem has been resolved. Actually there was mismatch of datatypes of join column, one is varchar and second one is nvarchar. As I make both column of same datatype query returns result in quick. Thanks!
Nov
4
comment Alternative of a query
The above query works fine if I exclude " AND a.row_number < 319102" part and if I include this the query returns the same execution plan as for the TOP and goes into nested loops.
Nov
4
asked Alternative of a query
Oct
16
comment Count issue in Mysql
true, it might alias the count(*) and return 1. Thanks
Oct
16
asked Count issue in Mysql
Aug
27
asked Need to write MDX for time dimension in Mondrian
Aug
1
comment Does disconnecting the network stop a query?
once a query hits the server it will continue unless you cancelled the query on the server.