194 reputation
110
bio website
location
age
visits member for 2 years, 8 months
seen Sep 26 at 21:42

I spend a fair amount of time querying, reviewing, and visualizing data for projects large and small; once in a while, I write about it, too.


Sep
24
awarded  Autobiographer
Jul
29
awarded  Popular Question
Jul
22
awarded  Popular Question
Jul
2
awarded  Curious
Apr
25
comment user rights validation inside stored procedure?
@AaronBertrand - I have updated the question in an attempt to make it clearer.
Apr
25
revised user rights validation inside stored procedure?
Trying to make the question more clear...
Apr
25
asked user rights validation inside stored procedure?
Apr
15
comment sql server 2000: no longer able to expand jobs in sql server agent
@StevePettifer - Queries against msdb.sysjobhistory and msdb.sysjobs run fine in query analyzer.
Apr
15
comment sql server 2000: no longer able to expand jobs in sql server agent
@AaronBertrand - When I connect to the server, I do not experience lag time; when I open a table or open a proc, I do not experience lag time; when I run a basic query, I do not experience lag time; yet whenever I attempt to view the Job Details under SQL Server Agent, the lag time is significant.
Apr
15
comment sql server 2000: no longer able to expand jobs in sql server agent
@AaronBertrand - RDP into the 2000 box indicates the same slowness for SQL SErver Agent jobs display.
Apr
15
comment sql server 2000: no longer able to expand jobs in sql server agent
@AaronBertrand - Connectivity is good. msdb.sysjobhistory shows about 6500 records, with 90% of the records having been created in 2014.
Apr
15
asked sql server 2000: no longer able to expand jobs in sql server agent
Jan
17
asked Scheduled copy of large table from SQL Server 2000 to 2008
Jun
18
accepted Query mail logs for xp_sendmail
Jun
18
comment Query mail logs for xp_sendmail
@AaronBertrand - xp_SendMail.
Jun
18
asked Query mail logs for xp_sendmail
May
20
awarded  Constituent
May
20
awarded  Caucus
May
6
accepted maintaining full text index on large table
Apr
26
revised maintaining full text index on large table
added 429 characters in body; edited tags