SQL 2014 is coming! – Tech Ed 2013
SQL 2014 fundamentally reshapes the database world, but Microsoft is being far too modest with their marketing. Officially, Microsoft is saying that Column Store Indexes can now be clustered. Under
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
RSS - Posts