1,807 reputation
414
bio website spaghettidba.com
location Italy
age 37
visits member for 3 years, 7 months
seen 15 hours ago

SQL Server MVP. Formula 1 DBA.

Blog

Twitter

G+

linkedin

sqlconsulting.it


2d
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
Mar
5
answered SQL Server Replication with 2 systems in different locations
Mar
4
comment What to do with a table with a lot ( 50+ ) indexes? SQL Server 2008
Exactly. Indexes that are heavily written and seldom read are the most likely candidates for deletion.
Mar
4
answered What to do with a table with a lot ( 50+ ) indexes? SQL Server 2008
Mar
2
revised run a script for all databases
deleted 68 characters in body
Mar
2
revised run a script for all databases
added 1107 characters in body
Mar
2
answered run a script for all databases