86 reputation
8
bio website geekswithblogs.net/influent1
location
age
visits member for 2 years, 6 months
seen 6 hours ago

SQL Server expert, sort of.


6h
accepted SQL Server 2012: NUMA node shown as offline without special affinity settings
6h
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.
May
2
comment Archiving data from logging db (high writes, no reads)
I'm not sure if I should make a composite nonclustered PK using ApplicationEventID and LogTime or just a clustered PK on LogTime with an index on ApplicationEventID or what. ?
May
2
revised Archiving data from logging db (high writes, no reads)
added more info
May
1
comment Can I speed up the psqlodbc driver?
I can't figure out how to change that particular setting in the ODBC panel.
Apr
30
asked Can I speed up the psqlodbc driver?
Apr
24
revised Archiving data from logging db (high writes, no reads)
removed extra word that didn't belong
Apr
24
comment Archiving data from logging db (high writes, no reads)
Good to know, but it didn't help me, and neither did using a derived table. Adding an index on ApplicationEventID in the ApplicationFault table made a huge difference though, and I think I can get away with that without slowing down inserts too much. I still should work on implementing sliding window partitioning though.
Apr
24
revised How to Move All tables from one Database into Different Database?
fixed typo to help StackExchange searches
Apr
23
suggested suggested edit on How to Move All tables from one Database into Different Database?
Apr
23
comment Archiving data from logging db (high writes, no reads)
Thanks. Do you mean I should use an indexed view? I don't see how a regular view with ORDER BY would help.
Apr
23
comment Archiving data from logging db (high writes, no reads)
That sounds like a great idea, I've never used partitioning but have long wanted to. I don't know when I could find the downtime to switch the PK though.