Viewing 15 posts - 10,846 through 10,860 (of 22,213 total)
Are we talking connections or transactions? If you have 4000 open & uncommitted transactions, yeah, I'd be having screaming fits right about now. That's locks being held open, possibly leading...
May 25, 2012 at 4:47 am
The reads measures are based on pages, yes.
As for time, it really depends on where you're getting the measure and what you're looking at. If, for example, you're looking at...
May 25, 2012 at 4:45 am
rkumar590 (5/25/2012)
Thanks for your reply.
Is the sp_cursorclose;1 depends on the Number of records it has been processed by the update which was run before it or it depends on...
May 25, 2012 at 4:37 am
jez.lisle (5/24/2012)
I want to create a StoredProc that runs an Insert query into a table.
My main data table contains details around appts for customers. ApptID,...
May 24, 2012 at 3:58 am
rkumar590 (5/24/2012)
I am facing a weird issue ,during the processing of the certain tasks from Application,some part of time we are observing blocks in our database.
Processing ,load are quite...
May 24, 2012 at 3:50 am
There's a task scheduler built right into the OS. I'd just use that utility if all you needed was the ability to schedule tasks. You would have to pay for...
May 24, 2012 at 3:47 am
Based on the fact that it's literally twice the size of the others, I would wonder if you have two backups there instead of one? Check to see if the...
May 23, 2012 at 12:58 pm
PradeepVallabh (5/23/2012)
Thanks for the info...While analysing execution plan i noticed something called Estimated Number of Execution...what does it mean??
Parts of the execution plan are iterative. This means parts can be...
May 23, 2012 at 12:46 pm
TheSQLGuru (5/23/2012)
Grant Fritchey (5/22/2012)
May 23, 2012 at 6:47 am
Developer Edition for 2008 was not free. It cost money. Maybe you're thinking of Express 2008.
May 23, 2012 at 5:43 am
Can you post the execution plan for the query? It's hard to suggest improvements not knowing the structure of your system, tables, indexes, constraints, etc.
May 23, 2012 at 5:41 am
If your database was created using the defaults, then it's in Full Recovery. This means you need to backup the log on a regular basis, at least once an hour...
May 23, 2012 at 5:40 am
Piling on at this point, but that's one ugly naming convention so...
No, I've never seen one like that and wouldn't recommend it. In fact, I'd fight against it, kicking, biting...
May 23, 2012 at 5:35 am
Also remember, those costs are estimates. They're the only numbers you have, so you must use them, but they're estimates, not actual measures.
May 23, 2012 at 5:11 am
After reading Gail's articles, read my book. Links are in the signature.
May 23, 2012 at 5:09 am
Viewing 15 posts - 10,846 through 10,860 (of 22,213 total)