Reputation
1,827
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
4 14
Newest
 sql-server
Impact
~47k people reached

Apr
16
comment How can I replace the cursor in the below query?
@mayooran you could fill a TVP with all the rows you are now reading from a cursor and then pass it as a parameter to the sp
Apr
16
comment How can I replace the cursor in the below query?
What about changing the stored procedure to accept a Table Valued Parameter (TVP)?
Apr
16
comment In SQLCMD is there any way of shelling out to run arbitrary programs?
>> you can't manipulate nvarchar(Max) columns in sql << Really? >> This would make it impossible to refactor the data structure (using sql) in the future << Why? Can you expand please?
Apr
16
answered SQL Server : how can I measure database performance increase after index maintenance?
Apr
14
comment Script to merge-replicate two MDF database files?
Usually Merge Replication is the technology used to keep offline databases in synch. Have you tried that? Is express edition used on both computers or just one of them?
Apr
13
comment SQL Server : execute stored procedure from another stored procedure
If it only returns data without modifying it, maybe that stored procedure should be a function.
Mar
26
answered Registered Server window does not show Database Engine or Local Server Groups
Mar
16
comment Which databases can meet these replication requirements?
@dc2 I'm not saying it's the wrong way, I'm just saying it won't be easy.
Mar
15
comment Which databases can meet these replication requirements?
@dc2 Re: point 4: SQL Server Merge Replication can do that. Be aware that complex join filters + many subscribers (200 can be "many", in case you're wondering) might turn into a performance nightmare, especially with precomputed partitions.
Mar
12
comment SQL Server 2012 SSIS : retrieve line number in Flat File Connection Manager
I don't think it can be done directly. However you could import to a staging table with all char-based columns and an additional int column with identity defined. That way you could identity all the values that don't parse and look them up in the file. I'm not completely sure that the rows in the file will be loaded sequentially though. However, I think that the value itself should be enough to identify the offending row.
Mar
12
answered SQL Server Standard edition attach partitioned database
Mar
12
awarded  sql-server
Mar
11
answered Install Full Text search on existing instance
Mar
11
comment Is it a good idea to create an index for each column in a new table?
Looks very similar to the question you already asked some time ago: dba.stackexchange.com/questions/94409/… What can we add to that? Did you also check the duplicate questions?
Mar
9
comment Bulk change Agent Jobs' definition to “Quit the job reporting failure” from “Go to the next step” On Failure
Wrong or right depends on the jobs' logic (as I pointed out), but it's exactly what the OP asked for.
Mar
9
comment Bulk change Agent Jobs' definition to “Quit the job reporting failure” from “Go to the next step” On Failure
What does 'Get SQL Profiler Trace' come from? However, this won't do it for all jobs.
Mar
9
answered Bulk change Agent Jobs' definition to “Quit the job reporting failure” from “Go to the next step” On Failure
Mar
6
comment SQL Server: Recursive dynamic SQL puzzle
What is the expected results for TOP(3)?
Mar
5
revised How to set foreign key in table in one database that references a table in another database
added 21 characters in body
Mar
5
answered How to set foreign key in table in one database that references a table in another database