Viewing 15 posts - 14,191 through 14,205 (of 49,552 total)
Alexander Suprun (2/21/2013)
I've asked a specific question: 10MB of memory is required for tempdb object and 1Gb is available, is it going to write to disk or not?
Maybe, maybe...
February 22, 2013 at 3:12 am
Take a look at this article. http://www.sqlservercentral.com/articles/65804/, the section on data purity errors.
February 21, 2013 at 2:00 pm
I recommend you turn it off. On a server with nothing other than SQL it will provide no benefit as there's nothing to boost SQL's priority over and you run...
February 21, 2013 at 1:59 pm
ausman (2/21/2013)
February 21, 2013 at 11:08 am
bangsql (2/21/2013)
2. no of physical cpu = no of tempdb files.
Temp tables and table variables are always in TempDB, they're both tables, they're both entered in the TempDB system tables,...
February 21, 2013 at 10:43 am
Why did you change the DB to full recovery in the first place? Full recovery makes log management harder (you need scheduled log backups), not easier.
A DB in simple...
February 21, 2013 at 10:41 am
ScottPletcher (2/21/2013)
Are Transaction_Numbers -- i.e. clustered key values -- added in ascending sequence?If so, make sure SQL is sorting the rows before doing the INSERTs.
Why?
The exec plans are the same...
February 21, 2013 at 10:31 am
briancampbellmcad (2/21/2013)
February 21, 2013 at 9:08 am
sqlskj4000 (2/20/2013)
February 20, 2013 at 3:07 pm
You're correct.
sp_whoisactive must exclude itself from the report, because it would obviously be running while it's running. 😀
February 20, 2013 at 2:56 pm
rferreira.dba (2/20/2013)
Let me put this another way: Is there any valid reason for Microsoft not to fix this?
Because there's nothing broken here?
The kb article you referenced refers to a...
February 20, 2013 at 2:10 pm
If the query is runnable, it's in the queue for scheduling back onto the processor and is not waiting for anything (other than some time on the CPU). If the...
February 20, 2013 at 10:18 am
Start a blog, write some articles, present at conferences/SQLSaturdays, answer questions on forums.
February 20, 2013 at 10:17 am
Don't use Task Manager to check SQL Server's memory, it can display completely incorrect (far too low) values.
Perfmon counter - Total Server Memory.
February 20, 2013 at 10:16 am
Again, daily log backups??? Sure that's good enough?
February 20, 2013 at 10:13 am
Viewing 15 posts - 14,191 through 14,205 (of 49,552 total)