Skip to main content
Henry Lee's user avatar
Henry Lee's user avatar
Henry Lee's user avatar
Henry Lee
  • Member for 13 years, 1 month
  • Last seen more than 1 year ago
10 votes

Do you know an easy way to generate one record for each hour of the past 12 hours?

7 votes

Speed problem with a simple select statement

6 votes

Does it make sense to use full recovery if the data and log files are on the same HD?

5 votes
Accepted

How is SQL Server host identity ensured?

5 votes

What throughput should I expect with MPIO?

4 votes
Accepted

Denied access sending dbmail while impersonated under a login with sysadmin privilege

4 votes

Finding stored procedures with missing indexes

4 votes

Check Index Fragementation Query

3 votes

Send Email when sql server agent job fails

3 votes
Accepted

SQL Server 2005 encryption - What Grants should I give

3 votes
Accepted

SQL Server Agent: QUOTED_IDENTIFIER

2 votes
Accepted

Count duplicate versions of databases (SQL Server 2008 R2)

2 votes

SQL Server 2005 Percent Log Used Alert fires too fast?

2 votes
Accepted

How do I configure SQL Profiler to show me queries to the views sys.databases and sys.tables?

1 vote

SQL Server 2008, cpu 100% until recreate an index

1 vote
Accepted

Possible Pitfalls of Setting Up Kerberos to Permit Cross-SQL Database Access Via AD Trusted Connection

1 vote

Need to figure out what FKs point to a specific table

1 vote

sql server-percentage calculation

0 votes

Secure Linked Server - Non privledged user possible? Registry corruption?