Reputation
Next tag badge:
530/400 score
62/80 answers
Badges
9 87 159
Newest
 Caucus
Impact
~504k people reached

28m
comment postgres9.4 streaming replication not streaming
Instead of "update 3" consider adding an answer and marking it as such. It is fine (encouraged!) to ask and answer your own question
2h
comment SQL Server 2012 Compress Backups on Azure VM takes time to restore than backup from Normal SQL Server compress backup
This question was a lot clearer before your latest edit. Please consider rolling back to revision 2 (click on the "edited xxx ago" link to access this feature). As currently written, the question is unclear (at least, to me).
4h
comment How to capture PRINT statements from TSQL called by CLR stored procedure
I agree. This is not a duplicate. Reopened.
Jul
23
comment optimizing paging in a stored procedure
@Muflix Percentage costs in execution plans are always optimizer estimates, even in post-execution (actual) plans.
Jul
20
comment How do I merge similar records with different validity dates?
How large is the "large" dataset? Why don't you fix the snapshot import so it doesn't create the problem in the first place?
Jul
20
comment Overcome MERGE JOIN(INDEX SCAN) with explicit single KEY value on a FOREIGN KEY
@OlegI No, there's no way to choose loop/merge per validation, closest would be to use a plan guide, but it could be tough to construct. Yes, the QO makes a cost-based decision for each FK.
Jul
17
comment existing foreign key that references fields with different datatype (char(8) and varchar(8))
This was indeed a breaking change from 6.5 to 7. See sqlmag.com/sql-server/migrating-sql-server-65-70. I have no idea how long compatibility was maintained. Probably as long as 6.5 database compatibility. SQL Server 7 installation media is hard to find because it was withdrawn due to Java licencing issues.
Jul
17
comment Avoid joining to the same table multiple times
It would be much better to edit your answer than add explanation in a comment. Comments are temporary and not searchable.
Jul
16
comment NC Index not being used
The question is lacking precision and detail as already noted, but you should always be careful about data types. If the column is nvarchar, your constant literals should be prefixed with N e.g. >= N'ATT000'. Please do update your question to include at least table & index DDL, preferably some sample data and execution plans.
Jul
12
comment Overcome MERGE JOIN(INDEX SCAN) with explicit single KEY value on a FOREIGN KEY
@JamesLupolt Yes I would oppose that. Effectively forcing row locks makes little sense if merge join is truly optimal (i.e. a large update), and disallowing page locks prevents alter index reorganize, among other things. It can also lead to excessive memory use for locks, and other undesirable side-effects.
Jul
12
comment Execution plan for COMPUTE BY
@usr Just WinDbg.
Jul
10
comment what is ord_part in dict_col_struct for MySQL?
If you would like your post migrated, flag it for moderator attention and say where you would like it to go.
Jul
4
comment Stored procedure using cursors
Homework questions are not automatically off-topic on this site. A good enough question is a good enough question regardless.
Jun
21
comment How to read detached or offline sql server transaction log?
@plywoods All things are possible in principle. You could, in principle, write your own tool to read and process the binary content of the offline log files, but it would require techniques and internal details that Microsoft do not document or support. Your question isn't 100% clear on what you are trying to achieve or why; I gave the best answer I could.
Jun
16
comment The use of NOT logic in relation to indexes
@ypercube Yes..
Jun
12
comment SQL Server varbinary column modifying inserted data
Your binary representation has an odd number of digits. It takes two hex digits to specify a single byte, hence the padding. Are you really trying to store half a byte? That would seem to be an odd (ha!) thing to do. e.g. DECLARE @v varbinary(max) = 0x123; SELECT @v;
Jun
6
comment Postgresql CRUD operation on Single json data row
Please merge your accounts
Jun
5
comment Merge row size overflow in SQL Server
The first comment on that Connect item is mine. There is no repro, just a script. Running the script does not reproduce the problem because there is no sample data. Again: you are unlikely to get an answer here until you provide the details asked for.
Jun
5
comment INSERT INTO with TABLOCK taking longer than without TABLOCK
Is the destination table definitely a heap? Any nonclustered indexes? Are the logical reads repeatable, even when a backup is not concurrently running? Do the log records show bulk operations or per-row inserts (LOP_INSERT_ROWS - LCX_HEAP)?
Jun
4
comment Using different aggregate functions in a pivot
Might there be other years? Or just 2015? Could the tabulation be performed in the client rather than on the server?