1,013 reputation
412
bio website spaghettidba.com
location Italy
age 37
visits member for 3 years, 3 months
seen 13 hours ago

Long time DB developer and SQL Server enthusiast.

Blog

Twitter

G+

linkedin

sqlconsulting.it


17h
answered Sqlserver: Get Meta-Info about TRN file
1d
comment Sqlserver: Get Meta-Info about TRN file
Are the backup files taken on the same instance where you want to retore them?
Nov
20
comment Notification when the status on sql server replication is “Not Running”
@user3063530 yes, it works on 2005 as well
Nov
19
comment How to get CPU usage by database for particular instance?
I usually rely on Glenn Berry's Diagnostic Information Queries for that. One of the queries is exactly about the CPU usage per database. See his blog for more info: sqlserverperformance.wordpress.com/2014/09/17/…
Nov
19
revised Procedure permission issues with a SQL state query
added 8 characters in body
Nov
19
answered Procedure permission issues with a SQL state query
Nov
17
answered This instance of (MS) SQL Server has been using a process id of X since dd/mm/yyyy
Nov
17
comment SQL Server Standard Edition Memory Limit
I see. Leaving no comment won't make the OP's next question any better though.
Nov
17
comment SQL Server Standard Edition Memory Limit
Why downvoted? Isn't a legitimate question?
Nov
14
revised Restoring master database
added 68 characters in body
Nov
14
answered Restoring master database
Nov
14
comment Dynamic Creation of Table using Stored Procedure Without a Use of OpenRowSet in SQL Server
@RohitJain What about a CLR procedure?
Nov
13
answered Dynamic Creation of Table using Stored Procedure Without a Use of OpenRowSet in SQL Server
Nov
13
answered how to select first 9 numbers from other table from database using sql query?
Nov
12
comment Does view take advantage of table indexes
@Zerotoinfinite "Views are like physical tables" - no, most definitely.
Nov
12
answered Does view take advantage of table indexes
Nov
12
comment Store the resulting list of a SELECT in a variable to count AND use the result
I'm unable to understand your requirements. Please add table scripts, sample data and expected output to your question. See this article for guidance: sqlservercentral.com/articles/Best+Practices/61537
Nov
12
comment DB performance vs replication
I'm afraid you want to use replication for the wrong reasons. Merge replication will likely slow down your database because it introduces triggers on all published tables. Moreover, replication is a data distribution technology, not something you want to use for high availability. It will likely not help you scale out the load either. I strongly suggest that you rethink your strategy.
Nov
12
comment DB performance vs replication
What type of replication are you using? Merge? Perr-to-Peer? Uniqueidentifiers as a primary key should not be a big deal in terms of fragmentation, given that you can guarantee that the GUIDS are sequential. What's the bigint nightmare you're talking about? You mean range allocation, right?
Nov
11
comment how best to add unique index on nvarchar(max) field on existing table
Actually, having unique values in a column potentially 2gb in size is an unreasonable requirement. If it is a take design issue, change the column to varchar (50) and index it properly