Viewing 15 posts - 1,651 through 1,665 (of 7,164 total)
Where did you learn about SPA/MPA?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 12, 2013 at 7:26 am
PHXHoward (3/11/2013)
There was another index out there that included 32 of the 35 columns which it was referencing. That seems like a really big...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 12, 2013 at 7:16 am
I assume you're using xp_cmdshell. If so, then is the account running xp_cmdshell in the sysadmin Role? If yes, then yes, the SQL Server service account is making the connection...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 12, 2013 at 7:13 am
The SSIS Export Column Transformation can do that for you.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 12, 2013 at 7:10 am
SQLSACT (3/12/2013)
opc.three (3/12/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 12, 2013 at 7:07 am
Eugene Elutin (3/12/2013)SELECT INTO is "performance winner", why would creating table first be better?
Not always. You can achieve minimal logging with INSERT INTO...SELECT as well. Some people prefer to create...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 12, 2013 at 7:02 am
EXEC() AT inked_server might be an option.
You can also adapt Example G to pass a variable containing your SQL of type N/VARCHAR(MAX) to EXEC(): http://msdn.microsoft.com/en-us/library/ms188332(v=sql.105).aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 12, 2013 at 6:58 am
Not sure. I cannot get the numbers to tie on my system so I am assuming there are other factors in play. Post back if you get it sorted, or...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 12, 2013 at 6:50 am
Looks like I am going to have to work with my customers to get the incoming files more standardized.
Honestly, I think that is a great next step.
Thanks again.
Anytime.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 12, 2013 at 6:44 am
Can you tell me what constitutes a format change?
Pretty much any structural change to the file. One thing to keep in mind though is that you do not need to...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 12, 2013 at 6:21 am
Are you sure the queries you're using to check both the cached plans and the clerks are meant to tie out? i.e. that there are not other mitigating internal factors...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 12, 2013 at 6:08 am
Stuart Davies (3/12/2013)
SQLRNNR (3/11/2013)
crookj (3/11/2013)
SQLRNNR (3/9/2013)
john.arnott (3/8/2013)
Revenant (3/8/2013)
SQLRNNR (3/8/2013)
opc.three (3/8/2013)
JAZZ Master (3/8/2013)
crookj (3/8/2013)
SQLRNNR (3/7/2013)
crookj (3/7/2013)
Daniel Bowlin (3/7/2013)
HelpSupport
Truss
Tether
Tie
Bolo
Whip
Rawhide
Eastwood
West Side
Story
TOY
(to) infinity
Bed, Bath...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 12, 2013 at 6:04 am
If you had added PERSISTED when adding the computed column there is a possibility you might still be waiting for that complete 🙂
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 12, 2013 at 5:48 am
SQLSACT (3/12/2013)
This is why I'm confused because when I query sys.dm_os_memory_clerks - I see all the allocations happening at the single page allocator and nothing at MPA
And you are concerned...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 12, 2013 at 5:44 am
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 12, 2013 at 5:31 am
Viewing 15 posts - 1,651 through 1,665 (of 7,164 total)