I delete rows in Table on SQL . I use command "DELETE "name of table" ". after this command, SQl deleted these rows, but size of DB not changed in Hard Disk. I think programms selected these how deleted. How i can dlete phisical rows without command "DROP Table." Thanks.
Not sure if OP is talking about memory, or disk usage. Seems like disk usage. In either case, deleting or truncating table will not release the resouce back to Windows OS. SQL OS will hold on to the freed up resource unless you make it release it back to Windows OS. To make it release the resource back to Windows OS, you will have to shrink the data file. But in most cases, shrinking the datafile is a bad idea. In addition to the link Chandu posted, take a look at this article to see why it is a bad idea: http://www.sqlskills.com/blogs/paul/why-you-should-not-shrink-your-data-files/
If you are short on disk space, examine what else is using up disk space. In particular, look at database log files. You can shrink them and keep their sizes small by frequent log backups (for full and bulk-logged recovery models) or using simple recovery model.