Reputation
6,817
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
15 36
Newest
 Explainer
Impact
~306k people reached

Jun
25
comment How to recover a database?
Please provide the error message you're getting.
Jun
24
reviewed Approve oracle-12c tag wiki
Jun
24
reviewed Approve oracle-12c tag wiki excerpt
Jun
23
comment Use 'default value' in table when NULL
While I accepted @ypercube's as the answer, this is query has the lowest logical reads.
Jun
23
accepted Use 'default value' in table when NULL
Jun
23
asked Use 'default value' in table when NULL
Jun
11
revised Query trans log or tempdb?
added 228 characters in body
Jun
11
awarded  Explainer
Jun
11
reviewed Approve SQL column name search
Jun
11
comment What is the different between compression on the PK vs. on the Table?
Exactly, but to be clear, you can't have a heap and a clustered index on the same table. It's one or the other. Because of how SQL Server behaves, it's common that people confuse primary keys with clustered indexes, so I want to make sure the difference is understood for this answer.
Jun
11
revised SQL column name search
added 45 characters in body
Jun
11
answered SQL column name search
Jun
11
comment What is the different between compression on the PK vs. on the Table?
It would not. Don't think about primary key here, it's irrelevant. We need to focus on indexes here, clustered and non-clustered. You can't separately compress a clustered index and a table because they're the same object. clustered indexes/tables and non-clustered indexes are different objects and have to be compressed individually.
Jun
9
awarded  Nice Answer
Jun
9
awarded  sql-server
Jun
8
answered What is the different between compression on the PK vs. on the Table?
Jun
8
comment TSQL Copy an existing database
When you say you want to make a copy, do you want to copy the schema or the schema and the data? These are two different techniques.
Jun
8
answered Find constraint disabled in SQL Server
May
15
awarded  Enlightened
May
15
awarded  Nice Answer