Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
12
Impact
~6k people reached

Dec
23
comment Data warehousing: data transfer process too slow with larger batches
@RayofCommand do you mean unrelated activities? if so seems unlikely they matter since they're not blocking or doing anything substantial.
Dec
23
comment Data warehousing: data transfer process too slow with larger batches
@AndrewHill both statements show a small percentage going to each index update and 0% to everything else.
Dec
22
asked Data warehousing: data transfer process too slow with larger batches
Dec
17
comment Not able to create SSISDB catalog
@Radhi you should propose copying the bak file as answer since it is one (I also did not have the bak file in my binn folder).
Nov
26
comment Clustering vs. transactional replication vs. availability groups
I feel compelled to mention that if you have a local active-passive FCI and a remote passive server using AlwaysOn you will have 2 passive servers and will have to pay for a full license for one of them. :(
Oct
21
awarded  Popular Question
Oct
2
awarded  Popular Question
Sep
24
awarded  Autobiographer
Sep
16
comment Which parameters was a stored procedure or command executed with?
DBCC INPUTBUFFER doesn't show me what parameters were used and I know there were some. How can there not be a way to do this?
Sep
11
awarded  Popular Question
Jul
25
accepted SQL Server 2012: NUMA node shown as offline without special affinity settings
Jul
25
answered SQL Server 2012: NUMA node shown as offline without special affinity settings
Jul
17
comment SQL Server 2012: NUMA node shown as offline without special affinity settings
@Sean: Enterprise
Jul
17
comment SQL Server 2012: NUMA node shown as offline without special affinity settings
@Jon: this is a 24x7 prod server so I can't test that for a couple weeks.
Jul
16
asked SQL Server 2012: NUMA node shown as offline without special affinity settings
Jul
2
awarded  Curious
May
27
accepted Archiving data from logging db (high writes, no reads)
May
16
comment Archiving data from logging db (high writes, no reads)
I might just partition on ApplicationEventID, ranges covering every 10 million rows. Thanks.
May
13
comment Archiving data from logging db (high writes, no reads)
If I make a composite key don't I then have to have both columns in the tables that reference the PK with a foreign key? I tried the clustered non-unique index on LogTime but then I can't use SWITCH to remove a partition because it says the PK is not partitioned, but I can't make the PK partitioned without including LogTime in it.
May
2
comment Archiving data from logging db (high writes, no reads)
I can't just make a clustered PK on LogTime since there are duplicates.