728 reputation
311
bio website spaghettidba.com
location Italy
age 36
visits member for 3 years
seen 2 days ago

Long time DB developer and SQL Server enthusiast.

Blog

Twitter

G+

linkedin

sqlconsulting.it


Aug
23
awarded  Yearling
Apr
17
answered SQL Server Permission
Apr
16
comment Copy+Pasting currency value from SSMS 2012 to excel does not complete or calculate new value
Don't copy/paste, export to excel in one click spaghettidba.com/2014/01/16/…
Apr
15
answered How to export all the security-related information from a SQL Server database
Apr
14
comment Why do Indexed Views not permit non-unique clustered indexes?
I see where you're coming from. Multiple leafs can share the same index key, but the clustering key is always included in NCIs. Is it enough to say that they're always unique internally? I don't think so.
Apr
14
comment Why do Indexed Views not permit non-unique clustered indexes?
Sorry, not yet. You're mixing two things together. Nonclustered indexes do not have to be unique and are not uniquified internally: you're not making this point clear enough. Everything you say in your answer applies to clustered indexes only.
Apr
14
comment Why do Indexed Views not permit non-unique clustered indexes?
I strongly suggest revising the phrasing of this answer. While it contains a valid point regarding the original question, it may look like it suggests that all non unique indexes contain uniquifiers, which is not the case.
Apr
4
answered Replication with FileStream
Mar
14
answered Need a faster method to concatenate rows into column(s)--currently using CTEs
Oct
24
comment Grant a login of Sql server authentication the same permission of a Windows group login with Windows authentication?
You shouldn't be granting privileges to users directly IMHO. If you granted privileges to a role and added whoever needs those privileges to the appropriate roles you would solve your problem easily. I faced the same problem in the past and learned my lesson the hard way. It could look like overkill at the beginning, but saves a lot of work in the long run. Login means identity, SQL/Windows means authentication, role means authorization.
Aug
23
awarded  Yearling
Jun
14
comment SQL Server automatic transaction log truncation
Looks like you're answering a different question.
Jun
13
answered How to count number of consecutive events matching status of last event?
Jun
3
accepted Merge subscription behaviour
Jun
3
answered Merge subscription behaviour
May
31
asked Merge subscription behaviour
May
31
awarded  Scholar
May
31
accepted PK as ROWGUIDCOL or use a separate rowguid column?
May
30
comment PK as ROWGUIDCOL or use a separate rowguid column?
While I agree that replication should be transparent to applications, I also believe that databases that have to be published must be thought for replication from the ground up. Identity management in merge replication is totally PITA, for instance: if you know from the start you'll have to merge publish, it's one thing to stay away from.
May
30
comment PK as ROWGUIDCOL or use a separate rowguid column?
Thanks for answering. No, the application isn't doing 1. nor 2. For sake of completeness, some tables are already decorated with the ROWGUIDCOL property in the PK.