Viewing 15 posts - 13,561 through 13,575 (of 49,552 total)
This works fine in SQL 2008:
create table #tmp (
FileID varchar(3),
FileSize numeric(20,0),
StartOffset bigint,
FSeqNo bigint,
Status char(1),
Parity varchar(4),
CreateLSN numeric(25,0)
)
insert into #tmp (FileID, FileSize, StartOffset, FSeqNo, Status, Parity, CreateLSN)
EXEC ('dbcc...
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
April 8, 2013 at 7:34 am
Timing of the full backups? Those other databases having diff backups running after the 'optimisation' job?
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
April 8, 2013 at 7:24 am
Bear in mind that those views are only since the last time SQL was started, not all time.
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
April 8, 2013 at 6:50 am
With no clean backups you don't really have any good options. This is why regular integrity checks are essential (regular enough that restore from a clean backup is always an...
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
April 8, 2013 at 6:49 am
Why did you run CheckDB with repair allow data loss? That's the last resort for fixing corruption, not the first thing you try.
As for row counts, maybe. Thing is you...
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
April 8, 2013 at 4:45 am
Since there's a non-zero number of seeks and scans, no that is not unused (it's been used for seeks and scans)
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
April 8, 2013 at 4:40 am
SQL won't release memory unless the OS requests that it does (OS under memory pressure). It is always a good idea to set max server memory. As for what you...
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
April 8, 2013 at 3:54 am
This is a Microsoft SQL Server forum, as such most people here won't be all that familiar with MySQL. You will likely get far better, far faster answers somewhere like...
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
April 8, 2013 at 3:52 am
ben111 (4/6/2013)
So to connect to the new instance i choose (local), and to connect to the old instance I choose localhost\sqlexpress
Correct.
It's actually <machine name> and <machine name>\<instance name> for 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
April 6, 2013 at 2:53 pm
Since we're going nowhere fast here...
Finish this script (the file name) and then run this trace for a couple of days. It will pick up all backups, all restores and...
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
April 6, 2013 at 9:21 am
That however is not a native backup error. You have a 3rd party product also backing the DB up? What is it?
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
April 6, 2013 at 9:08 am
SQL ORACLE (4/5/2013)
Did you try?SELECT * FROM sys.sysobjects WHERE type = 'U' AND name = 'yourTableName'
sys.sysobjects is deprecated, included only for backward compat with SQL 2000 and should not be...
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
April 6, 2013 at 6:27 am
From Books Online:
Temporary Tables
There are two types of temporary tables: local and global. Local temporary tables are visible only to their creators during the same connection to an instance of...
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
April 6, 2013 at 6:26 am
ananda.murugesan (4/6/2013)
Is it possible restet the counter values 0?, it is showing cumlative number 258
From Books online (as quoted previously)
The rate value must be calculated by sampling the value at...
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
April 6, 2013 at 6:16 am
TheSQLGuru (4/6/2013)
Again I will say that the odds that tempdb contention is the PRIMARY cause of your slowness is VERY LOW compared to the myriad other causes.
Especially since this is...
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
April 6, 2013 at 6:15 am
Viewing 15 posts - 13,561 through 13,575 (of 49,552 total)