Viewing 2 posts - 106 through 107 (of 107 total)
Yes! you can avoid cursors most of the time. I found this "cursor-less cursor" script on one of the SQL Sites, either this one, Swynk or another, a few months...
December 15, 2002 at 8:09 pm
#444425
I use a command in a regular job like this:
DBCC SHRINKFILE (MYDB_data, 1000)
... and it seems to work. The database (.mdf) in question routinely grows to over 2 gigs and...
August 15, 2002 at 12:47 am
#434599