Sep
30
awarded Notable Question
Sep
26
awarded Supporter
Sep
16
comment Converting a Unicode value to a non-Unicode value (SQL Server)
Wow, had no idea...jeez, just doesn't seem right...it's not the same character. Why not just an "...oops, no such character found in this code page..." and fail the conversion?
Sep
16
asked Converting a Unicode value to a non-Unicode value (SQL Server)
Aug
20
awarded Popular Question
Aug
19
awarded Famous Question
Aug
15
awarded Scholar
Aug
15
accepted Why is SQL Server's online indexing causing blocking?
Aug
15
comment Why is SQL Server's online indexing causing blocking?
That makes sense. I dropped the nonclustered indexes prior to attempting to drop the clustered index (so they wouldn't get rebuilt twice) - which forced all queries to scan the entire table. So regarding system resources, this caused disk speeds to come to a crawl (as not all the data fits in memory). This then had a cascading effect as the actual rebuild then crept along as well.
Aug
15
awarded Curious
Aug
14
comment Why is SQL Server's online indexing causing blocking?
The clustered index enforces the PK. We've identified that if we change the order of the columns of the clustered index it would be much more efficient for the queries that hit this table. Downtime is hard to come by, which is why I was excited by online indexing.
Aug
14
comment Why is SQL Server's online indexing causing blocking?
Though, upon further thought, not all queries were blocked. If my scenario was not supported, that would seem to suggest it would become an offline operation and block all queries. Perhaps it's more nuanaced...
Aug
14
revised Why is SQL Server's online indexing causing blocking?
added 191 characters in body
Aug
14
comment Why is SQL Server's online indexing causing blocking?
No silly questions...Yes, I'm sure I had WITH (ONLINE=ON). I believe it's being honored because there's a definite time difference between OFF and ON, but is there a particular way to know whether it's being honored?
Aug
14
asked Why is SQL Server's online indexing causing blocking?
May
18
awarded Yearling
Feb
15
awarded Scholar
Feb
15
comment Do 414(h) rollovers need to be included on form 1040 Line 16?
Thanks. Funny...I received the 1099-R today.
Feb
15
accepted Do 414(h) rollovers need to be included on form 1040 Line 16?
Feb
14
asked Do 414(h) rollovers need to be included on form 1040 Line 16?
1 2 3 4 5