Viewing 15 posts - 616 through 630 (of 2,462 total)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 28, 2012 at 1:35 am
For future, you can set trace and capture that SP.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 27, 2012 at 11:49 pm
see this link distribution database is growing quite large
[/url]
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 27, 2012 at 5:21 am
GilaMonster (12/27/2012)
Bhuvnesh (12/27/2012)
what i think is optimizer will take time to generate plan regardless of time boundation.You would be thinking incorrectly then. Google: optimiser 'reason for early termination'
will this...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 27, 2012 at 5:04 am
Viewing 15 posts - 616 through 630 (of 2,462 total)