Reputation
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
2 23 67
Newest
 Proofreader
Impact
~972k people reached

17h
comment Performance impact in orders of magnitude with Dynamic SQL
Looks like a bad plan. Can you run using WITH OPTION (RECOMPILE) query hint to see if you see the same behavior.
22h
comment SQL Agent AD account gets permission denied for ODBC connections in SSIS packages
check this Account for the SQL Server Agent Service.
23h
comment removing sql logins from one server, after migrating to another server, but all the databases were not migra
check SQL Server Security Auditing to Match Logins And Users and this msdn blog -- especially in the comments by Raul Garcia
1d
awarded  Proofreader
1d
reviewed Edit removing sql logins from one server, after migrating to another server, but all the databases were not migra
1d
revised removing sql logins from one server, after migrating to another server, but all the databases were not migra
spelling check, formatting
1d
comment How to avoid frequently needing to re-grant permission in Hue?
You would require to GRANT SELECT ON TABLE .. TO USER explicitly ONLY if the table is recreated - NOT when you update, add data. You can have a separate job to GRANT permission if you are recreating the table every time you do a data load.
2d
revised Half of a transaction completes, when the other half fails?
added 2 characters in body; edited tags
2d
comment How can we restore shipped transaction log files in SQL Server 2012 to an online (being used) database without stopping the DB?
Please check Stairway to SQL Server Replication
2d
comment How can we restore shipped transaction log files in SQL Server 2012 to an online (being used) database without stopping the DB?
Yes .. You can use Transactional replication to keep the data in sync between 2 databases.
2d
revised SQL Service Broker and AlwaysOn Issue
added 12 characters in body
2d
revised SQL Service Broker and AlwaysOn Issue
added 12 characters in body
2d
comment How can we restore shipped transaction log files in SQL Server 2012 to an online (being used) database without stopping the DB?
restore shipped transaction log files in SQL Server 2012 to an online (being used) database without stopping the DB what you are asking is NOT possible. You should read up on how transaction log works ?
2d
revised How do I cast a varchar to Bigint in DB2
added 8 characters in body; edited tags
2d
comment How to clean DBMIRROR_EVENTS_QUEUE process on broken mirror?
what is the output of select sd.name, sd.log_reuse_wait_desc, sdm.mirroring_state_desc, sdm.mirroring_role_desc from sys.databases sd join sys.database_mirroring sdm on sd.database_id = sdm.database_id where sd.name = 'your database name' ?
2d
comment Query looks optimal but logical reads is huge
@Hauri out of curiosity, what if you keep the same index but use OPTION (MAXDOP 1) (this will disable parallelism for this particular query only) and check the logical reads ?
2d
comment How do I pass multiple statements into sqlcmd?
GO is a batch seperator - NOT a T-SQL command as opposed to ; which will end TSQL statement (statement terminator). Also, ; is a part of ANSI SQL-92 standard.
Apr
22
comment How to avoid Row cannot be located for updating error
Can you run a server side trace and see how it is deleting ?
Apr
22
comment How to avoid Row cannot be located for updating error
How are you deleting the record ? Can you post the sql ?
Apr
22
revised How to avoid Row cannot be located for updating error
added 6 characters in body