fileSQL-Server-Myths-and-Mis-4OZ7

SQL Server Myths and Misconceptions
  • WMV1. Introduction1. Introduction.wmv2.36MB
  • WMV1. Introduction2. Why is Some Infortion Incorrect.wmv3.27MB
  • WMV1. Introduction3. Why Does Incorrect Infortion Cause Problems.wmv2.47MB
  • WMV1. Introduction4. Sumry.wmv2.04MB
  • WMV1. Introduction5. Course Structure.wmv3.18MB
  • WMV10. High-ailability Myths and Misconceptions1. Introduction.wmv1.20MB
  • WMV10. High-ailability Myths and Misconceptions10. Replication is a Valid High-Availability Choice.wmv2.16MB
  • WMV10. High-ailability Myths and Misconceptions2. Database Snapshot Size.wmv3.54MB
  • WMV10. High-ailability Myths and Misconceptions3. Database Snapshot Efficiency.wmv2.83MB
  • WMV10. High-ailability Myths and Misconceptions4. Demo - Database Snapshot Memory Usage.wmv10.38MB
  • WMV10. High-ailability Myths and Misconceptions5. Database Mirroring Failure Detection.wmv3.02MB
  • WMV10. High-ailability Myths and Misconceptions6. Database Mirroring Failover Speed.wmv2.00MB
  • WMV10. High-ailability Myths and Misconceptions7. Failover Clustering is the Best High-Availability Technology.wmv1.71MB
  • WMV10. High-ailability Myths and Misconceptions8. Multiple Database Mirrors.wmv947.38KB
  • WMV10. High-ailability Myths and Misconceptions9. Transactions After a Failover.wmv1.58MB
  • WMV2. Perfornce Myths and Misconceptions1. Introduction.wmv1.41MB
  • WMV2. Perfornce Myths and Misconceptions10. Updating Index Key Columns.wmv2.96MB
  • WMV2. Perfornce Myths and Misconceptions11. Demo - Updating Index Key Columns.wmv5.73MB
  • WMV2. Perfornce Myths and Misconceptions12. Snapshot Isolation.wmv3.90MB
  • WMV2. Perfornce Myths and Misconceptions13. Checkpoints.wmv1.97MB
  • WMV2. Perfornce Myths and Misconceptions14. NULL Bitmap.wmv3.77MB
  • WMV2. Perfornce Myths and Misconceptions15. Tempdb Data Files.wmv4.38MB
  • WMV2. Perfornce Myths and Misconceptions16. Solid State Disk Uses.wmv3.23MB
  • WMV2. Perfornce Myths and Misconceptions17. Disk Queue Length.wmv1.98MB
  • WMV2. Perfornce Myths and Misconceptions18. Page Life Expectancy Threshold.wmv3.47MB
  • WMV2. Perfornce Myths and Misconceptions19. NUMA Effect on Page Life Expectancy.wmv2.05MB
  • WMV2. Perfornce Myths and Misconceptions2. Controlling Instant File Initialization.wmv3.48MB
  • WMV2. Perfornce Myths and Misconceptions20. CXPACKET Waits.wmv3.74MB
  • WMV2. Perfornce Myths and Misconceptions21. ASYNC_NETWORK_IO Waits.wmv2.89MB
  • WMV2. Perfornce Myths and Misconceptions22. Demo - Wait Statistics.wmv7.28MB
  • WMV2. Perfornce Myths and Misconceptions23. Overriding MAXDOP.wmv1.89MB
  • WMV2. Perfornce Myths and Misconceptions3. Demo - Enabling Instant File Initialization.wmv6.99MB
  • WMV2. Perfornce Myths and Misconceptions4. Temporary Table Abuse.wmv3.13MB
  • WMV2. Perfornce Myths and Misconceptions5. Demo - Using Temporary Tables.wmv9.19MB
  • WMV2. Perfornce Myths and Misconceptions6. Tempdb Sizing.wmv2.61MB
  • WMV2. Perfornce Myths and Misconceptions7. Data Compression.wmv3.55MB
  • WMV2. Perfornce Myths and Misconceptions8. Data File Shrinking.wmv3.65MB
  • WMV2. Perfornce Myths and Misconceptions9. Demo - Effect of Data File Shrinking.wmv5.00MB
  • WMV3. Transaction Log Myths and Misconceptions1. Introduction.wmv1.32MB
  • WMV3. Transaction Log Myths and Misconceptions10. Transaction Log Sizing.wmv4.84MB
  • WMV3. Transaction Log Myths and Misconceptions11. Log Record Removal.wmv2.09MB
  • WMV3. Transaction Log Myths and Misconceptions12. Log Record Movement.wmv1.94MB
  • WMV3. Transaction Log Myths and Misconceptions13. Using BULK_LOGGED to Reduce Log Backup Size.wmv3.54MB
  • WMV3. Transaction Log Myths and Misconceptions14. Demo - Log Backup Size Using BULK_LOGGED.wmv5.31MB
  • WMV3. Transaction Log Myths and Misconceptions15. Log Backup Size vs. Log Size.wmv2.63MB
  • WMV3. Transaction Log Myths and Misconceptions16. Disaster Recovery and BULK_LOGGED.wmv2.26MB
  • WMV3. Transaction Log Myths and Misconceptions17. Demo - Disaster Recovery and BULK_LOGGED.wmv17.48MB
  • WMV3. Transaction Log Myths and Misconceptions2. Log Truncation and Clearing.wmv2.46MB
  • WMV3. Transaction Log Myths and Misconceptions3. Transaction Log Analysis.wmv2.60MB
  • WMV3. Transaction Log Myths and Misconceptions4. Demo - Analyzing the Transaction Log.wmv14.86MB
  • WMV3. Transaction Log Myths and Misconceptions5. TRUNCATE TABLE Logging.wmv3.76MB
  • WMV3. Transaction Log Myths and Misconceptions6. Efficient Logging of Index Operations.wmv2.70MB
  • WMV3. Transaction Log Myths and Misconceptions7. Demo - Showing Efficient Logging.wmv6.45MB
  • WMV3. Transaction Log Myths and Misconceptions8. Multiple Log Files.wmv2.42MB
  • WMV3. Transaction Log Myths and Misconceptions9. Instant File Initialization.wmv2.56MB
  • WMV4. Indexing Myths and Misconceptions1. Introduction.wmv1.30MB
  • WMV4. Indexing Myths and Misconceptions2. FILLFACTOR Usage.wmv2.70MB
  • WMV4. Indexing Myths and Misconceptions3. Clustered Index Rebuilds.wmv2.65MB
  • WMV4. Indexing Myths and Misconceptions4. Nonclustered Index Choice.wmv3.10MB
  • WMV4. Indexing Myths and Misconceptions5. SSDs and Fragmentation.wmv3.09MB
  • WMV4. Indexing Myths and Misconceptions6. Removing Heap Fragmentation.wmv2.21MB
  • WMV4. Indexing Myths and Misconceptions7. GUIDs as a Cluster Key Choice.wmv3.01MB
  • WMV4. Indexing Myths and Misconceptions8. Demo - GUID Cluster Keys.wmv8.68MB
  • WMV4. Indexing Myths and Misconceptions9. Rebuilding Indexes and Statistics.wmv1.78MB
  • WMV5. Locking Myths and Misconceptions1. Introduction.wmv991.38KB
  • WMV5. Locking Myths and Misconceptions2. Online Index Operations and Blocking.wmv2.98MB
  • WMV5. Locking Myths and Misconceptions3. Demo - Locks held by Online Index Rebuild.wmv8.06MB
  • WMV5. Locking Myths and Misconceptions4. Backups and Blocking.wmv2.95MB
  • WMV5. Locking Myths and Misconceptions5. DBCC CHECKDB and Blocking.wmv2.61MB
  • WMV5. Locking Myths and Misconceptions6. Lock Escalation.wmv2.74MB
  • WMV5. Locking Myths and Misconceptions7. Demo - Lock Escalation.wmv12.09MB
  • WMV5. Locking Myths and Misconceptions8. Invalid Blocking and Deadlocks.wmv2.48MB
  • WMV5. Locking Myths and Misconceptions9. NOLOCK and READ UNCOMMITTED.wmv2.16MB
  • WMV6. Transact-SQL Myths and Misconceptions1. Introduction.wmv1.03MB
  • WMV6. Transact-SQL Myths and Misconceptions2. Nested Transactions.wmv3.10MB
  • WMV6. Transact-SQL Myths and Misconceptions3. Demo - Nested Transactions.wmv5.67MB
  • WMV6. Transact-SQL Myths and Misconceptions4. DDL Triggers.wmv2.02MB
  • WMV6. Transact-SQL Myths and Misconceptions5. SELECT COUNT(star).wmv3.33MB
  • WMV6. Transact-SQL Myths and Misconceptions6. Demo - SELECT COUNT(star).wmv6.04MB
  • WMV6. Transact-SQL Myths and Misconceptions7. Physical Record Location.wmv2.97MB
  • WMV6. Transact-SQL Myths and Misconceptions8. Demo - Physical Record Location.wmv5.49MB
  • WMV6. Transact-SQL Myths and Misconceptions9. Running DMVs in 80 Compatibility Mode.wmv2.70MB
  • WMV7. Backup Myths and Misconceptions1. Introduction.wmv1.05MB
  • WMV7. Backup Myths and Misconceptions10. Replacing Backups with Database Snapshots.wmv3.41MB
  • WMV7. Backup Myths and Misconceptions2. Concurrent Data and Log Backups.wmv1.92MB
  • WMV7. Backup Myths and Misconceptions3. Data Backups and Log Clearing.wmv1.62MB
  • WMV7. Backup Myths and Misconceptions4. Demo - When Does the Log Clear.wmv11.82MB
  • WMV7. Backup Myths and Misconceptions5. Backup Completion Guarantees.wmv3.17MB
  • WMV7. Backup Myths and Misconceptions6. Differential Backups.wmv1.59MB
  • WMV7. Backup Myths and Misconceptions7. Planning a Backup Strategy.wmv2.22MB
  • WMV7. Backup Myths and Misconceptions8. Restarting the Log Backup Chain.wmv1.66MB
  • WMV7. Backup Myths and Misconceptions9. Demo - Log Backup Chain.wmv6.23MB
  • WMV8. Restore Myths and Misconceptions1. Introduction.wmv1.23MB
  • WMV8. Restore Myths and Misconceptions2. Mix-and-tch Filegroups.wmv2.72MB
  • WMV8. Restore Myths and Misconceptions3. Demo - Filegroup Restores.wmv7.48MB
  • WMV8. Restore Myths and Misconceptions4. Using WITH SAT for Data Backups.wmv1.87MB
  • WMV8. Restore Myths and Misconceptions5. Restoring to Older Versions of SQL Server.wmv3.08MB
  • WMV8. Restore Myths and Misconceptions6. Demo - Down-level Restore.wmv4.89MB
  • WMV8. Restore Myths and Misconceptions7. Restoring to Non-Enterprise Editions.wmv3.19MB
  • WMV8. Restore Myths and Misconceptions8. 32-Bit vs. -Bit Compatibility.wmv2.00MB
  • WMV9. Corruption Myths and Misconceptions1. Introduction.wmv1.33MB
  • WMV9. Corruption Myths and Misconceptions10. Repair Can Fix Everything.wmv2.83MB
  • WMV9. Corruption Myths and Misconceptions11. Repairing System Databases and Tables.wmv2.81MB
  • WMV9. Corruption Myths and Misconceptions12. Transaction Rollbacks.wmv2.55MB
  • WMV9. Corruption Myths and Misconceptions13. Demo - Transaction Rollbacks.wmv4.52MB
  • WMV9. Corruption Myths and Misconceptions2. Detaching and Attaching a SUSPECT Database.wmv2.77MB
  • WMV9. Corruption Myths and Misconceptions3. Offloading Consistency Checks.wmv2.75MB
  • WMV9. Corruption Myths and Misconceptions4. Causing Corruption Using T-SQL.wmv1.65MB
  • WMV9. Corruption Myths and Misconceptions5. Enabling Page Checksums.wmv2.59MB
  • WMV9. Corruption Myths and Misconceptions6. DBCC CHECKDB vs. BACKUP ... WITH CHECKSUM.wmv1.72MB
  • WMV9. Corruption Myths and Misconceptions7. Restarting SQL Server to Fix Corruption.wmv1.78MB
  • WMV9. Corruption Myths and Misconceptions8. Disappearing Corruptions.wmv3.32MB
  • WMV9. Corruption Myths and Misconceptions9. Corruption-Free Guarantee.wmv1.37MB
Latest Search: 1.UMD-325   2.WNZ-292   3.DVH-426   4.HODV-20629   5.FSET-420   6.JUSD-418   7.OPDD-33   8.KRBV-179   9.TBD-016   10.ASW-115   11.JFB-015   12.REAL-412   13.MIBD-584   14.YSN-065   15.KIBD-073   16.ONSD-546   17.RKI-201   18.ONSD-501   19.DV-948   20.ONSD-472   21.ONSD-489   22.CRZ-306   23.JUSD-242   24.SBNS-029   25.BNDV-00572   26.REBD-012   27.MIBD-542   28.ONSD-573   29.SBNS-050   30.ZATD-01   31.MBD-155   32.DV-1410   33.BIB-016   34.AAJB-130   35.BOMN-048   36.JUSD-484   37.DANDY-271   38.JUKD-363   39.IBW-158   40.JKRD-18   41.TBD-028   42.KCPW-014   43.IDBD-416   44.DIV-146   45.KTDS-470   46.NFDM-284   47.KIBD-096   48.SAL-136   49.BS-22   50.PPPD-251   51.KWBD-096   52.XV-1082   53.SMT-008   54.YFE-001   55.JAPD-004   56.SDMS-392   57.LGD-046   58.EXD-036   59.STD-007   60.ARK-002   61.OYVD-104   62.GBVD-041   63.OKAS-066   64.ODV-281   65.SWF-169   66.DJNG-003   67.GST-014   68.ARMD-894   69.MARD-248   70.GESD-007   71.255   72.044   73.006   74.093   75.359   76.369   77.009   78.208   79.450   80.463   81.014   82.020   83.177   84.003   85.143   86.192   87.534   88.480   89.590   90.136   91.682   92.256   93.322   94.053   95.342   96.279   97.921   98.005   99.881   100.084   101.024   102.183   103.245   104.329   105.047   106.017   107.058   108.30   109.001   110.376   111.009   112.217   113.513   114.143   115.56231   116.024   117.018   118.1005   119.1117   120.102   121.006   122.762   123.234   124.004   125.200033   126.248   127.149   128.744   129.058   130.070   131.052   132.026   133.088   134.034   135.8712   136.329   137.622   138.956   139.097   140.237