Viewing 15 posts - 35,536 through 35,550 (of 39,803 total)
Interesting question. I assume that the Verify backup does just that. Personally we take a slightly different tact.
Each day the backup file is named with the time it starts are...
January 2, 2004 at 11:00 am
I'd use a central procedure that takes the parameters and then calls one of 10 or so subprocedures that performs the search. Seems like a pain, but you set it...
January 2, 2004 at 10:41 am
Not entirely sure, but I'd say 3rd party app as well.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
January 2, 2004 at 10:36 am
I believe it's a byte issue, 256 possible values, -1 for no indexes (0), -1 for clustered (1), maybe a few system items, 255 might be locked out.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best...
January 2, 2004 at 10:35 am
It can help, each file uses a different thread, so this can be benficial. More physical drives can help as well.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
January 2, 2004 at 10:33 am
I ran this from one session:
CREATE TABLE [dbo].[tbltest] (
[Pkey] [int] IDENTITY (1, 1) NOT NULL ,
[fname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[lname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]...
January 2, 2004 at 10:22 am
Wouldn't recommend it:http://www.sqlservercentral.com/columnists/sjones/autoclosefordatabases.asp
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
January 2, 2004 at 9:57 am
Tend to agree with the above recommendation. Backup and restore works fine for me as a one time shot, but for continual movement of changes, I like to have a...
January 2, 2004 at 9:55 am
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
Viewing 15 posts - 35,536 through 35,550 (of 39,803 total)