TRUNCATE TABLE <table name>
Deletes all rows from a table without logging an transactions. Very useful if the contents of a table you want to delete is very large.
If you happen to install Microsoft SQL Server under a Windows account you later want to change to another Windows account you will have to login to Windows using the account it was installed under (Go to Control Panel>Administrative Tools>Services to find this out). You should then stop all SQL server services (MSSQLServer, SQLServerAgent, Microsoft Search, Full-Text Search, Distributed Transaction Coordinator etc). In Control Panel, click on Administrative Tools and then Services. For every SQL service you have installed you will need to view and edit the logon properties, changing the account for each one. A reboot should then complete the process.
Passed the CCNA exam today with a score of 912. My revision notes and tips are below.
My free CCNA study materials
Currently working on trying to automate the bulk input of web log files into a MS SQL database with DTS Designer and Active-X script.
Managed to concatenate fields and perform VB commands on the data prior to input. However running through a directory of files to input is somewhat more difficult.
Ideal DTS import solution
The following URL is a template CV that Russians use to get jobs in the west (Apparently). All you need to is add your name/dob/address/phone no/email and invent a couple of company names and addresses and bobs your uncle... :)
Template web CV
Constraints are important within a database structure as they insure database integrity.
This useful SQL command shows how to add constraints to existing SQL tables.
In this command a constraint between 2 tables (tblCountries and tblCompanies) is being created called FK_tblCompanies_tblCountries.
alter table dbo.tblCompanies add constraint FK_tblCompanies_tblCountries foreign key (ISOCountryCode) references dbo.tblCountries(ISOCountryCode)
According to T-mobile the new form of mobile phone communication will be a combination of pictures, sounds and slang phrases. These will produce a new abbreviated language which will be unique between groups of friends.
This news comes as the UK networks finally become MMS cross compatible. Enabling users of different networks to send picture messages to one another is seen as key to the take up of MMS.
Currently working on an ASP function to automatically generate meta keywords from a field of text. Words that appear more than once will come first in the list and will only be shown once. Stop words will be removed.
ASP META Keyword generator
Tabindex is very useful when designing large forms as it dictates what element the tab key jumps to next. Only works in IE. Tabindex of -1 is ignored. Tabindex's of 0 come after the highest tabindex.
The amount of data that you can send to the server using WML forms and Nokia WAP enabled phones such as Nokia 3330 and Nokia 7110 is limited. The URL and querystring lengths are also affected since they affect the size of the HTTP header. To fix this problem you have to change the CONNECTION TYPE property to CONTINOUS in the settings menu of the mobile.