Viewing 15 posts - 616 through 630 (of 2,463 total)
Almost 3 years old thread
December 28, 2012 at 4:28 am
jim 29109 (12/27/2012)
whether MaxDop could make a difference to Commits?
i dont think maxdop can affect the commit although it can speedup the queries at the cost of CPU. have...
December 28, 2012 at 4:23 am
gkganeshbe (12/28/2012)
Thanks Mr.Bhuvnesh. Now i have created an indexCREATE INDEX IX_tmpsize_tmpsizepk
ON tmpsize (tmpsizepk);
Again the count of Extent remains same as before.
thats what...
December 28, 2012 at 4:03 am
GilaMonster (12/28/2012)
I already said that the optimiser will not return the previous cached plan (if one exists) if it terminates early.
So does it mean that here this option only...
December 28, 2012 at 3:25 am
Sql server internally handles the data storage.
See the quote
A new table or index is generally allocated pages from mixed extents. When the table or index grows to the point...
December 28, 2012 at 2:01 am
Backup uses LSN marker to avoid concurrency and locking issue (
Remember transaction log backup takes resources. So if resources are maxed out during peak usage for example you may notice...
December 28, 2012 at 1:48 am
Another question,
When select shows the “Reason For Early Termination” is “Time Out.” then optimizer simply stopped trying and takes the plan that is currently the best, which might...
December 28, 2012 at 1:35 am
For future, you can set trace and capture that SP.
December 28, 2012 at 1:09 am
maida_rh (12/27/2012)
I didn't got any thing to restrict it ....Can i delete those user which are :NT SERVICE\MSSQL$SERVEREXPRESS
domian/user
NT SERVICE\MSSQL$SERVEREXPRESS
BUILTIN\Users
##MS_PolicyTsqlExecutionLogin##
##MS_PolicyEventProcessingLogin##
any suggestions ?
NO .. these are system genrated and required...
December 28, 2012 at 1:05 am
SELECT permission is given to USER not to LOGIN . so first you shiuld have LOGIN which will act as USER on any
database where you want to set...
December 28, 2012 at 12:55 am
Glad you got the solution yourself but i would suggest you to use set based or while loop instead of cursor
see Comparing cursor vs. WHILE loop performance in SQL Server...
December 28, 2012 at 12:51 am
Also please post exec plan(people would prefer graphical plan 😛 ) along with index definition too as index play significant role to pull out the data faster.
December 27, 2012 at 11:49 pm
December 27, 2012 at 11:42 pm
yuvipoy (12/27/2012)
How to find column is having value or not
Id Col_1 Col_2 Col_3 Col_4 Col_5 Col_6
1 1 NULL 2 NULL 3 NULL
1 9 NULL 8 NULL 4 NULL
Expected ans
Id, Col_1,Col_3,Col_5
which...
December 27, 2012 at 11:20 pm
GilaMonster (12/27/2012)
Bhuvnesh (12/27/2012)
will this option also return value when first time exec plan get created ?
Yes
is this option gives the value of 'reason for early termination' when...
December 27, 2012 at 5:21 am
Viewing 15 posts - 616 through 630 (of 2,463 total)