1,895 reputation
1621
bio website 127.0.0.1
location Frankfurt Am Main, Germany
age 26
visits member for 2 years, 7 months
seen 2 days ago

-


2d
accepted Did a SQL Server instance ever participate in replication?
Sep
24
asked Did a SQL Server instance ever participate in replication?
Sep
22
comment What is the minimum required compatibility level to use parallel SELECT INTO?
@Kin yes, that article is giving the wrong numbers I referred to. Maybe for the CTP they were accurate.
Sep
21
comment Version lie shim for SQL Server 2014
Redgate SQL Compare plainly crashed on SQL14 instances 6 month after the SQL Server release. They don't take this seriously.
Sep
21
revised What is the minimum required compatibility level to use parallel SELECT INTO?
added 199 characters in body
Sep
21
asked What is the minimum required compatibility level to use parallel SELECT INTO?
Sep
21
answered What is the minimum required compatibility level to use parallel SELECT INTO?
Sep
17
comment Adding Indexes To a Partitioned table in SQL Server 2012
I don't see a reference to a partition scheme in your DDL. Are you sure the table is partitioned? Also, the actual execution plan would be the best way to tell what's going on.
Sep
9
comment How do I tactfully bring up database shortcomings?
Explain, why these issues result in increased cost (or risk which is cost plus a probability). Nobody cares about issues that do not result in more cost or less revenue (rightfully so).
Sep
4
answered “When a connection is closed and returned to the pool, the isolation level from the last SET TRANSACTION ISOLATION LEVEL statement is retained”?
Sep
3
accepted How to guard against backup corruption due to spurious bit errors?
Aug
31
comment How to guard against backup corruption due to spurious bit errors?
It happens very rarely, but: Some disks have one flipped bit every 10TB written. I think this is a very realistic case. google.com/…
Aug
31
asked How to guard against backup corruption due to spurious bit errors?
Aug
27
comment Why does my query end up with two seeks instead of one and how do I fix that?
This is a likely fix. But why did SQL Server add the two seeks? Shouldn't a single backwards scan be enough to find both not-null as well as null values?
Aug
27
comment Why does my query end up with two seeks instead of one and how do I fix that?
I have never seen the transformation that you are describing. Can you upload a plan?
Aug
26
comment 500GB Data Warehouse - how to split it into FileGroups?
Multiple filegroups per drive are not pointless. By splitting out tables and indexes out to filegroups you can control fragmentation. Consider having one filegroup per meaningfully big index. That way sequentially inserted indexes never fragment.
Aug
23
accepted Using the sysadmin role with EXECUTE AS
Aug
22
comment Using the sysadmin role with EXECUTE AS
This is a viable solution for me given the fact that it seems to be risky to implement security right. I'll probably use this. Thanks! That said, I'll accept the answer that best answers the security part of this question.
Aug
22
comment Using the sysadmin role with EXECUTE AS
Your article describes a way to have the procedure in a fresh database. That would work. Is it still "dangerous" doing that? It seems that getting the configuration right with a separate database is not that involved.
Aug
22
comment Using the sysadmin role with EXECUTE AS
I require the trace flag to be set in the current session on a specific connection. I don't want to enable it globally.