Viewing 15 posts - 38,221 through 38,235 (of 49,571 total)
saidwarak01 (6/24/2009)
HI ALL,I CREATED A TABLE AND APPLIED CHECK CONSTRAINT USING IN AND LATER I AM ENTERING DATA WHY CHECK CONSTRAINT IS ACCEPTING ALL THE INSERT STATEMENTS.
Please don't post in...
June 25, 2009 at 2:36 am
As far as I can tell (http://msdn.microsoft.com/en-us/library/aa275462(SQL.80).aspx), pad_index is not a valid option for ALTER TABLE ... ADD CONSTRAINT, only for CREATE INDEX
Why do you want to pad the index...
June 25, 2009 at 2:34 am
Because the last nonclustered index that you added is covering (contains all the columns that the query needs) and is smaller than the cluster (because the cluster is the table)....
June 25, 2009 at 2:25 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic741584-148-1.aspx
June 25, 2009 at 2:23 am
vrabhadram (6/24/2009)
IS THERE ANY PROBLEM WITH THIS,PLEASE HELP ME.
Lots of problems, but we'll start with the log.
If the DB is in full recovery you need to be backing up...
June 25, 2009 at 2:23 am
WayneS (6/24/2009)
June 25, 2009 at 2:17 am
Chris (6/24/2009)
Table: 'APPROVALS' (202639965); index ID: 1, database ID: 5
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................:...
June 24, 2009 at 2:58 pm
if not exists
(select physical_device_name
from msdb..backupmediafamily
where physical_device_name=@physicaldevicename)
begin
set @backupdb='\\sql_backups\'+@@servername+'\'+@dbname+'_Full_'+convert(varchar(20), getdate(),112)+'.bak'
backup database @dbname to disk=@backupdb
end
else
begin
backup database @dbname to disk=@physicaldevicename with differential
end
Have you tested and confirmed that the expected branch of the IF statement...
June 24, 2009 at 11:33 am
Differential backups don't depend on a recovery model. They work in full or simple. A diff contains the data that has changed since the last full backup. Is it possible...
June 24, 2009 at 10:57 am
It is the naming that's causing a problem as a table name may not start with a number.
SELECT *
INTO NewTable
FROM [15cm]
GO
Just an additional note, if this is anything other than...
June 24, 2009 at 10:40 am
If you take a backup and restore it elsewhere, the restored database will be identical to the source database at the time it was backed up, fragmentation and all. The...
June 24, 2009 at 10:31 am
nscott (6/24/2009)
The logspace command returns: Log Size (MB) = 194.9297; Log Space Used (%) = 77.13519 (BUT 195/200 = 97.5%) ???
194 is the size of the file on...
June 24, 2009 at 9:02 am
I didn't say to drop the table. I said try and drop the statistics.
June 24, 2009 at 8:04 am
amandeep.sandhu (6/24/2009)
DROP Statistics not worked. It shows error.
It would kinda help if you said what the error was. I can neither see your screen nor read your mind.
Pls tell...
June 24, 2009 at 8:01 am
Eswin (6/24/2009)
Is there any other way other than dropping the primary key and the foreign keys.
Not in 2000 I believe.
How to get all the foreign keys that references this primary...
June 24, 2009 at 5:52 am
Viewing 15 posts - 38,221 through 38,235 (of 49,571 total)