Viewing 15 posts - 38,206 through 38,220 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 25, 2009 at 2:23 am
WayneS (6/24/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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........................:...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2009 at 9:02 am
I didn't say to drop the table. I said try and drop the statistics.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2009 at 5:52 am
Query sysindexes and see if these are statistics or indexes
select OBJECT_NAME(id), name, CASE INDEXPROPERTY(id, name, 'IsStatistics') WHEN 1 THEN 'Statistics' WHEN 0 THEN 'Index' END as Type
from sysindexes
WHERE id =...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2009 at 1:39 am
neerav.saini (6/24/2009)
ON internet i was able to trace information regarding number instance and sizing except attribute listCAN ANYONE SEND ME LINK OR POST LINK TO GET ATTRIBUTE
What attribute? I don't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2009 at 1:27 am
Please post in the appropriate forum in future. The article discussion forums are for discussion of published articles.
Other than looking at the tables, relationships, stored procs (if any) and any...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2009 at 1:24 am
What does this return?
select name, type_desc from sys.indexes where name = 'PK__Employees__1D4655FB'
If it does return nonclustered, then to make it a clustered index you'll have to drop the primary key...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2009 at 1:19 am
Viewing 15 posts - 38,206 through 38,220 (of 49,552 total)