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

SQL Server expert, sort of.


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