1 2<html xmlns="http://www.w3.org/1999/xhtml" > 3<head id="Head1"> 4<link rel="SHORTCUT ICON" type="image/x-icon" href="http://www.lifeasbob.com/favicon.ico" /> 5<title> 6 Bob Knowledge 7</title></head> 8<body> 9 <form method="post" action="./kb_articles.aspx?article_Id=65&CatId=41" id="form1"> 10<div class="aspNetHidden"> 11<input type="hidden" name="__EVENTTARGET" id="__EVENTTARGET" value="" /> 12<input type="hidden" name="__EVENTARGUMENT" id="__EVENTARGUMENT" value="" /> 13<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUKMTkwOTU0OTg2NQ9kFgJmD2QWAgIDD2QWCAIBDw8WAh4EVGV4dAUNU2Vzc2lvbnM6IDQzNGRkAgMPDxYCHwAFGFR1ZXNkYXksIE9jdG9iZXIgNiwgMjAyNmRkAgUPZBYKAicPDxYCHwAFJEZhbWlseV9QaWN0dXJlX1NlcHRlbWJlcl8yMDA3XzQxLkpQR2RkAikPDxYCHgtOYXZpZ2F0ZVVybAVcfi9DYW1lcmEvRGVmYXVsdC5hc3B4P21lZGlhX3Nlcmllc2lkPTQwJm1lZGlhX25hbWU9MTAyMX5GYW1pbHlfUGljdHVyZV9TZXB0ZW1iZXJfMjAwN180MS5KUEdkFgJmDw8WAh4ISW1hZ2VVcmwFRH4vQ2FtZXJhL1VwbG9hZHMvU2VyaWVzfjQwLzEwMjF+RmFtaWx5X1BpY3R1cmVfU2VwdGVtYmVyXzIwMDdfNDEuSlBHZGQCLQ8PFgYfAQWkAWh0dHA6Ly93d3cuTGlmZUFzQm9iLmNvbS9MaW5rcy9MYXVuY2hMaW5rLmFzcHg/TGlua0lkPTM0NiZsaW5rdXJsPWh0dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9pc2FwaS9yZWRpci5kbGw/cHJkPVdpbmRvd3Mmc2JwPU1lZGlhUGxheWVyJmFyPUZhdm9yaXRlJnNiYT1DTkVUJnB2ZXI9Ni4yHwAFF0NORVQgVG9kYXkgLSBUZWNobm9sLi4uHgZUYXJnZXQFBF9uZXdkZAIvDw8WBB8ABb8BSSB0aHJvdyBhIGxpdHRsZSBkcnkgbWFsdCwgd2hpY2ggaXMgbGVmdCBvZiBwdXJwb3NlLCBvbiB0b3Agb2YgdGhlIG1hc2gsIHdpdGggYSBoYW5kZnVsIG9mIHNhbHQsIHRvIGtlZXAgdGhlIHdpdGNoZXMgZnJvbSBpdCwgYW5kIHRoZW4gY292ZXIgaXQgdXAuIC0gSW5zdHJ1Y3Rpb25zIGZvciBicmV3aW5nIFNjb3RjaCBBbGUsIDE3OTMeB1Zpc2libGVnZGQCMQ8PFgIfAAUENjAyNGRkAgcPZBYCAgEPZBYWAgEPDxYCHwRoZGQCCQ8PFgIfBGhkZAINDw8WAh8ABbEZPGJyIC8+PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL0Nsb3NlZGJvb2suZ2lmIiAvPjxhIGhyZWY9ImtiX2FydGljbGVzLmFzcHg/Q2F0SWQ9NDAiPkNsdXN0ZXI8L2E+PGJyIC8+PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL0Nsb3NlZGJvb2suZ2lmIiAvPjxhIGhyZWY9ImtiX2FydGljbGVzLmFzcHg/Q2F0SWQ9MzUiPkRPUzwvYT48YnIgLz48aW1nIHNyYz0iLi4vSW1hZ2VzL1RyZWUvQ2xvc2VkYm9vay5naWYiIC8+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD0zMyI+SUJNIC0gQVM0MDA8L2E+PGJyIC8+PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL0Nsb3NlZGJvb2suZ2lmIiAvPjxhIGhyZWY9ImtiX2FydGljbGVzLmFzcHg/Q2F0SWQ9MTciPk1PTTwvYT48YnIgLz48aW1nIHNyYz0iLi4vSW1hZ2VzL1RyZWUvQ2xvc2VkYm9vay5naWYiIC8+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD0xMCI+UGVyZm9ybWFuY2UgQ291bnRlcnM8L2E+PGJyIC8+PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL0Nsb3NlZGJvb2suZ2lmIiAvPjxhIGhyZWY9ImtiX2FydGljbGVzLmFzcHg/Q2F0SWQ9MzkiPlNlcnZpY2UgQnJva2VyPC9hPjxiciAvPjxpbWcgc3JjPSIuLi9JbWFnZXMvVHJlZS9PcGVuQm9vay5naWYiIC8+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD0xIj5TUUwgU2VydmVyPC9hPjxiciAvPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOzxpbWcgc3JjPSIuLi9JbWFnZXMvVHJlZS9DbG9zZWRib29rLmdpZiIgLz48YSBocmVmPSJrYl9hcnRpY2xlcy5hc3B4P0NhdElkPTIiPlRlbXBvcmFyeSBEYXRhYmFzZTwvYT48YnIgLz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDs8aW1nIHNyYz0iLi4vSW1hZ2VzL1RyZWUvQ2xvc2VkYm9vay5naWYiIC8+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD0zIj5WaWV3czwvYT48YnIgLz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDs8aW1nIHNyYz0iLi4vSW1hZ2VzL1RyZWUvQ2xvc2VkYm9vay5naWYiIC8+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD01Ij5CYWNrdXA8L2E+PGJyIC8+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL0Nsb3NlZGJvb2suZ2lmIiAvPjxhIGhyZWY9ImtiX2FydGljbGVzLmFzcHg/Q2F0SWQ9NiI+U1FMIE1haWw8L2E+PGJyIC8+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL0Nsb3NlZGJvb2suZ2lmIiAvPjxhIGhyZWY9ImtiX2FydGljbGVzLmFzcHg/Q2F0SWQ9NyI+RFRTIC0gRGF0YSBUcmFuc2Zvcm1hdGlvbiBTZXJ2aWNlczwvYT48YnIgLz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDs8aW1nIHNyYz0iLi4vSW1hZ2VzL1RyZWUvQ2xvc2VkYm9vay5naWYiIC8+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD04Ij5NZW1vcnk8L2E+PGJyIC8+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL0Nsb3NlZGJvb2suZ2lmIiAvPjxhIGhyZWY9ImtiX2FydGljbGVzLmFzcHg/Q2F0SWQ9OSI+U2VjdXJpdHk8L2E+PGJyIC8+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL0Nsb3NlZGJvb2suZ2lmIiAvPjxhIGhyZWY9ImtiX2FydGljbGVzLmFzcHg/Q2F0SWQ9MTEiPkV4Y2VsPC9hPjxiciAvPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOzxpbWcgc3JjPSIuLi9JbWFnZXMvVHJlZS9DbG9zZWRib29rLmdpZiIgLz48YSBocmVmPSJrYl9hcnRpY2xlcy5hc3B4P0NhdElkPTEyIj5Kb2JzIFNRTCBBZ2VudDwvYT48YnIgLz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDs8aW1nIHNyYz0iLi4vSW1hZ2VzL1RyZWUvQ2xvc2VkYm9vay5naWYiIC8+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD0xMyI+TVNERTwvYT48YnIgLz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDs8aW1nIHNyYz0iLi4vSW1hZ2VzL1RyZWUvQ2xvc2VkYm9vay5naWYiIC8+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD0xNCI+SW5zdGFsbDwvYT48YnIgLz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDs8aW1nIHNyYz0iLi4vSW1hZ2VzL1RyZWUvQ2xvc2VkYm9vay5naWYiIC8+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD0xNSI+REJDQzwvYT48YnIgLz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDs8aW1nIHNyYz0iLi4vSW1hZ2VzL1RyZWUvQ2xvc2VkYm9vay5naWYiIC8+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD0xNiI+VXNlciBNYW5hZ2VtZW50PC9hPjxiciAvPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOzxpbWcgc3JjPSIuLi9JbWFnZXMvVHJlZS9DbG9zZWRib29rLmdpZiIgLz48YSBocmVmPSJrYl9hcnRpY2xlcy5hc3B4P0NhdElkPTM0Ij5TeXN0ZW0gRGF0YWJhc2VzPC9hPj
13xiciAvPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOzxpbWcgc3JjPSIuLi9JbWFnZXMvVHJlZS9DbG9zZWRib29rLmdpZiIgLz48YSBocmVmPSJrYl9hcnRpY2xlcy5hc3B4P0NhdElkPTM3Ij5CQ1Y8L2E+PGJyIC8+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL0Nsb3NlZGJvb2suZ2lmIiAvPjxhIGhyZWY9ImtiX2FydGljbGVzLmFzcHg/Q2F0SWQ9MzgiPkRlYWRsb2NrczwvYT48YnIgLz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDs8aW1nIHNyYz0iLi4vSW1hZ2VzL1RyZWUvT3BlbkJvb2suZ2lmIiAvPjxzcGFuIHN0eWxlPSJiYWNrZ3JvdW5kLWNvbG9yOiAjRkZGRjY2Ij48YSBocmVmPSJrYl9hcnRpY2xlcy5hc3B4P0NhdElkPTQxIj5UZW1wIFRhYmxlczwvYT48L3NwYW4+PGJyIC8+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL1RvcGljLmdpZiIgLz48c3BhbiBzdHlsZT0iYmFja2dyb3VuZC1jb2xvcjogI0ZGRkY2NiI+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD00MSZBcnRpY2xlX2lkPTY1Ij5XaGVuIHRvIFVzZSBUZW1wIFRhYi4uLjwvYT48L3NwYW4+PGJyIC8+PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL0Nsb3NlZGJvb2suZ2lmIiAvPjxhIGhyZWY9ImtiX2FydGljbGVzLmFzcHg/Q2F0SWQ9MzYiPldpbmRvd3MgT1M8L2E+ZGQCDw8PFgIfBGhkZAIVDw8WAh8ABS9XaWxsIGJlIGFkZGVkIGFzIGEgc3ViLWNhdGVnb3J5IG9mLCBUZW1wIFRhYmxlc2RkAhkPDxYCHwAFJVdoZW4gdG8gVXNlIFRlbXAgVGFibGVzIGluIFNRTCBTZXJ2ZXJkZAIbDxAPFgIeC18hRGF0YUJvdW5kZ2QQFRoGQmFja3VwA0JDVgdDbHVzdGVyBERCQ0MJRGVhZGxvY2tzG0Rpc3RyaWJ1dGVkIFBhcnRpb25lZCBWaWV3cwNET1MiRFRTIC0gRGF0YSBUcmFuc2Zvcm1hdGlvbiBTZXJ2aWNlcwVFeGNlbAtJQk0gLSBBUzQwMAdJbnN0YWxsDkpvYnMgU1FMIEFnZW50Bk1lbW9yeQNNT00ETVNERRRQZXJmb3JtYW5jZSBDb3VudGVycwhTZWN1cml0eQ5TZXJ2aWNlIEJyb2tlcghTUUwgTWFpbApTUUwgU2VydmVyEFN5c3RlbSBEYXRhYmFzZXMLVGVtcCBUYWJsZXMSVGVtcG9yYXJ5IERhdGFiYXNlD1VzZXIgTWFuYWdlbWVudAVWaWV3cwpXaW5kb3dzIE9TFRoBNQIzNwI0MAIxNQIzOAE0AjM1ATcCMTECMzMCMTQCMTIBOAIxNwIxMwIxMAE5AjM5ATYBMQIzNAI0MQEyAjE2ATMCMzYUKwMaZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2cWAWZkAh8PDxYCHwAF1xs8UD5Zb3VyIHF1ZXN0aW9uIHNob3dzIHlvdSBoYXZlIHN1Y2N1bWJlZCB0byBzb21lIG9mIHRoZSBjb21tb24gbWlzY29uY2VwdGlvbnMgc3Vycm91bmRpbmcgdGFibGUgdmFyaWFibGVzIGFuZCB0ZW1wb3JhcnkgdGFibGVzLjwvUD4NCjxQPkkgaGF2ZSB3cml0dGVuIDxBIGhyZWY9Imh0dHA6Ly9kYmEuc3RhY2tleGNoYW5nZS5jb20vcXVlc3Rpb25zLzE2Mzg1L3doYXRzLXRoZS1kaWZmZXJlbmNlLWJldHdlZW4tYS10ZW1wLXRhYmxlLWFuZC10YWJsZS12YXJpYWJsZS1pbi1zcWwtc2VydmVyLzE2Mzg2IzE2Mzg2Ij5xdWl0ZSBhbiBleHRlbnNpdmUgYW5zd2VyIG9uIHRoZSBEQkEgc2l0ZTwvQT4gbG9va2luZyBhdCB0aGUgZGlmZmVyZW5jZXMgYmV0d2VlbiB0aGUgdHdvIG9iamVjdCB0eXBlcy4gVGhpcyBhbHNvIGFkZHJlc3NlcyB5b3VyIHF1ZXN0aW9uIGFib3V0IGRpc2MgdnMgbWVtb3J5IChJIGRpZG4ndCBzZWUgYW55IHNpZ25pZmljYW50IGRpZmZlcmVuY2UgaW4gYmVoYXZpb3VyIGJldHdlZW4gdGhlIHR3bykuPC9QPg0KPFA+UmVnYXJkaW5nIHRoZSBxdWVzdGlvbiBpbiB0aGUgdGl0bGUgdGhvdWdoIGFzIHRvIHdoZW4gdG8gdXNlIGEgdGFibGUgdmFyaWFibGUgdnMgYSBsb2NhbCB0ZW1wb3JhcnkgdGFibGUgeW91IGRvbid0IGFsd2F5cyBoYXZlIGEgY2hvaWNlLiBJbiBmdW5jdGlvbnMgZm9yIGV4YW1wbGUgaXQgaXMgb25seSBwb3NzaWJsZSB0byB1c2UgYSB0YWJsZSB2YXJpYWJsZSBhbmQgaWYgeW91IG5lZWQgdG8gcmVmZXJlbmNlIHRoZSBvYmplY3QgaW4gYSBjaGlsZCBzY29wZSB0aGVuIG9ubHkgYSA8Q09ERT4jdGVtcDwvQ09ERT4gdGFibGUgd2lsbCBkby4gV2hlcmUgeW91IGRvIGhhdmUgYSBjaG9pY2Ugc29tZSBzdWdnZXN0aW9ucyBhcmUgYmVsb3cuPC9QPg0KPE9MPg0KPExJPklmIHlvdSBuZWVkIGFuIGluZGV4IHRoYXQgY2Fubm90IGJlIGNyZWF0ZWQgaW1wbGljaXRseSB0aHJvdWdoIGEgPENPREU+VU5JUVVFPC9DT0RFPiBvciA8Q09ERT5QUklNQVJZIEtFWTwvQ09ERT4gY29uc3RyYWludCB0aGVuIHlvdSBuZWVkIGEgPENPREU+I3RlbXBvcmFyeTwvQ09ERT4gdGFibGUgYXMgaXQgaXMgbm90IHBvc3NpYmxlIHRvIGNyZWF0ZSB0aGVzZSBvbiB0YWJsZSB2YXJpYWJsZXMuIChFeGFtcGxlcyBvZiBzdWNoIGluZGV4ZXMgYXJlIG5vbiB1bmlxdWUgb25lcywgZmlsdGVyZWQgaW5kZXhlcyBvciBpbmRleGVzIHdpdGggPENPREU+SU5DTFVERTwvQ09ERT5kIGNvbHVtbnMpLjwvTEk+DQo8TEk+SWYgeW91IHdpbGwgYmUgcmVwZWF0ZWRseSBhZGRpbmcgYW5kIGRlbGV0aW5nIGxhcmdlIG51bWJlcnMgb2Ygcm93cyBmcm9tIHRoZSB0YWJsZSB0aGVuIHVzZSBhIDxDT0RFPiN0ZW1wb3Jhcnk8L0NPREU+IHRhYmxlLiBUaGF0IHN1cHBvcnRzIDxDT0RFPlRSVU5DQVRFPC9DT0RFPiB3aGljaCBpcyBtb3JlIGVmZmljaWVudCB0aGFuIDxDT0RFPkRFTEVURTwvQ09ERT4gYW5kIGFkZGl0aW9uYWxseSBzdWJzZXF1ZW50IGluc2VydHMgZm9sbG93aW5nIGEgPENPREU+VFJVTkNBVEU8L0NPREU+IGNhbiBoYXZlIGJldHRlciBwZXJmb3JtYW5jZSB0aGFuIHRob3NlIGZvbGxvd2luZyBhIDxDT0RFPkRFTEVURTwvQ09ERT4gPEEgaHJlZj0iaHR0cDovL2RiYS5zdGFja2V4Y2hhbmdlLmNvbS9xdWVzdGlvbnMvMjczMDkvd2h5LWRvZXMtZGVsZXRlLWxlYXZlLWEtbGluZ2VyaW5nLWVmZmVjdC1vbi1wZXJmb3JtYW5jZS8yNzMxOSMyNzMxOSI+YXMgaWxsdXN0cmF0ZWQgaGVyZTwvQT4uPC9MST4NCjxMST5JZiB0aGUgb3B0aW1hbCBwbGFuIHVzaW5nIHRoZSB0YWJsZSB3aWxsIHZhcnkgZGVwZW5kZW50IG9uIGRhdGEgdGhlbiB1c2UgYSA8Q09ERT4jdGVtcG9yYXJ5PC9DT0RFPiB0YWJsZS4gVGhhdCBzdXBwb3J0cyBjcmVhdGlvbiBvZiBzdGF0aXN0aWNzIHdoaWNoIGFsbG93cyB0aGUgcGxhbiB0byBiZSBkeW5hbWljYWxseSByZWNvbXBpbGVkIGFjY29yZGluZyB0byB0aGUgZGF0YS48L0xJPg0KPExJPklmIHRoZSBvcHRpbWFsIHBsYW4gZm9yIHRoZSBxdWVyeSB1c2luZyB0aGUgdGFibGUgaXMgdW5saWtlbHkgdG8gZXZlciBjaGFuZ2UgdGhlbiB5b3UgbWF5IGNvbnNpZGVyIGEgdGFibGUgdmFyaWFibGUgdG8gc2tpcCB0aGUgb3ZlcmhlYWQgb2Ygc3RhdGlzdGljcyBjcmVhdGlvbiBhbmQgcmVjb21waWxlcyAoYW5kIHBvc3NpYmx5IHVzZSBvZiBoaW50cyB0byBmaXggdGhlIHBsYW4geW91IHdhbnQpLjwvTEk+DQo8TEk+SWYgdGhlIHNvdXJjZSBmb3IgdGhlIGRhdGEgaW5zZXJ0ZWQgdG8gdGhlIHRhYmxlIGlzIGZyb20gYSBwb3RlbnRpYWxseSBleHBlbnNpdmUgPENPREU+U0VMRUNUPC9DT0RFPiBzdGF0ZW1lbnQgdGhlbiBjb25zaWRlciB0aGF0IHVzaW5nIGEgdGFibGUgdmFyaWFibGUgd2lsbCBibG9jayB0aGUgcG9zc2liaWxpdHkgb2YgdGhpcyB1c2luZyBhIHBhcmFsbGVsIHBsYW4uPC9MST4NCjxMST5JZiB5b3UgbmVlZCB0aGUgZGF0YSBpbiB0aGUgdGFibGUgdG8gc3Vydml2ZSBhIHJvbGxiYWNrIG9mIGFuIG91dGVyIHVzZXIgdHJhbnNhY3Rpb24gdGhlbiB1c2UgYSB0YWJsZSB2Y
13XJpYWJsZS4gQSBwb3NzaWJsZSB1c2UgY2FzZSBmb3IgdGhpcyBtaWdodCBiZSBsb2dnaW5nIHByb2dyZXNzIG9mIGRpZmZlcmVudCBzdGVwcyBpbiBhIGxvbmcgU1FMIGJhdGNoLjwvTEk+DQo8TEk+V2hlbiB1c2luZyBhIDxDT0RFPiN0ZW1wPC9DT0RFPiB0YWJsZSB3aXRoaW4gYSB1c2VyIHRyYW5zYWN0aW9uIGxvY2tzIGFyZSBoZWxkIGxvbmdlciB0aGFuIGZvciB0YWJsZSB2YXJpYWJsZXMgYW5kIGFsc28gaXQgY2FuIHByZXZlbnQgdHJ1bmNhdGlvbiBvZiB0aGUgPENPREU+dGVtcGRiPC9DT0RFPiB0cmFuc2FjdGlvbiBsb2cgdW50aWwgdGhlIHVzZXIgdHJhbnNhY3Rpb24gZW5kcy4gU28gdGhpcyBtaWdodCBmYXZvdXIgdGhlIHVzZSBvZiB0YWJsZSB2YXJpYWJsZXMuPC9MST4NCjxMST5XaXRoaW4gc3RvcmVkIHJvdXRpbmVzIGJvdGggdGFibGUgdmFyaWFibGVzIGFuZCB0ZW1wb3JhcnkgdGFibGVzIGNhbiBiZSBjYWNoZWQuIFRoZSBtZXRhZGF0YSBtYWludGVuYW5jZSBmb3IgY2FjaGVkIHRhYmxlIHZhcmlhYmxlcyBpcyBsZXNzIHRoYW4gdGhhdCBmb3IgPENPREU+I3RlbXBvcmFyeTwvQ09ERT4gdGFibGVzLiBCb2IgV2FyZCBwb2ludHMgb3V0IGluIGhpcyA8QSBocmVmPSJodHRwOi8vd3d3LnlvdXR1YmUuY29tL3dhdGNoP3Y9U3ZzZUdNb2JlMnciIHJlbD1ub2ZvbGxvdz48Q09ERT50ZW1wZGI8L0NPREU+IHByZXNlbnRhdGlvbjwvQT4gdGhhdCB0aGlzIGNhbiBjYXVzZSBhZGRpdGlvbmFsIGNvbnRlbnRpb24gb24gc3lzdGVtIHRhYmxlcyB1bmRlciBjb25kaXRpb25zIG9mIGhpZ2ggY29uY3VycmVuY3kuIEFkZGl0aW9uYWxseSB3aGVuIGRlYWxpbmcgd2l0aCBzbWFsbCBxdWFudGl0aWVzIG9mIGRhdGEgdGhpcyBjYW4gbWFrZSA8QSBocmVmPSJodHRwOi8vZGJhLnN0YWNrZXhjaGFuZ2UuY29tL2EvMTM0MTIvMzY5MCI+YSBtZWFzdXJhYmxlIGRpZmZlcmVuY2UgdG8gcGVyZm9ybWFuY2U8L0E+LjwvTEk+PC9PTD5kZAIhDzwrAAQBARQrAAQUKwACZA8WBARkBGQEZARkFgQUKwACFgoeBVRpdGxlBQlQYXJhZ3JhcGgeCENsaWVudElEBQlQYXJhZ3JhcGgeCWlzQnVpbHRJbmceEUNvbW1hbmRJZGVudGlmaWVyBQtmb3JtYXRCbG9jax4JY2xhc3NOYW1lBQ1QYXJhZ3JhcGhNZW51ZBQrAAIWDB8GBQRGb250HwcFBEZvbnQfCGcfCQUIZm9udG5hbWUeDWJ1aWx0SW5TY3JpcHRlHwoFDUZvbnRGYWNlc01lbnVkFCsAAhYMHwYFBFNpemUfBwUEU2l6ZR8IZx8JBQhmb250c2l6ZR8LZR8KBQ1Gb250U2l6ZXNNZW51ZBQrAAIWDB8GBQVDb2xvch8HBQVDb2xvch8IZx8JBQlmb3JlY29sb3IfC2UfCgUSRm9udEZvcmVDb2xvcnNNZW51ZBQrAAJkDxYIBGIEYgRiBGIEcwRiBGIEYhYIFhAfBgUEQm9sZB8HBQRCb2xkHgtCdXR0b25JbWFnZQUEYm9sZB8IZx4TQnVpbHRJbkJ1dHRvbk9mZnNldGYfCQUEYm9sZB8LZR8KBQRCb2xkFhAfBgUGSXRhbGljHwcFBkl0YWxpYx8MBQZpdGFsaWMfCGcfDQITHwkFBml0YWxpYx8LZR8KBQZJdGFsaWMWEB8GBQlVbmRlcmxpbmUfBwUJVW5kZXJsaW5lHwwFCXVuZGVybGluZR8IZx8NAiUfCQUJdW5kZXJsaW5lHwtlHwoFCVVuZGVybGluZRYQHwYFDVN0cmlrZVRocm91Z2gfBwUNU3RyaWtlVGhyb3VnaB8MBQ1zdHJpa2V0aHJvdWdoHwhnHw0CIh8JBQ1zdHJpa2V0aHJvdWdoHwtlHwoFDVN0cmlrZVRocm91Z2hkFhAfBgULU3VwZXJTY3JpcHQfBwULU3VwZXJTY3JpcHQfDAULc3VwZXJzY3JpcHQfCGcfDQIkHwkFC3N1cGVyc2NyaXB0HwtlHwoFC1N1cGVyU2NyaXB0FhAfBgUJU3ViU2NyaXB0HwcFCVN1YlNjcmlwdB8MBQlzdWJzY3JpcHQfCGcfDQIjHwkFCXN1YnNjcmlwdB8LZR8KBQlTdWJTY3JpcHQWEB8GBRVSZW1vdmUgQWxsIEZvcm1hdHRpbmcfBwUTUmVtb3ZlQWxsRm9ybWF0dGluZx8MBQxyZW1vdmVmb3JtYXQfCGcfDQIfHwkFDHJlbW92ZWZvcm1hdB8LZR8KBQxSZW1vdmVGb3JtYXQUKwACZA8WDgRiBGIEYgRiBHMEYgRiBGIEYgRzBGIEYgRiBGIWDhYQHwYFDEp1c3RpZnkgTGVmdB8HBQtKdXN0aWZ5TGVmdB8MBQtqdXN0aWZ5bGVmdB8IZx8NAhYfCQULanVzdGlmeWxlZnQfC2UfCgULSnVzdGlmeUxlZnQWEB8GBQ1KdXN0aWZ5IFJpZ2h0HwcFDEp1c3RpZnlSaWdodB8MBQxqdXN0aWZ5cmlnaHQfCGcfDQIXHwkFDGp1c3RpZnlyaWdodB8LZR8KBQxKdXN0aWZ5UmlnaHQWEB8GBQ5KdXN0aWZ5IENlbnRlch8HBQ1KdXN0aWZ5Q2VudGVyHwwFDWp1c3RpZnljZW50ZXIfCGcfDQIUHwkFDWp1c3RpZnljZW50ZXIfC2UfCgUNSnVzdGlmeUNlbnRlchYQHwYFDEp1c3RpZnkgRnVsbB8HBQtKdXN0aWZ5RnVsbB8MBQtqdXN0aWZ5ZnVsbB8IZx8NAhUfCQULanVzdGlmeWZ1bGwfC2UfCgULSnVzdGlmeUZ1bGxkFhAfBgUNQnVsbGV0ZWQgTGlzdB8HBQxCdWxsZXRlZExpc3QfDAUMYnVsbGV0ZWRsaXN0HwhnHw0CAR8JBRNpbnNlcnR1bm9yZGVyZWRsaXN0HwtlHwoFDEJ1bGxldGVkTGlzdBYQHwYFDU51bWJlcmVkIExpc3QfBwUMTnVtYmVyZWRMaXN0HwwFDG51bWJlcmVkbGlzdB8IZx8NAhofCQURaW5zZXJ0b3JkZXJlZGxpc3QfC2UfCgUMTnVtYmVyZWRMaXN0FhAfBgUGSW5kZW50HwcFBkluZGVudB8MBQZpbmRlbnQfCGcfDQIKHwkFBmluZGVudB8LZR8KBQZJbmRlbnQWEB8GBQdPdXRkZW50HwcFB091dGRlbnQfDAUHb3V0ZGVudB8IZx8NAhsfCQUHb3V0ZGVudB8LZR8KBQdPdXRkZW50ZBYQHwYFC0NyZWF0ZSBMaW5rHwcFCkNyZWF0ZUxpbmsfDAUKY3JlYXRlbGluax8IZx8NAgMfCQUKY3JlYXRlbGluax8LBRZ0aGlzLmZ0Yi5DcmVhdGVMaW5rKCk7HwoFCkNyZWF0ZUxpbmsWEh8IZx8GBQZVbmxpbmsfDAUGdW5saW5rHwtlHwkFBnVubGluax8HBQZVbmxpbmsfCgUGVW5saW5rHhRidWlsdEluRW5hYmxlZFNjcmlwdAWLAXZhciBlbCA9IHRoaXMuZnRiLkdldFBhcmVudEVsZW1lbnQoKTsgaWYgKGVsLnRhZ05hbWUgJiYgZWwudGFnTmFtZS50b0xvd2VyQ2FzZSgpICE9ICdhJykgdGhpcy5kaXNhYmxlZCA9IHRydWU7IGVsc2UgdGhpcy5kaXNhYmxlZCA9IGZhbHNlOyAfDQInFhAfBgUMSW5zZXJ0IEltYWdlHwcFC0luc2VydEltYWdlHwwFC2luc2VydGltYWdlHwhnHwkFC2luc2VydGltYWdlHw0CDB8LBRd0aGlzLmZ0Yi5JbnNlcnRJbWFnZSgpOx8KBQtJbnNlcnRJbWFnZRYQHwYFC0luc2VydCBSdWxlHwcFCkluc2VydFJ1bGUfDAUKaW5zZXJ0cnVsZR8IZx8NAg4fCQUUaW5zZXJ0aG9yaXpvbn
13RhbHJ1bGUfC2UfCgUKSW5zZXJ0UnVsZRQrAAJkDxYHBGIEYgRiBHMEYgRiBGIWBxYQHwYFA0N1dB8HBQNDdXQfDAUDY3V0HwhnHwkFA2N1dB8NAgQfCwUPdGhpcy5mdGIuQ3V0KCk7HwoFA0N1dBYQHwYFBENvcHkfBwUEQ29weR8MBQRjb3B5HwhnHwkFBGNvcHkfDQICHwsFEHRoaXMuZnRiLkNvcHkoKTsfCgUEQ29weRYQHwYFBVBhc3RlHwcFBVBhc3RlHwwFBXBhc3RlHwhnHwkFBXBhc3RlHw0CHB8LBRF0aGlzLmZ0Yi5QYXN0ZSgpOx8KBQVQYXN0ZWQWEh8IZx8GBQRVbmRvHwwFBHVuZG8fCwUQdGhpcy5mdGIuVW5kbygpOx8JBQR1bmRvHwcFBFVuZG8fCgUEVW5kbx8OBSJ0aGlzLmRpc2FibGVkPSF0aGlzLmZ0Yi5DYW5VbmRvKCk7Hw0CJhYSHwhnHwYFBFJlZG8fDAUEcmVkbx8LBRB0aGlzLmZ0Yi5SZWRvKCk7HwkFBHJlZG8fBwUEUmVkbx8KBQRSZWRvHw4FInRoaXMuZGlzYWJsZWQ9IXRoaXMuZnRiLkNhblJlZG8oKTsfDQIeFhAfBgUFUHJpbnQfBwUFUHJpbnQfDAUFcHJpbnQfCGcfDQIdHwkFBXByaW50HwsFEXRoaXMuZnRiLlByaW50KCk7HwoFBVByaW50ZAInDw8WAh8EaGRkAikPDxYCHwRoZGRknbgrcYVxFs/56korngOWIyONFyxziE4Yrjzw+8jdvC8=" /> 14</div> 15
16<script type="text/javascript"> 17//<![CDATA[ 18var theForm = document.forms['form1']; 19if (!theForm) { 20 theForm = document.form1; 21} 22function __doPostBack(eventTarget, eventArgument) { 23 if (!theForm.onsubmit || (theForm.onsubmit() != false)) { 24 theForm.__EVENTTARGET.value = eventTarget; 25 theForm.__EVENTARGUMENT.value = eventArgument; 26 theForm.submit(); 27 } 28} 29//]]> 30</script>
30 31 32 33<div class="aspNetHidden"> 34 35 <input type="hidden" name="__VIEWSTATEGENERATOR" id="__VIEWSTATEGENERATOR" value="B7FFFDA2" /> 36</div> 37 <div> 38 <table border="0" cellpadding="6" width="95%"> 39 <tr> 40 <td style="text-align:left"><span id="lblSessions" style="color: #6699FF; font-style: italic; font-family: Verdana; font-size: x-small">Sessions: 434</span></td> 41 <td colspan="2" align="right" style="height: 3px"> 42 <span style="font-family: Stencil"><span style="color: #660066"><span style="font-size: 7pt; 43 font-family: Verdana"> 44 The postings on this site are my own and do not represent my Employer's positions, advice or strategies.</span> </span></span> 45 </td> 46 </tr> 47 <tr> 48 <td style="white-space: nowrap" align="left" width="33%"> 49 <p align="left"><i> <font color="#3399ff" size="6" face="Verdana"> 50 <b>LifeAsBob</b> 51 </font></i> 52 </p> 53 </td> 54 <td width="33%" align="right"> 55 <input type="text" id="q" name="q" size="15" onkeypress="return submitenter(this,event)" /> 56 <input type="button" name="sa" value="Search LifeAsBob" onclick="SearchSite();" /> 57 </td> 58 <td width="33%" align="left"><font face="Verdana" size="2"><b> 59 <span id="lblTimeStamp">Tuesday, October 6, 2026</span> 60 </b></font> 61 <br/> 62 </td> 63 </tr> 64 </table> 65 <table align="left" border="5" cellspacing="0" width="95%" cellpadding="4"> 66 <tr> 67 <td id="menuColumn" width="33%" valign="top" align="left"> 68 <table id="Table4" width="100%" bgcolor="#3399ff" border="0"> 69 <tr> 70 <td bgcolor="#ffff00"> 71 <p align="left"><font face="Verdana" size="2"><b><font color="#ffff00"> 72 <img id="Image1" src="../images/blank.gif" style="border-width:0px;height:5px;width:5px;" /> 73 </font></b>lifeasbob.com</font></p> 74 </td> 75 </tr> 76 <tr> 77 <td valign="top" bgcolor="#3399ff"> 78 <p align="left"><font face="Verdana" size="1"><br/> 79 <!-- 80 <a href="http://edit.yahoo.com/config/send_webmesg?.target=BusTravelerKC&.src=pg"> 81 <img src="http://opi.yahoo.com/online?u=BusTravelerKC&m=g&t=2" border="0" alt="" /></a><br/> 82 <br/> 83 --> 84 <img id="Image2" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" /> 85 </font><font size="2"> 86 <a id="lnkMain" href="../Default.aspx">Home</a> 87 <br/> 88 <img id="Image3" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" /> 89 <a id="lnkBlog" href="../BobsBlog/MainBlog.aspx">Blog</a> 90 <br/> 91 <img id="Image4" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" /> 92 <a id="lnkCode" href="Default.aspx">bob tech</a> 93 <br /> 94 <img id="Image5" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" /> 95 <a id="lnkCalendar" href="../Events/Calendar.aspx">Calendar</a> 96 <br/> 97 <img id="Image6" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" /> 98 <a id="lnkContact" href="../Contact.aspx">
98Contact Bob</a> 99 <br/> 100 <img id="Image7" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" /> 101 <a id="lnkPictures" href="../Camera/Default.aspx">Pictures</a> 102 <br/> 103 <img id="Image8" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" /> 104 <a id="lnkBuses" href="../VWBuses/Default.aspx">VW Buses</a> 105 <br/> 106 <img id="Image9" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" /> 107 <a id="lnkHomeBrew" href="../HomeBrew/Default.aspx">HomeBrew</a> 108 <br/> 109 <img id="Image10" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" /> 110 <a id="lnkRecipe" href="../Recipe/Default.aspx">Cook Book</a> 111 </font> 112 </p> 113 <p align="left"> </p> 114 </td> 115 </tr> 116 </table> 117 <table align="left" border="1" width="100%"> 118 <tr> 119 <td align="left"> 120 <p> 121 <span id="lblMasterPic">Family_Picture_September_2007_41.JPG</span><br /> 122 <a id="lnkPic" href="../Camera/Default.aspx?media_seriesid=40&media_name=1021~Family_Picture_September_2007_41.JPG"><img id="imgMasterPic" src="../Camera/Uploads/Series~40/1021~Family_Picture_September_2007_41.JPG" align="absmiddle" style="height:120px;" /></a> 123 </p> 124 </td> 125 </tr> 126 <tr> 127 <td valign="top" bgcolor="#ffff00"> 128 <img id="Image11" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" /> 129 130 <a title="bob Links" href="/Links/default.asp">bob Links </a> 131 </td> 132 </tr> 133 <tr> 134 <td valign="top" bgcolor="#ffff00" height="20"> 135 <a id="lnkRandom" href="http://www.LifeAsBob.com/Links/LaunchLink.aspx?LinkId=346&linkurl=http://www.microsoft.com/isapi/redir.dll?prd=Windows&sbp=MediaPlayer&ar=Favorite&sba=CNET&pver=6.2" target="_new">CNET Today - Technol...</a> 136 </td> 137 </tr> 138 <tr> 139 <td valign="top" bgcolor="3399ff" > 140 <span id="txtBeerQuote">I throw a little dry malt, which is left of purpose, on top of the mash, with a handful of salt, to keep the witches from it, and then cover it up. - Instructions for brewing Scotch Ale, 1793</span> 141 </td> 142 </tr> 143 <tr> 144 <td style="vertical-align:middle; background-color:#3399FF; text-align:right"> 145 Bob Code 146 <span id="lblBobCode">6024</span> 147 </td> 148 </tr> 149 <tr> 150 <td> 151 <!-- 152
152<script type="text/javascript" src="http://feedjit.com/serve/?bc=ffffff&tc=494949&brd1=336699&lnk=494949&hc=336699&ww=160"></script>
152<noscript><a href="http://feedjit.com/">Feedjit Live Website Statistics</a></noscript> 153 --> 154 <img id="Image12" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" /> 155 <a id="lnkThings" href="../BobThings/BobViewThings.aspx">Things</a> 156 </td> 157 </tr> 158 </table> 159 </td> 160 161 <td id="contentColumn" width="67%" align="left" valign="top"> 162 163 <table> 164 <tr> 165 <td colspan="2"> 166 167 </td> 168 </tr> 169 <tr> 170 <td colspan="2"> 171 <table> 172 <tr> 173 <td align="left"> 174 <a id="MainContent_lnkPrint" href="javascript:__doPostBack('ctl00$MainContent$lnkPrint','')">Wider View</a> 175 </td> 176 <td align="center"> 177 <input name="ctl00$MainContent$txtSearchPhrase" type="text" id="MainContent_txtSearchPhrase" /> 178 <input type="submit" name="ctl00$MainContent$cmdFilter" value="Search" id="MainContent_cmdFilter" /> 179 </td> 180 <td align="right"> 181 182 <input type="hidden" name="ctl00$MainContent$hiddenInsertOn" id="MainContent_hiddenInsertOn" value="false" /> 183 </td> 184 <td style="text-align:right"> 185 <a href="../UserMgmt/login.aspx?ReturnLink=../Code/KB_Articles.aspx">Login</a> 186 </td> 187 </tr> 188 </table> 189 </td> 190 </tr> 191 </table> 192 <table align="left" border="1"> 193 <tr> 194 <td valign="top" align="left"> 195 <font style="font-family: Verdana; font-size:small" face="Verdana"> 196 <span id="MainContent_lblMyTree"><br /><img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=40">Cluster</a><br /><img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=35">DOS</a><br /><img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=33">IBM - AS400</a><br /><img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=17">MOM</a><br /><img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=10">Performance Counters</a><br /><img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=39">Service Broker</a><br /><img src="../Images/Tree/OpenBook.gif" /><a href="kb_articles.aspx?CatId=1">SQL Server</a><br /> <img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=2">Temporary Database</a><br /> <img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=3">Views</a><br /> <img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=5">Backup</a><br /> <img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=6">SQL Mail</a><br /> <img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=7">DTS - Data Transformation Services</a><br /> <img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=8">Memory</a><br /> <img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=9">Security</a><br /> <img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=11">Excel</a><br /> <img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=12">Jobs SQL Agent</a><br /> <img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=13">MSDE</a><br /> <img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=14">Install</a><br /> <img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=15">DBCC</a><br /> <img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=16">User Management</a><br /> <img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=34">System Databases</a><br /> <img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=37">BCV</a><br /> <img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=38">Deadlocks</a><br /> <img src="../Images/Tree/OpenBook.gif" /><span style="background-color: #FFFF66"><a href="kb_articles.aspx?CatId=41">Temp Tables</a></span><br /> <img src="../Images/Tree/Topic.gif" /><span style="background-color: #FFFF66"><a href="kb_articles.aspx?CatId=41&Article_id=65">When to Use Temp Tab...</a></span><br /><img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=36">Windows OS</a></span> 197 </font> 198 <br /> 199 <hr /> 200 201 <br /> 202 <input name="ctl00$MainContent$txtNewCategory" type="text" id="MainContent_txtNewCategory" /> 203 <br /> 204 <font size="1" color="#999999" style="font-family: Verdana" face="Verdana"> 205 <input type="hidden" name="ctl00$MainContent$selectedCategory" id="MainContent_selectedCategory" value="41" />
206 <span id="MainContent_lblcategoryDesc">Will be added as a sub-category of, Temp Tables</span> 207 </font> 208 </td> 209 <td valign="top" align="left"> 210 <table border="2"> 211 <tr> 212 <td bgcolor="#3399FF" style="height: 21px"> 213 <input type="hidden" name="ctl00$MainContent$hiddenArticleId" id="MainContent_hiddenArticleId" value="65" /> 214 <span id="MainContent_lblSubject">When to Use Temp Tables in SQL Server</span> 215 216 217 </td> 218 </tr> 219 <tr> 220 <td style="border-color:#3399FF; height: 21px"> 221 <span id="MainContent_lblResults"><P>Your question shows you have succumbed to some of the common misconceptions surrounding table variables and temporary tables.</P> 222<P>I have written <A href="http://dba.stackexchange.com/questions/16385/whats-the-difference-between-a-temp-table-and-table-variable-in-sql-server/16386#16386">quite an extensive answer on the DBA site</A> looking at the differences between the two object types. This also addresses your question about disc vs memory (I didn't see any significant difference in behaviour between the two).</P> 223<P>Regarding the question in the title though as to when to use a table variable vs a local temporary table you don't always have a choice. In functions for example it is only possible to use a table variable and if you need to reference the object in a child scope then only a <CODE>#temp</CODE> table will do. Where you do have a choice some suggestions are below.</P> 224<OL> 225<LI>If you need an index that cannot be created implicitly through a <CODE>UNIQUE</CODE> or <CODE>PRIMARY KEY</CODE> constraint then you need a <CODE>#temporary</CODE> table as it is not possible to create these on table variables. (Examples of such indexes are non unique ones, filtered indexes or indexes with <CODE>INCLUDE</CODE>d columns).</LI> 226<LI>If you will be repeatedly adding and deleting large numbers of rows from the table then use a <CODE>#temporary</CODE> table. That supports <CODE>TRUNCATE</CODE> which is more efficient than <CODE>DELETE</CODE> and additionally subsequent inserts following a <CODE>TRUNCATE</CODE> can have better performance than those following a <CODE>DELETE</CODE> <A href="http://dba.stackexchange.com/questions/27309/why-does-delete-leave-a-lingering-effect-on-performance/27319#27319">as illustrated here</A>.</LI> 227<LI>If the optimal plan using the table will vary dependent on data then use a <CODE>#temporary</CODE> table. That supports creation of statistics which allows the plan to be dynamically recompiled according to the data.</LI> 228<LI>If the optimal plan for the query using the table is unlikely to ever change then you may consider a table variable to skip the overhead of statistics creation and recompiles (and possibly use of hints to fix the plan you want).</LI> 229<LI>If the source for the data inserted to the table is from a potentially expensive <CODE>SELECT</CODE> statement then consider that using a table variable will block the possibility of this using a parallel plan.</LI> 230<LI>If you need the data in the table to survive a rollback of an outer user transaction then use a table variable. A possible use case for this might be logging progress of different steps in a long SQL batch.</LI> 231<LI>When using a <CODE>#temp</CODE> table within a user transaction locks are held longer than for table variables and also it can prevent truncation of the <CODE>tempdb</CODE> transaction log until the user transaction ends. So this might favour the use of table variables.</LI> 232<LI>Within stored routines both table variables and temporary tables can be cached. The metadata maintenance for cached table variables is less than that for <CODE>#temporary</CODE> tables. Bob Ward points out in his <A href="http://www.youtube.com/watch?v=SvseGMobe2w" rel=nofollow><CODE>tempdb</CODE> presentation</A> that this can cause additional contention on system tables under conditions of high concurrency. Additionally when dealing with small quantities of data this can make <A href="http://dba.stackexchange.com/a/13412/3690">a measurable difference to performance</A>.</LI></OL></span> 233 234 </td> 235 </tr> 236 <tr> 237 <td align="right"> 238 239 240 241 242 </td> 243 </tr> 244 245 </table> 246 </td> 247 </tr> 248 </table> 249 250 </td> 251 252 </tr> 253 <tr> 254 <td colspan="2"> 255 256 257 258 </td> 259 </tr> 260 </table> 261 262 </div> 263
263<script type="text/javascript"> 264 // Function retrieved from: http://cass- hacks.com/articles/code/js_url_encode_decode/ 265 function URLEncode(clearString) { 266 var output = ''; 267 var x = 0; 268 clearString = clearString.toString(); 269 var regex = /(^[a-zA-Z0-9_.]*)/; 270 while (x < clearString.length) { 271 var match = regex.exec(clearString.substr(x)); 272 if (match != null && match.length > 1 && match[1] != '') { 273 output += match[1]; 274 x += match[1].length; 275 } else { 276 if (clearString[x] == ' ') 277 output += '+'; 278 else { 279 var charCode = clearString.charCodeAt(x); 280 var hexVal = charCode.toString(16); 281 output += '%' + (hexVal.length < 2 ? '0' : '') + hexVal.toUpperCase(); 282 } 283 x++; 284 } 285 } 286 return output; 287 } 288 // Retrieved from: http://www.htmlcodetutorial.com/forms/index_famsupp_157.html 289 function SubmitOnEnter(myfield, e) { 290 var keycode; 291 if (window.event) 292 keycode = window.event.keyCode; 293 else if (e) 294 keycode = e.which; 295 else 296 return true; 297 if (keycode == 13) { 298 SearchSite(); 299 return false; 300 } 301 else 302 return true; 303 } 304 function SearchSite() { 305 document.location.href = 'https://www.lifeasbob.com/SearchResults.aspx?cx=002008443492709312896%3Abxirmyphx8e&cof=FORID%3A11&ie=UTF-8&q=' + 306URLEncode(document.getElementById('q').value) + '&sa=Search'; 307 } 308 </script>
308 309<!-- Global site tag (gtag.js) - Google Analytics -->
vendor: 82 bytes, lines 309-310
309 310<script type="text/javascript" src="https://www.googletagmanager.com/gtag/js?id=
310G-FRJQ88TDFW
vendor: 19 bytes, line 310
310" async></script>
311<script type="text/javascript"> 312
vendor: 147 bytes, lines 312-316
312window.dataLayer = window.dataLayer || []; 313 function gtag() { dataLayer.push(arguments); } 314 gtag('js', new Date()); 315 316 gtag('config', '
316G-FRJQ88TDFW
vendor: 5 bytes, line 316
316');
317</script>
317 318 319 </form> 320</body> 321</html>
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.