1,747 reputation
69
bio website
location Rochester, NY
age 53
visits member for 3 years, 10 months
seen Sep 2 at 1:11

Aug
1
awarded  Enthusiast
Jul
29
answered How can I find the VLF count for a SQL 2005 database without running dbcc loginfo?
Jul
28
answered Find material for improvement in Microsoft BI
Jul
25
answered @table_variable or #temp_table
Jul
25
comment What are the alternatives for an ORDER BY clause in a View?
as dportas said, a stored proc wrapper around the query would work, but probably not what you're looking for.
Jul
23
answered How to export a single huge table from SQL Server?
Jul
22
revised Can I see Historical Queries run on a SQL Server database?
added 2 characters in body
Jul
22
answered Can I see Historical Queries run on a SQL Server database?
Jul
22
comment Auto-Shrink, Encryption & Recovery Model properties in SQL Server 2008 R2
no TDE in Express though, only enterprise : microsoft.com/sqlserver/2008/en/us/editions-compare.aspx
Jul
22
comment Auto-Shrink, Encryption & Recovery Model properties in SQL Server 2008 R2
@RPK If the server melts down, you won't have any mdf or ldf to copy! Regular full backups, and log backups on a schedule that meets your acceptable data loss, like hourly, copied someplace safe are your best insurance.
Jul
21
comment How to migrate from SQL Server 2000 to SQL Server 2008 R2 Express Edition
+1 for remembering the scheduling, as there is no SQL Agent.
Jul
21
revised What are the alternatives for an ORDER BY clause in a View?
deleted 84 characters in body
Jul
21
answered What are the alternatives for an ORDER BY clause in a View?
Jul
16
comment Speed problem with a simple select statement
@Dustin Approximately how many rows in Table1 in total?
Jul
16
revised Speed problem with a simple select statement
deleted 2 characters in body
Jul
14
revised Add DEFAULT to existing column
added 18 characters in body
Jul
14
revised Speed problem with a simple select statement
added 1 characters in body
Jul
14
answered Speed problem with a simple select statement
Jul
14
awarded  Organizer
Jul
14
revised Query Parallelism
edited tags