Reputation
1,795
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
7 11
Impact
~158k people reached

Aug
9
answered sp_repladdcolumn - is it possible to supply a list of Publications to add this column on?
Aug
8
answered What are the top 3 performance Issues that you encounter with your SQL Servers?
Aug
3
comment Empty strings in VARCHAR(MAX) consuming space which cannot be recovered
what is the value for large_value_types_out_of_row for the table in sys.tables?
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