The solid state revolution
Back in the nineties, I learned, as every young database administrator must, that writing or reading a single block from disk is the heart of every database operation. That’s why
Bit operations in Transact SQL
Books Online has a less than helpful article on bitwise operators. … So what can you do with large binaries in TSQL, other than store them and do the processing in
Performance of Computed Columns in SQL Server
Generals are always preparing to fight the last war. -proverb IT professionals are always learning from our mistakes and trying to improve upon our past performance. And like military leaders,
Working with really large log files in Windows
Working with files that are larger than the available memory can be difficult on a windows system. Notepad, and similar editors, will not open files that will not fit in
Why is Sharepoint busy when no one is using it?
Sharepoint has hundreds of timer jobs running. Queries against the TimerJobHistory table will identify jobs that are active for long periods. You can then go into Central Administration and see
RSS - Posts