Viewing 15 posts - 37,981 through 37,995 (of 49,552 total)
Please read through this - Managing Transaction Logs[/url]
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
July 1, 2009 at 9:06 am
ps (7/1/2009)
Do you suggest we run dbcc checkdb every week so that such issues are recorded in the error log?
Yes, absolutely, and someone needs to review the results...
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
July 1, 2009 at 8:58 am
EXEC master..sp_MSForeachdb '
USE [?]
IF DB_ID() > 4
BEGIN
SELECT ''?''
ALTER DATABASE ? COLLATE XXXX
END'
Be careful if there's replication, as that will still affect the distribution...
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
July 1, 2009 at 8:46 am
ps (7/1/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
July 1, 2009 at 8:19 am
Untested, but should do as you want.
CREATE PROCEDURE [dbo].[GetOverallStatus] @statusid int, @Rows int OUTPUT
AS
DECLARE
@tablename varchar(200),
@query nvarchar(1000)
BEGIN
SET NOCOUNT ON;
SELECT @tablename = Tablename FROM dbo.Status...
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
July 1, 2009 at 8:19 am
WayneS (7/1/2009)
Which brings up some questions:1. What difference does it make what version a server is on for Intellisense to work?
Valid T-SQL constructs. Should intellisense show that DATE is a...
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
July 1, 2009 at 7:42 am
Steve Jones - Editor (7/1/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
July 1, 2009 at 7:39 am
The damage was in the cluster. It could be that you got lucky and it was an empty page that hadn't yet been dropped from the index.
p.s. you need to...
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
July 1, 2009 at 7:33 am
Edit: redundant
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
July 1, 2009 at 7:31 am
That's an awfully small autogrow amount for a 4GB data file
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
July 1, 2009 at 7:13 am
agh100 (7/1/2009)
But I am sure you know what it is I want.. Is this somehow possible?
I don't quite know what you want. Could you explain more.
Do you want single values...
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
July 1, 2009 at 7:07 am
San (7/1/2009)
And of course there is section "SQL Jobs" in this site. Hope you have noted it
And a 'resumes and job hunters' forum that this should have been posted in....
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
July 1, 2009 at 7:05 am
The only way I know is buying something like SQLPrompt (Redgate). There's no built-in intellisense in SQL 2005 and the intellisense built into SQL 2008 only works when connected to...
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
July 1, 2009 at 7:03 am
Right where it is now.
Not everyone's going to rush to cloud computing and not all databases are even suitable for putting in the cloud.
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
July 1, 2009 at 6:59 am
ps (7/1/2009)
Am still wondering why we didnt lost any data from one of the damaged pages that belonged to the other table.
Without seeing the output of checkDB for that database,...
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
July 1, 2009 at 6:54 am
Viewing 15 posts - 37,981 through 37,995 (of 49,552 total)