186 reputation
10
bio website geekswithblogs.net/influent1
location
age
visits member for 2 years, 9 months
seen Sep 22 at 16:58

SQL Server expert, sort of.


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.
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