Connect SQL
Its all about SQL Server . . .
Tuesday, June 17, 2014
Video: SQL Server Backups And Restore (Part1 - Backup)
›
It is hard to imagine not backing up the production databases periodically. This facilitates recovery from accidental data deletion or co...
2 comments:
Saturday, May 31, 2014
Video:SQL Server Performance Tuning with Wait Statistics (PageLatch - PageIOLatch - Latch)
›
3rd video of our Waits and Queues series. Latch waits are common and could be an indication of serious performance issues, but understandi...
Friday, May 2, 2014
Video: SQL Server Performance Tuning with Wait Statistics (CXPACKET)
›
CXPACKET is a common wait type, resulted by parallel query execution. But does occurrence of CXPACKET wait is always a sign of performanc...
Sunday, April 6, 2014
Video: SQL Server Performance Tuning with Wait Statistics (Introduction)
›
To investigate performance bottleneck, Wait Statistics is a power full tool which a DBA like to use on priority. Understanding waits is n...
Sunday, March 2, 2014
Video: SQL Server 2014 - In Memory OLTP (Data Durability)
›
SQL Server 2014 - In Memory OLTP as per its name, keeps all the rows for memory optimized tables inside memory. What would happen, if hard...
›
Home
View web version