Viewing 15 posts - 41,986 through 42,000 (of 49,552 total)
Oh, one other thought.
If you have a DB growing that fast with performance problems, you may want to consider getting a specialist in to analyse and make recommendations. Especially if...
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
January 5, 2009 at 12:18 am
DBADave (1/4/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
January 5, 2009 at 12:07 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/Topic629584-323-1.aspx
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
January 5, 2009 at 12:05 am
Lester Policarpio (1/4/2009)
In situations like this can I take the database to offline mode then take it to online mode?
You can. It's not likely, by itself, to resolve anything though.
SQL...
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
January 4, 2009 at 11:40 pm
branovuk (1/3/2009)
Let me ask here, and not open new topic: what is best combination for backup: full+diff, or some combination with log backup as well.
Sorry, just noticed this...
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
January 4, 2009 at 11:32 pm
Jayakumar Krishnan (1/4/2009)
Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 120.2.7.30]
That looks like a Kerberos issue. Are there any other errors 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
January 4, 2009 at 2:24 pm
As the error says, siteID cannot be in the order by clause, because it's not contained in the group by and it's not an aggregate.
What's the point of having 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
January 4, 2009 at 1:51 pm
peter.chafin (1/4/2009)
There has to be some way to read the TRN files to see what types of transactions were taking place.
There are, but they are not cheap. SQL has undocumented...
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
January 4, 2009 at 1:23 pm
nbourre (1/4/2009)
Can someone tell me what's wrong with this syntax?
SELECT @lastSite = MAX(siteID)
FROM sites
WHERE fkSectorID = @sectorID
ORDER BY siteID DESC;
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
January 4, 2009 at 1:16 pm
nbourre (1/4/2009)
Now let's take that a step further. Let say I would like to generate the site with the last number from the same...
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
January 4, 2009 at 12:47 pm
It's very hard to tell why after the fact.
Were there any reindex jobs running during the period the log grew?
Having deleted tran log backups, you should do a full back...
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
January 4, 2009 at 12:42 pm
Untested, but I think something like this should work.
IF EXISTS (SELECT 1 FROM inserted WHERE siteID IS NULL)
UPDATE Sites SET siteID = sectorCode + CAST(pkSiteID AS NVARCHAR(5))
FROM
Sites INNER...
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
January 4, 2009 at 12:07 pm
Jody Claggett (1/4/2009)
Actually, what I have come to find out is that 2008 and 2010 are minor releases, which means the major portion of the engine hasn't changed.
SQL 2008...
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
January 4, 2009 at 11:34 am
DBADave (1/4/2009)
We have a 100+GB database that eventually with grow to 500GB+.
A 100GB database is not large. Even a 500GB doesn't qualify as very large.
Reindexing takes 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
January 4, 2009 at 9:06 am
parth83.rawal (1/4/2009)
Hope this will do.
Please read the article that I posted about how to post sample data and table structure.
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
January 4, 2009 at 6:42 am
Viewing 15 posts - 41,986 through 42,000 (of 49,552 total)