Viewing 15 posts - 47,656 through 47,670 (of 49,552 total)
The cache for a DB gets flushed when the DB is restored, taken offline or detached. Also when some ALTER Database statements are run.
The cache for the entire server gets...
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 16, 2008 at 1:29 am
TempDB grows if there's lots of temp table usage, or queries that need internal work tables. It's alos sometimes used byt th query processor for sorts and aggregates.
If your tempDB...
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 16, 2008 at 1:20 am
Any idea what was running on the server at the time? Number of connections?
I would suggest next time it happens, run perfmon and watch the following counters:
pages/sec (memory)
transfers/sec (physical...
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 16, 2008 at 1:15 am
It's because one is clustered and one is nonclustered.
A clustered index is the table. The leaf level pages of a clustered index are the data pages and contain the full...
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 16, 2008 at 12:49 am
The error message pretty much says it all
Ensure the Log Reader Agent is running or use sp_repldone to mark transactions as distributed."
You have transactional (or perhaps merge) replication running 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
January 16, 2008 at 12:44 am
colin Leversuch-Roberts (1/15/2008)
sorry but a heap will fragment if it gets deletes and suffer page splits the same as any other table if conditions are right.
From my understanding...
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 16, 2008 at 12:00 am
santosh (1/15/2008)
Hi,Thks for taking the time to look through this but I'm not in favour of using #temp tables due to performance reasons.
Yet you use table variables. Why's that?
The only...
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 15, 2008 at 11:53 pm
I find that particular error message very misleading. I've seen it several times where the problem had nothing to do with remote access.
It could be that the server name 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
January 15, 2008 at 7:08 am
I'd say give it the permission. I haven't heard of a downside to it.
Instant initialisation also applies when backing up a database (I think), restoring a database and creating new...
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 15, 2008 at 6:49 am
Here's your problem
aysegul (1/15/2008)[/b
CASE dbo.fDetermineEndDate(...) WHEN NULL
Case <column> when null will never return true, because nothing is = to null.
what you're probably looking for is
Case when dbo.fDetermineEndDate(...) IS NULL...
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 15, 2008 at 6:35 am
Please don't cross post. It wastes people's time and fragments replies.
Please direct all replies to the following thread - help about case
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 15, 2008 at 6:30 am
Instant file initialisation requires that the account that runs SQL has permission to do volume maintenance.
Check the local security policy for the server, find the item 'Perform Volume Maintenance tasks'...
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 15, 2008 at 6:25 am
What error are you getting?
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 15, 2008 at 6:17 am
It's because the ownership chain is broken.
Assume a user that has exec permissions on a stored proc, but not on a table. The proc does a select on that...
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 15, 2008 at 5:02 am
icampbell (1/15/2008)
I have a seperate procedure that fires every minute that works for inserts.
However how do i do a triger...
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 15, 2008 at 4:08 am
Viewing 15 posts - 47,656 through 47,670 (of 49,552 total)