573 reputation
112
bio website
location New Delhi, India
age 29
visits member for 1 year, 9 months
seen Apr 17 at 12:15

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
comment unable to connect to my pc in sql server 2008 due to error 2
[Explore the link ][1] [1]: dba.stackexchange.com/questions/47253/… Hope you get right one.
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.
Jul
31
asked MySQL Synchronous Replication on Ubuntu 12.04 with DRBD
Jul
30
comment SQL Server Replication: “ALTER TABLE ALTER COLUMN” is not propagated to subscribers
Yes in Pub/Sub replication DDL will only come over with the new snapshot. So whenever you work at DDL you have to pulish to propagate.
Jul
30
answered Cannot connect to my local instance