Viewing 15 posts - 47,671 through 47,685 (of 49,571 total)
Books online has good info on both. Or, if you don't have books online, the online technet library
Join fundamentals: http://technet.microsoft.com/en-us/library/ms191517.aspx
Union: http://technet.microsoft.com/en-us/library/ms180026.aspx
January 16, 2008 at 3:15 am
Hot add memory? Don't think it should.
Did you change the SQL Server's max and min memory after doing that?
January 16, 2008 at 3:10 am
Stored procedures. DLinq is just more ad-hoc SQL code that I can't tweak to swell my proc cache.
From what little I know about Linq, I'd prefer to use stored procs...
January 16, 2008 at 1:41 am
Another vote for perfmon and profiler. Add in reporting services and a cuople of jobs and you can have a very nice automated data collection and reporting. You'll still need...
January 16, 2008 at 1:39 am
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...
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...
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...
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...
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,...
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...
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...
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...
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...
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...
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
January 15, 2008 at 6:30 am
Viewing 15 posts - 47,671 through 47,685 (of 49,571 total)