Reputation
4,164
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
3 20 38
Impact
~202k people reached

Apr
14
revised How to restore mdf file in sql server 2005?
added 10 characters in body
Apr
14
revised Script to merge-replicate two MDF database files?
added 10 characters in body
Apr
11
revised Transform 14 columns into 2 (SQL Server 2008) - Pivot/Cursor not helping
added 99 characters in body; edited title
Apr
11
revised SQL Server 2005 query with multiple conditions, some indexed, some not
added 38 characters in body; edited title
Apr
10
revised Converting VARBINARY HEX to VARCHAR
added 70 characters in body
Apr
10
revised Database in Suspect mode
deleted 36 characters in body; edited title
Apr
9
revised SQL Server Query Question
added 70 characters in body; edited title
Apr
9
revised Setting a default principal server in SQL Server 2008
added 2 characters in body; edited tags; edited title
Apr
9
revised Inplace upgrade from SQL Server 2008 Standard to SQL Server 2014 evaluation
added 21 characters in body; edited title
Apr
9
revised SQL Server 2012 Express installation failed
added 2 characters in body; edited title
Apr
9
revised Should a SQL Server DBA know Windows Server and vice versa? Are these roles soon to become synonymous. Or at least more encapsulated/?
added 7 characters in body; edited title
Apr
6
revised From keyword not found?
edited tags
Apr
4
revised I cannot restore a SQL Server database in a new location
added 15 characters in body
Apr
4
revised “Incorrect Syntax near S” in Stored Procedure
deleted 275 characters in body
Apr
1
revised Rolling back a SQL Server 2008R2 Database stored in SQL Server Express
edited title
Apr
1
comment Execution Plan : Table Insert Cost 90% vs Clustured Index Insert Cost 86%
For a great many reasons, I would argue any serious table in SQL Server should always have a clustered index - therefore, that discussion is kinda moot..... heaps (tables without CI) have serious drawbacks and performance penalties - too many to even bother - use a CI - always.
Apr
1
revised Database Role Membership: db_executor vs db_datareader and db_datawriter in SQL Server 2008R2?
added 9 characters in body; edited title
Mar
30
revised SQL “Standard” guide?
edited tags
Mar
29
revised SQL Server 2014 Replication - The process could not connect to Subscriber 'xxx'
deleted 6 characters in body; edited title
Mar
27
revised Upgrading a database from SQL Server 2005 to 2012 uncovered a syntax error
added 59 characters in body; edited title