Posted by arlene
How do we know if we have any rows in a table? We use the COUNT function to return a count of the number of rows in a table. If you enter Listing into Query Analyzer we can check the data insert for the Spy table.
This will return the current number of rows (well actually [...]
- June 17th
- Filed under: ASP, ASP.Net, CGI, CSS, Database, Design, Domain, Ecommerce, Java, PHP, Perl, SOAP, SQL, Search Engine, Sql Server, Templates, Web Hosting, Web Service, XHTML, XML
Posted by arlene
server, web-hosting, web-design, internet-service, domain hosting, computer
Posted by arlene
Shrinking a transaction log is a little different from shrinking a data file. The main difference is when the process occurs.
When a data file is shrunk, the task is performed almost immediately, whereas with a transaction log it is not. The log file is marked, so SQL Server 2000 knows that it needs to be [...]
