Viewing 15 posts - 181 through 195 (of 2,462 total)
Steve Smith-163358 (10/3/2013)
Is this discrepancy in time to be expected?
NOt neccessarily ..depends
Steve Smith-163358 (10/3/2013)
Is the process faster if the instance isn't restarted due to cached data?
Yes ..this is the...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 4, 2013 at 1:51 am
Steve Smith-163358 (10/3/2013)
With this many tables, I may be stuck with cursors or similar procedures
YOu can do this during Off- peak hours too , may be scehdule ...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 3, 2013 at 9:03 am
aaa121 (10/3/2013)
But from a performance I would like to think of other ways to access that data.
OK so what are the performance impact you think would come...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 3, 2013 at 9:02 am
dwilliscp (10/2/2013)
I am trying to shrink the first temp db mdf, but it is not shrinking
IN two cases , size will not get reduced.
1) Shrink will not work...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 3, 2013 at 8:57 am
have you experienced the memory crunch after the max memory decrement ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 3, 2013 at 8:40 am
aaa121 (10/3/2013)
However this would obviously pick up the same records time and time again.
How the data will be same on every query execution ? or you mean to...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 3, 2013 at 3:47 am
Steve Smith-163358 (10/2/2013)
However, they aren't actually SQL Server temporary tables (i.e. not # or ## tables)
Ahhhh... That is actually i wanted to listen.
Here are my 2 cents .
Yes in...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 3, 2013 at 2:49 am
yuvakom (9/30/2013)
Hi.. When i am trying to insert delta symbol into db, its converted to question mark(?) symbol...
What is the datatype of destination column ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 3, 2013 at 2:02 am
Tony Savoie (10/2/2013)
dont change a thing based on this output. That wonky setting may be there for a reason.
i had good(even bad too ) experience on this
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 3, 2013 at 2:00 am
Paul White (9/5/2013)
As Erland mentioned, a general-purpose index optimization pre-sorts rows on ClaimID keys for the lookup into the clustered index.
Paul,
Thanks for this detailed informatrion . i read it...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 1, 2013 at 3:59 am
Though i am not 100 % sure but we cant exec anything in parallel way(NOt talking about parallelism here). behind the scene sql engine will treat it with asynchronous...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 1, 2013 at 2:08 am
A small suggestion .. better to maintain everyting in a Database template ( every sql object requires to be available in new DB for new customer.)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 1, 2013 at 2:03 am
Do we need to update statistics AFTER index rebuild/reorgainze ??
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 30, 2013 at 6:09 am
use msdb
select 'ALTER LOGIN [' + name + '] WITH DEFAULT_DATABASE = YOUR_DB; ' from sys.syslogins where language = 'us_english'
and...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 30, 2013 at 5:16 am
Two points ...
1) are you running this maintenance job in peak hours... it should be run in nights (OFF - peak hours)
2) have you selectiong the advanced option in...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 30, 2013 at 5:08 am
Viewing 15 posts - 181 through 195 (of 2,462 total)