When possible,which is not always due to financial constraints) use:
C:\ OS
E:\ SQL Binaries
R:\ TempDB (1 file per processor, equi-sized)
S:\ Data
T:\ Log
and
C:\ RAID-1
E:\ RAID-5
R:\ RAID-1 or RAID-10
S:\ RAID-5
T:\ RAID-1 or RAID-10
Working with tempdb in SQL Server 2005
http://technet.microsoft.com/en-us/library/cc966545.aspx
Storage Top 10 Best Practices
http://technet.microsoft.com/en-us/library/cc966534.aspx
Disk Partition Alignment Best Practices for SQL Server
http://msdn.microsoft.com/en-us/library/dd758814(v=sql.100).aspx
Monday, May 23, 2011
Wednesday, November 10, 2010
Can't Drag and drop
Can´t drag and drop in Windows XP
Possible solutions:
1. Rigth click start menu > proprieties > customize > advanced start menu options > enable dragging and dropping
2. Run Ccleaner cleaner and registry
3. Start > run > dcomcnfg > component services > computers > my computer > right click proprieties > com security > edit default > should have system and interactive groups (add it if any is missing) > reboot
4. Install latest InteliMouse drivers > reboot http://www.microsoft.com/hardware/download/download.aspx?category=mk
My options were: mouse – basic optical mouse – windows xp 32 bits - English
5. Start > run > SFC /scannow > reboot
6. Start > run > notepad > copy paste the following > save as: dragdropfix.bat > run it > reboot:
regsvr32 urlmon.dll
regsvr32 Shdocvw.dll
regsvr32 Msjava.dll
regsvr32 Actxprxy.dll
regsvr32 Oleaut32.dll
regsvr32 Mshtml.dll
regsvr32 Browseui.dll
regsvr32 Shell32.dll
7. Start > run > notepad > copy paste the following > save as: dragdropfix.reg > run it > reboot:
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\Interface\{0000010e-0000-0000-C000-000000000046}]@="IDataObject"
[HKEY_CLASSES_ROOT\Interface\{0000010e-0000-0000-C000-000000000046}\NumMethods]@="12"
[HKEY_CLASSES_ROOT\Interface\{0000010e-0000-0000-C000-000000000046}\ProxyStubClsid32]@="{00000320-0000-0000-C000-000000000046}"
[HKEY_CLASSES_ROOT\CLSID\{00000320-0000-0000-C000-000000000046}]@="oleprx32_PSFactoryBuffer"
[HKEY_CLASSES_ROOT\CLSID\{00000320-0000-0000-C000-000000000046}\InprocServer32]@="C:\\WINDOWS\\system32\\ole32.dll""ThreadingModel"="Both"
Possible solutions:
1. Rigth click start menu > proprieties > customize > advanced start menu options > enable dragging and dropping
2. Run Ccleaner cleaner and registry
3. Start > run > dcomcnfg > component services > computers > my computer > right click proprieties > com security > edit default > should have system and interactive groups (add it if any is missing) > reboot
4. Install latest InteliMouse drivers > reboot http://www.microsoft.com/hardware/download/download.aspx?category=mk
My options were: mouse – basic optical mouse – windows xp 32 bits - English
5. Start > run > SFC /scannow > reboot
6. Start > run > notepad > copy paste the following > save as: dragdropfix.bat > run it > reboot:
regsvr32 urlmon.dll
regsvr32 Shdocvw.dll
regsvr32 Msjava.dll
regsvr32 Actxprxy.dll
regsvr32 Oleaut32.dll
regsvr32 Mshtml.dll
regsvr32 Browseui.dll
regsvr32 Shell32.dll
7. Start > run > notepad > copy paste the following > save as: dragdropfix.reg > run it > reboot:
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\Interface\{0000010e-0000-0000-C000-000000000046}]@="IDataObject"
[HKEY_CLASSES_ROOT\Interface\{0000010e-0000-0000-C000-000000000046}\NumMethods]@="12"
[HKEY_CLASSES_ROOT\Interface\{0000010e-0000-0000-C000-000000000046}\ProxyStubClsid32]@="{00000320-0000-0000-C000-000000000046}"
[HKEY_CLASSES_ROOT\CLSID\{00000320-0000-0000-C000-000000000046}]@="oleprx32_PSFactoryBuffer"
[HKEY_CLASSES_ROOT\CLSID\{00000320-0000-0000-C000-000000000046}\InprocServer32]@="C:\\WINDOWS\\system32\\ole32.dll""ThreadingModel"="Both"
Thursday, October 14, 2010
Make search companion as default windows default search engine with windows desktop search intalled
Make search companion as default windows default search engine with windows desktop search intalled
(hit Start > Run then type 'regedit'). Go to the following node:
HKEY_CURRENT_USER\Software\Microsoft\Windows Desktop Search\DS
Then double-click on 'ShowStartSearchBand' and set the value to '0'.
Full explanation:
Much though I love the newly released Microsoft Office 2007, one thing bugged the hell out of me. To get search to work in Outlook (and search is handy if you want to find specific emails from 6 months ago with work you were supposed to have done by now) you need to install Windows Desktop Search 3. This is all well and good until you decide you want to search for files on your hard drive.
Yep, it's replaced the standard Windows search companion (and the friendly dog). That's all well and good, except it's an indexed search so doesn't necessarily reflect what's really on disk. And since by default my program files folder isn't indexed, it never shows any results no matter what I search for – until I go in and change the settings then wait for it to get around to indexing the folders.
There's a link at the bottom of the tab to use the trusty old search companion, but it means clicking it every time. Oh, and before you ask, no, there isn't an option to disable this irritating integration in WDS! I hate it when software comes along and arrogantly replaces existing functionality with itself and gives no way to remove it. I only put the thing on so Outlook would be able to search emails, not to make me click more buttons to search for files!
Of course, you can in fact turn it off, as a little digging has turned up. Simply open RegEdit (hit Start > Run then type 'regedit'). Go to the following node:
HKEY_CURRENT_USER\Software\Microsoft\Windows Desktop Search\DS
Then double-click on 'ShowStartSearchBand' and set the value to '0'. Close that and you're done, the next time you click 'Search' in explorer, the old, reliable search companion will appear. This applies to operating systems before Windows Vista, since Vista has far better search that actually works! (Okay, now someone will say it just uses WDS and I'm an idiot – wouldn't be the first time).
(hit Start > Run then type 'regedit'). Go to the following node:
HKEY_CURRENT_USER\Software\Microsoft\Windows Desktop Search\DS
Then double-click on 'ShowStartSearchBand' and set the value to '0'.
Full explanation:
Much though I love the newly released Microsoft Office 2007, one thing bugged the hell out of me. To get search to work in Outlook (and search is handy if you want to find specific emails from 6 months ago with work you were supposed to have done by now) you need to install Windows Desktop Search 3. This is all well and good until you decide you want to search for files on your hard drive.
Yep, it's replaced the standard Windows search companion (and the friendly dog). That's all well and good, except it's an indexed search so doesn't necessarily reflect what's really on disk. And since by default my program files folder isn't indexed, it never shows any results no matter what I search for – until I go in and change the settings then wait for it to get around to indexing the folders.
There's a link at the bottom of the tab to use the trusty old search companion, but it means clicking it every time. Oh, and before you ask, no, there isn't an option to disable this irritating integration in WDS! I hate it when software comes along and arrogantly replaces existing functionality with itself and gives no way to remove it. I only put the thing on so Outlook would be able to search emails, not to make me click more buttons to search for files!
Of course, you can in fact turn it off, as a little digging has turned up. Simply open RegEdit (hit Start > Run then type 'regedit'). Go to the following node:
HKEY_CURRENT_USER\Software\Microsoft\Windows Desktop Search\DS
Then double-click on 'ShowStartSearchBand' and set the value to '0'. Close that and you're done, the next time you click 'Search' in explorer, the old, reliable search companion will appear. This applies to operating systems before Windows Vista, since Vista has far better search that actually works! (Okay, now someone will say it just uses WDS and I'm an idiot – wouldn't be the first time).
Tuesday, October 12, 2010
Excel: convert seconds to minutes
An alternative to maintain your time data integrity ie. if you change the format
would be to use the following formula
=YourCell/(60*60*24)
The division by 60 * 60 * 24 is neccessary
because Excel stores all dates as integers and all times as decimal fractions. Excel takes your value as been a single day or 24 Hour
period eg enter 2 = 2days = 2 24hr periods =2*60*60*24 secs
Times are stored as decimal numbers between .0 and .99999,
where .0 is 00:00:00 and .99999 is 23:59:59
and then format your cells like this;
In the "Format cells" Dialog
Select Custom
In the "Type:" box
Type in "mm:ss"
This should give you the results as Minutes Seconds
Use the format painter to copy the custom formats to
your data range.
would be to use the following formula
=YourCell/(60*60*24)
The division by 60 * 60 * 24 is neccessary
because Excel stores all dates as integers and all times as decimal fractions. Excel takes your value as been a single day or 24 Hour
period eg enter 2 = 2days = 2 24hr periods =2*60*60*24 secs
Times are stored as decimal numbers between .0 and .99999,
where .0 is 00:00:00 and .99999 is 23:59:59
and then format your cells like this;
In the "Format cells" Dialog
Select Custom
In the "Type:" box
Type in "mm:ss"
This should give you the results as Minutes Seconds
Use the format painter to copy the custom formats to
your data range.
Friday, September 17, 2010
Remove Messenger (msn) advertisement and work with mutiples sessions in same machine
Remove Messenger (msn) advertisement and work with mutiples sessions in same machine with A-Patch
http://apatch.org/downloads.php
1º Passo
Ir à janela principal do Messenger, abrir “Ferramentas”, “Opções”.
2º Passo
Ir à opção “Ínicio de sessão” e desligar a opção: “Mostrar o Windows Live Hoje depois de iniciar sessão no Messenger”:
3º Passo
Sair do Messenger (ir ao pé do relógio, carregar com o botão direito no ícone do Messenger e escolher “Sair”).
4º Passo
Sacar o A-Patch.
À partida, é logo o primeiro da lista (assumindo que estás a usar a última versão do Messenger).
5º Passo
Executar e clicar em “Next >” uma vez.
6º Passo
Escolher as seguintes opções (se te sentires confortável, podes escolher mais, sem perigo):
7º Passo
Clicar em “Apply”.
8º Passo
Clicar em “Exit” e testar!
E pronto… espero que tenhas conseguido ver-te livre da publicidade chata do Messenger!
http://apatch.org/downloads.php
1º Passo
Ir à janela principal do Messenger, abrir “Ferramentas”, “Opções”.
2º Passo
Ir à opção “Ínicio de sessão” e desligar a opção: “Mostrar o Windows Live Hoje depois de iniciar sessão no Messenger”:
3º Passo
Sair do Messenger (ir ao pé do relógio, carregar com o botão direito no ícone do Messenger e escolher “Sair”).
4º Passo
Sacar o A-Patch.
À partida, é logo o primeiro da lista (assumindo que estás a usar a última versão do Messenger).
5º Passo
Executar e clicar em “Next >” uma vez.
6º Passo
Escolher as seguintes opções (se te sentires confortável, podes escolher mais, sem perigo):
7º Passo
Clicar em “Apply”.
8º Passo
Clicar em “Exit” e testar!
E pronto… espero que tenhas conseguido ver-te livre da publicidade chata do Messenger!
Subscribe to:
Posts (Atom)