Viewing 15 posts - 35,461 through 35,475 (of 39,720 total)
The owner of the view must be the same as the owner of the table and you must grant update permissions on the view.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com...
December 31, 2003 at 10:39 am
I'm not sure there is a good way to do this. My guess is that only your documentation would cover this.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 31, 2003 at 10:38 am
I think it does, but if you are in read only, the difference between your last full and last full + logs is nothing.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com...
December 31, 2003 at 10:35 am
I would dump more frequently as mentioned above.
If you need to shrink it, http://www.sqlservercentral.com/scripts/contributions/26.asp
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 31, 2003 at 10:33 am
Wow, I would have thought this would work. I'll have to experiment with it. Not that BOL seems to be a big deal, updates are few and far between. And...
December 31, 2003 at 10:30 am
They can increase performance, but at an administration cost. In my working with DB2, one of the huge advanatages of SQL Server is the simplicity. there is less baby sitting...
December 31, 2003 at 10:27 am
There are a few diff tools, Lockwood (now named something else), AdeptSQL and RedGate's tool. there are reviews of these procs on this site.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com...
December 31, 2003 at 10:24 am
Was this the original size? If not a DBCC SHRINKFILE will bring it down or use this script:http://www.sqlservercentral.com/scripts/contributions/26.asp
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 31, 2003 at 10:20 am
select * from sysobjects where type = 'proc' and then run this in a cursor with exec( drop procedure xx) in the loop./
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002...
December 31, 2003 at 10:18 am
It potentially cold add rows. It depends if you have many variable length columns. The # of rows is 8060 / row size (roughly). Variable length columns could change that....
December 31, 2003 at 10:17 am
Thanks, I saw this out somewhere and thought it would make a pretty funny list for DBAs.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 31, 2003 at 10:14 am
Processing aborted when updating my personal info.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 29, 2003 at 1:22 pm
removed
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 29, 2003 at 1:09 pm
Not sure why this was locked, but I unlocked it.
I wouldn't use NAS, barely like using SAN because of the potential contention and access issues. If a large file copy...
December 29, 2003 at 11:00 am
Good idea. Love to see an article on using this in an app 😀
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 29, 2003 at 10:56 am
Viewing 15 posts - 35,461 through 35,475 (of 39,720 total)