31,870 reputation
24598
bio website rusanu.com/articles
location Seattle, WA
age 42
visits member for 4 years
seen 6 hours ago

1d
revised Multiple databases or one large database?
added 38 characters in body
1d
answered Multiple databases or one large database?
Jan
29
comment Table size is not changed after new column is added
@AaronBertrand: rebuild will all 'materialize' the missing value in the page. Adding an index on the column does not change how is 'stored' in clustered, but of course the new index 'materializes' all rows.
Jan
27
answered What are the implications of upgrading statistics SQL Server
Jan
27
awarded  Yearling
Jan
25
comment Is inserting multiple queries takes same time as that of single query?
Yes, 543 is not exactly a lots of rows...
Jan
25
answered Is inserting multiple queries takes same time as that of single query?
Jan
25
answered SQL Server tuning: Disk queue to OS drive: How to optimize?
Jan
24
awarded  Enlightened
Jan
24
awarded  Nice Answer
Jan
23
comment Why can a non-clustered index not be dropped using online=on option
As for second question: you are describing deferred drop.
Jan
23
comment Why can a non-clustered index not be dropped using online=on option
The easiest way is to analyze the log‌​.
Jan
23
comment Why can a non-clustered index not be dropped using online=on option
@ypercube: you should had put that as an answer, I've only read your comment after posting mine
Jan
23
answered Why can a non-clustered index not be dropped using online=on option
Jan
20
awarded  Enlightened
Jan
20
awarded  Nice Answer
Jan
20
answered How AlwaysOn Availability Group secondary replica catches up with primary after secondary server long downtime
Jan
19
awarded  Nice Answer
Jan
19
comment SQL Server Service Broker Compatability across versions?
Is Service Broker in SQL Server 2008/2012/2014 compatible with the one in SQL Server 2005?. the answer is that they are compatible, actually they cannot be told apart.
Jan
9
comment Rebuilding of Index in LogShipping DB in SQL Server 2008 R2 Standard version
I don't hear any proof that fragmentation has anything to do with the problems you observe. Measure. rusanu.com/2014/02/24/how-to-analyse-sql-server-performance