Viewing 15 posts - 3,256 through 3,270 (of 7,429 total)
See this thread. It is along the same type of need.
March 6, 2003 at 5:50 am
With regards to a wide index. It is not bad if it is a clustered index and the only index in the table. If no the only then keep in...
March 6, 2003 at 5:05 am
Just create a variable and do not set the value. Then pass in and it will use the default.
Here is a VB example
SQL Code
create proc ip_tx
@var...
March 6, 2003 at 4:45 am
quote:
I think the optimizations rebuilds all indexes and marks them as "changed". Therefore they will be included in a differential backup.
March 6, 2003 at 3:31 am
I have done rentacoder, there is too much undercutting and not enough quality going on there. Many, many bid requests and guidlines there are extrememly unreasonable as well.
I am...
March 6, 2003 at 3:21 am
Actually "truncate log at check point " doesn't stop logging it just clears the transactions after a transaction completes. The transaction log is how DBs ensure that if an error...
March 5, 2003 at 3:02 pm
Not sure of a better way but this example is how I do it.
declare @d char(7)
set @d = '2003123'
SELECT CAST(DATEADD(dd, CAST(RIGHT(@d,3) AS INT), '12/31/' + CAST((CAST(LEFT(@d,4) AS INT) -...
March 5, 2003 at 11:18 am
Just in case I am wrong here what does RDA stand for in your question (Remote Data Access?)? If that then I am pretty sure the answer is yes, but...
March 5, 2003 at 5:23 am
This I do believe will do the job
ALTER DATABASE dbname
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE
however, see related thread for some good info.
March 5, 2003 at 5:20 am
Do you have AWE enabled and he /3GB switch in your boot.ini file for the OS. If not then SQL Cannot see past the first 2 GB of RAM.
See "Managing...
March 5, 2003 at 5:17 am
Readonly prevents data entry but does allow data access. If you want to set the DB actually offline and not available for use then use sp_dboption procedure
sp_dboption 'dbnamehere', 'offline', [true|false]
true...
March 5, 2003 at 5:14 am
Please do not cross post. See replies in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=10367&FORUM_ID=48&CAT_ID=1&Topic_Title=SP3+and+MDAC+2%2E6&Forum_Title=Service+Packs
March 5, 2003 at 5:09 am
Actually look here at the EULA
http://www.microsoft.com/sql/howtobuy/serverproc.asp
The place that concerns me most is item a. under section 1 "Grant of License"
quote:
a. Server Software....
March 5, 2003 at 5:06 am
Is it updating a range of records. If so keep in mind a table lives on pages and if the range covers enough positions it may be locking the whole...
March 5, 2003 at 4:53 am
BIGINT is only valid in SQL 2000, if using SQL 7 then your best bet is decimal or numeric with a precision of 10 and a scale of 0. Then...
March 5, 2003 at 4:47 am
Viewing 15 posts - 3,256 through 3,270 (of 7,429 total)