Hi my name is Fredrik, can you help me please. My hotmail account name is fredrikthegreat@hotmail.com

Can you help me please. My hotmail account name is fredrikthegreat@hotmail.com

Reply:

Hello,

Please let us know in this thread the obstacles or issues related to SQL Server you are facing.

Regards,

Alberto Morillo
SQLCoffee.com

------------------------------------

"Other Credentials" button on lock screen prevents me to switch user

Hi, All!

That is a laptop running Windows 7 x64 Pro, member of Microsoft Domain Network (Srv2008). Once a user logged in - that is no "Switch User" button appears after logoff or when screen is just locked. Instead of it I see button says:"Other Credentials", click on it provides me an option to log in back with the last logged account, use a finger scanner for authentication (Lenovo Laptops has this feature) or simply "Cancel"

I will appreciate any advice or solution regarding the following issue, nothing in Domain Network should not prevent Administrator account from login and in this case I able to procceed only after system restart.

Thank's

Changed type Vincent Wang-MCSC Monday, February 11, 2013 9:11 AM

Reply:

Hi ,

I notice you have posted this issue before. In order to avoid confusion and keep track of issue, I recommend to keep working with the previous thread as link below:

http://social.technet.microsoft.com/Forums/en-US/w7itproinstall/thread/44418335-e8a8-4ed8-958e-db1feb031721

Thanks,

Vincent Wang
TechNet Community Support

------------------------------------

How do I reduce font size in a Link Bar?

I inserted a Link Bar and it works fine. I picked a style I like, and it applies OK. But when I right-click on the Link Bar and select Font, no changes apply. The Link Bar seems to be frozen in Arial medium. Fonts change fine everywhere else in the webpage.

Reply:

I'm not sure what you are asking. Are you trying to change the font in the top navigation links? Do you mean the link in the web part title?

You'll need to use CSS to change the fonts on a SharePoint page. You can do that in the following ways:

To change just one web part on one page add a content editor web part that contains or links to your CSS. Hide the web part so it doesn't show in the UI.
Change the CSS across the site using SharePoint Designer or Visual Studio.

If this is not what you are asking, please clarify.

My Twitter | Website

------------------------------------

Unable to enable task history in task scheduler on wind 2008 R2 machine

In task scheduler when I click on the "enable all task history" I get an access denied. What setting or switch do I need to set for my user account to allow me to enable this setting? And where do I find this (or these) setting(s)?

Developer Frog Haven Enterprises

Changed type Cloud_TS Monday, February 4, 2013 1:43 AM wrong forum

Reply:

Hello elbilo.

I suggest you to ask your question in the Windows Server Forums at http://social.technet.microsoft.com/Forums/en-us/winservergen/threads. I can move it there for you if you want.

Bye.

Luigi Bruno

------------------------------------
Reply:

Thanks, I'll take you up on that offer. I ended up through bing, and there's no apparent link in the header bar to windows server software.

Developer Frog Haven Enterprises

------------------------------------

Multiforest Sync to Windows Azure Active Directory.

Hi All

I know that many integrator is in the same situation where only MCS can install the multiforest syncronization to Office365. (please corrent me if i'm wrong). This is not rocket or space sciense and i assume that many integrator has done even bigger IDM implementation using FIM but maybe not against Office365 or even Windows Azure Active Directory.

We are currently starting project to build multiforest sync to Azure Active Directory to be used in custom applications - and now i'm keen to know if someone else has done this earlier and can share tips and tricks and possible guides.

We will have 3 forest in differrent location and we are going to create new site to Azure and then using Site to Site VPN connect those and create/build the FIM environment also to Azure.

Based on the solution also interested to know if someone has configured FIM to use Azure SQL service or is that even possible. From business perspective we need to use two SQL server for high availability and fault tolerance but would like to hear if someone has configured Azure IaaS based FIM server to use Azure SQL server instead of dedicated virtuall machines.

Thanks.

Petri

Thanks.
Petri

Changed type Markus VilcinskasMicrosoft employee Friday, May 24, 2013 11:39 PM

Reply:

I am not of aware of anyone having used the Azure SQL Service to host the FIM database. I have heard of someone deploying FIM on a VM in Azure with SQL hosted as a VM.

At the Redmond Identity Summit last week it was discussed that you might be able to use your contacts as a partner to ask MSFT for the Office 365 connector.

David Lundell, Get your copy of FIM Best Practices Volume 1 http://blog.ilmbestpractices.com/2010/08/book-is-here-fim-best-practices-volume.html

------------------------------------
Reply:

We do have a product called CloudAnywhere that works in multi forest and multi tenant environnement.

We recently deployed it on a customer site who has 22000 users, 2 AD forest and 15 FQDN domains splitted in 2 Office 365 tenants.

We replaced the existing solution (dirsync+ADFS) which could not work in their environnement because of the limitations you explain.

CloudAnywhere synchronizes users, groups (security, dl, dl with security), contacts, passwords and now galsync. It also assigns the licences of your choice base on AD group membership.

CloudAnywhere works standalone (password sync is performed without schema extension, without bi directionnal trustrelationships, etc...) or can work on top of FIM 2010 to provision just the cloud targets that FIM 2010 cannot handle.

Regards,

Emmanuel Dreux

http://www.cloudiway.com

Edited by Emmanuel Dreux (Cloudiway) Thursday, January 31, 2013 8:31 PM

------------------------------------
Reply:

And just forgot to mention,

we do have a connector for Azure Active Directory.

However, it's quite limited:

- the Azure Active Directory Graph apis does not allow to write contacts.

- Password changes currently forces the flag "User must change password at next logon". For transparent password changes, we must still use the powershell commands.

Regards,

Emmanuel Dreux

http://www.cloudiway.com

Edited by Emmanuel Dreux (Cloudiway) Thursday, January 31, 2013 8:35 PM

------------------------------------

CPURateLimit which works in server 2008 R2 seems to be broken (or of null effect) in server 2012 and Windows 8

So per

http://technet.microsoft.com/en-us/library/ff384148(v=ws.10).aspx

this should work (and we have it working on 2008 R2.

Is this a known issue or documented anywhere.

the only place i've found that mentioned this at all is the post

http://social.technet.microsoft.com/Forums/en-US/winserverManagement/thread/a2ab8ee8-6424-4751-8844-1697dd1757cc/

Changed type Boo_MonstersInc Monday, February 4, 2013 6:30 AM

Reply:

I've not yet found a official document from Microsoft about CpuRateLimit in Windows 8/Windows Server 2012. Seems this function has been discarded in Windows 8/Server 2012.

------------------------------------
Reply:

it works for win7 and 2008 R2, and here is the docs for 2008 R2

http://technet.microsoft.com/en-us/library/ff384148(v=ws.10).aspx

i can't find anything about 2012. However i just remembered that it doesn't work until after a reboot after you set the registry key, and i'm not sure if i did that in my 2012 test. so i'm testing that now.

------------------------------------
Reply:

I did the reboot and made sure the registry key was there, and was for the right sid, and still it doesn't work in 2012. the CPU for my test process is still pegging out from 80% to 99% , despite the registry key saying this user should throttle to 15% (which works on server 2008 R2)

------------------------------------

Can you clean up the crawl logs without having to reset the index?

I would like to remove some information in the crawl logs from several months ago without resetting the index. I don't want to reset the index because full crawls take several hours in our environment. Is this possible?

Reply:

Hi Misty,

You could set the retention period as said in this article Clean up Crawl History

Regards,

Nithin

------------------------------------
Reply:

Do you have a full length URL for that site?

------------------------------------
Reply:

Nevermind, I think this will work:

http://support.microsoft.com/kb/2510620

------------------------------------

SQL Broker on SM DB

Hi All,

Which effect has it as result If the SQL Broker is not enabled on the Service manager database? It seems that the broker is disabled on our Service manager database since we have SP1 installed.

The first strange issue is that new created runbooks won't be synced to SM. The next issue is the soem DW Jobs are failed.

Regards,

Markus

Reply:

just a short update....

I have now enabled the SQL Broker for the SM Database. Seems that the DW Jobs are now running, will wait now till tomorrow and check it again.

Rgds

Markus

------------------------------------

Exchange 2010 and Outlook 2007, 2010 attachment auto zip option

We are using Exchange 2010 Sp1 in co existance mode with Exchange 2003, All our users are in Exchange 2010,

When a user sends a email with an attachment size of 9MB to 1500 users, we loose the space of 13GB from our exchange storage. Is there a way when a user attaches an attachment size beyond 512kb, any application that can zip the file automatically in the e-mail whcich can be plugged in to the outlook. So that we may save lot of spaces and unnecessary queue will not be there in HUB transport. The same feaure may required for OWA users as well...

Did any one have come accross these requirement and foud any solution, Please share..

Arul

Reply:

If you show your users how to use 7zip to ultra compress the file or any other utility to compress the files?

Would it not be better to place that file in a central point where 1500 employees can access it rather than sending out that mail?

http://www.slipstick.com/addins/auto-process/attachment-management-tools-for-outlook/

------------------------------------

Forum For VB regulars answerer

This thread is to communicate any news about what is going on with this forum project

And also for any thing else you want to say

Changed type Crazypennie Friday, January 27, 2012 10:23 PM It is not a question

Reply:

So my update is that I sent the request on to the team.

You can start multiple threads here for this purpose (just to chat as a community on any topic), and nobody will tell you to stop (knock on wood). Same terms of use of course.

Thanks!

Ed Price a.k.a User Ed, Microsoft Experience Program Manager (Blog, Twitter, Wiki)

Edited by Ed Price - MSFTMicrosoft employee Saturday, January 28, 2012 12:48 AM

------------------------------------
Reply:

Speaking of terms of use, one of my concerns about a MS-hosted "lounge" forum was that having a looser environment in terms of personal opinion and language might butt up against the requirements of MVPs that we remain professional in demeanor while interracting with the community. The same concern goes for those who are nominated in the future and have activity here scrutinized as part of the vetting process.

As mentioned in the previous threads leading up to here, there was a privately hosted forum a while back for the same purpose that wound up encouraging members to, well, speak their mind freely. This allowance was the most effective means to venting frustrations or stress. I can't help but feel that some us will not be able to be so free here, thus having us lose out on what may be the best attribute of a lounge atmosphere.

Still, I fully welcome such a forum even if it would not meet all of my expectations. The need and desire for it seems quite strong. If this discussion had popped up in some other thread like C# General I'm sure the regulars there would have come to the same conclusion.

------------------------------------
Reply:

Thank you very much Ed,

We really appreciate your help

------------------------------------
Reply:

Dig Boy (and Luke and Ed of course but I'm replying to the text of Dig Boy),

Yea I feel the same.

Success
Cor

------------------------------------
Reply:

Cor, Dig Boy,

This forum will be what we make of it, It can be a nice place where we pass our frustration laughing.

It is not because that there is 2 or 3 bad mouth in the regular answerers that we should just all stay alone with our keyboard and shut out mouth

------------------------------------
Reply:

I am certainly not a regular answerer. You guys have much more experience in answering on this forum. I have recently started and wonder if I'm up to the task... May I ask a few stupid questions ?

How much of your time do you spend on this activity ? Seems to me you are always here, everyday...
How many forums do you monitor ?
How much time do you spend answering one question ? Do you always test your code ?
Are you able to answer all questions in one forum ?

Thanks

------------------------------------
Reply:

I am certainly not a regular answerer. You guys have much more experience in answering on this forum. I have recently started and wonder if I'm up to the task... May I ask a few stupid questions ?

How much of your time do you spend on this activity ? Seems to me you are always here, everyday...
How many forums do you monitor ?
How much time do you spend answering one question ? Do you always test your code ?
Are you able to answer all questions in one forum ?

Thanks

Hardly stupid questions.

Maybe an hour or so a day on average - some days I don't at all. I find it a nice break during work when things get intense to switch gears by browsing the forum. I've often wondered if Cor ever spends a day away though ;) My numbers tell the story though - there are far more active regulars than me.
I was up to 3 but now I mainly stick to VB General.
No quick answer here. For simple questions I prefer to answer as quickly as possible while still providing some context and food for thought. Some people prefer the one-liners but I think that usually comes off as rude. For tougher questions or ones I don't immediately know the answer to I will often spend the time to open a new project and try out some code or write a few simple classes to illustrate a point. As for time - I'd be willing to bet that anyone who codes for a living can write code at blinding speed so long as they are coding something familiar. As for testing... not always. And it really hurts when you make stupid mistakes because of it. that makes me be more dilligent, and then after a wile I get complacent until another stupid error occurs. That's where I currently am in the cycle *fingers crossed*
I doubt there are more than a few people who could given the breadth of knowledge required. It depends on the forum though. Some are limited very tightly to one specific technology, so those woudl more likey have someone who "knew it all". The VB forums are like the bottom of the hill where just about any question can settle into given enough lack of forethought or care. The closest person I know here to spanning large swaths of knowledge is Hans Passant (nobugz). I remember a few years back he would occasionally breeze through a bunch of forums including the VB forums and nearly the entire first two pages would be answered by him within an hour. And then he would go on to the next forum not to be seen for a month or two.

------------------------------------
Reply:

Speaking of terms of use, one of my concerns about a MS-hosted "lounge" forum was that having a looser environment in terms of personal opinion and language might butt up against the requirements of MVPs that we remain professional in demeanor while interracting with the community. The same concern goes for those who are nominated in the future and have activity here scrutinized as part of the vetting process.

As mentioned in the previous threads leading up to here, there was a privately hosted forum a while back for the same purpose that wound up encouraging members to, well, speak their mind freely. This allowance was the most effective means to venting frustrations or stress. I can't help but feel that some us will not be able to be so free here, thus having us lose out on what may be the best attribute of a lounge atmosphere.

Still, I fully welcome such a forum even if it would not meet all of my expectations. The need and desire for it seems quite strong. If this discussion had popped up in some other thread like C# General I'm sure the regulars there would have come to the same conclusion.

Good points. You can edit your posts where you say anything you regret and then delete it. No one will know what you wrote. Not even mods. You should feel free to vent your frustrations, especially if it doesn't start any arguments or hurt anyone's feelings.

Ed Price a.k.a User Ed, Microsoft Experience Program Manager (Blog, Twitter, Wiki)

------------------------------------
Reply:

I am certainly not a regular answerer. You guys have much more experience in answering on this forum. I have recently started and wonder if I'm up to the task... May I ask a few stupid questions ?

How much of your time do you spend on this activity ? Seems to me you are always here, everyday...
How many forums do you monitor ?
How much time do you spend answering one question ? Do you always test your code ?
Are you able to answer all questions in one forum ?

Thanks

Those are good questions, and ones I can give my Forum experience to.

1. depends. I used to spend about an average of 6-8 hours a day. Now its probably an hour or two on a daily basis. A big reason for the decrease in time is as I've learned more, I can solve problems quicker.

2. 5 Forums

3. depends. Some questions I can put together some code on the specific problem in a few minutes; some take longer. Then there may be follow up questions or problems, usually because of an incomplete or unclear question. I always test my code before posting (well, unless I'm at a computer without VS, but I can ocassionally freehand the code sufficiently to get the point across). I find that approach takes less time than to post buggy code and have to go back and edit.

4. all ??? Maybe more like 5%. There is so much in .NET, it's virtually impossible to have that breadth of knowledge, even in a focused Forum such as Chart control.

Are you up to the task? If you have a passion for this, the simple answer is most likely. One of the best ways I learn is by trying to answer a lot of questions. Some I have to research a new concept, and that always gives me a little more knowledge. Then I look at other solutions and see where I can improve my code, or how to do something better.

------------------------------------
Reply:

I am certainly not a regular answerer. You guys have much more experience in answering on this forum. I have recently started and wonder if I'm up to the task... May I ask a few stupid questions ?

How much of your time do you spend on this activity ? Seems to me you are always here, everyday...
How many forums do you monitor ?
How much time do you spend answering one question ? Do you always test your code ?
Are you able to answer all questions in one forum ?

To much
4 but among those two in in the top of the most populair ones on MSDN, I don't like not so active forums (those have no community)
To much; no I'm not always testing my code simply because it is often about data or hardware which I've not available. Samples which I put on our website I always test. If I show a console sample, I've always tested it.
I'm for sure not able to answer all questions, especially not if it is not about the code itself but about for instance hardware resources which I don't have or things I simpley never liked for instance mathematical representations of images. But I see the forums as a fauntain of new things which pass my horizon, so often I do also new things simply to taught myself in that. However, I know from many questions, the places where to get an answer. :-) and if I see that a question is longer no answered in a forum, or I simply know they never will be answered in a certain forum, I give that place.

Success
Cor

Edited by Cor Ligthert Sunday, February 19, 2012 9:25 AM

------------------------------------
Reply:

I am certainly not a regular answerer. You guys have much more experience in answering on this forum. I have recently started and wonder if I'm up to the task... May I ask a few stupid questions ?

How much of your time do you spend on this activity ? Seems to me you are always here, everyday...
How many forums do you monitor ?
How much time do you spend answering one question ? Do you always test your code ?
Are you able to answer all questions in one forum ?

Thanks

1. this just depends if i am busy with some projects or not. If i am not so busy i keep checking my forums often or if need some distraction form my acual coding.

2. I do monitor 8 forums but only because i am also active in the german forums as well

3. This just depends on the quality of the question. If it is an easy one i don`t spend much time. If i remember that the question has been asked short time back and has been answered, i usually search for this thread and just post a link. I try to always test my code if it is possible. If i post by using my phone then i won`t.

4. no

Hannes

If you have got questions about this, just ask.

In a perfect world,
users would never enter data in the wrong form,
files they choose to open would always exist
and code would never have bugs.

C# to VB.NET: http://www.developerfusion.com/tools/convert/csharp-to-vb/

------------------------------------
Reply:

Forums seem quiet lately...

If you want something you've never had, you need to do something you've never done.

Everyone should take the time to mark helpful posts and propose answers!

Answer an interesting question?
Create a wiki article about it!

My Technet Wiki Articles

------------------------------------
Reply:

Hi Paul, for me, i lived the last months on the java side of life and also had been very busy. I check the forum regulary on my why to the office ( like now ). Hopefully will be back if i have more time.

------------------------------------
Reply:

You all are here

What is this

Do the Impossible

------------------------------------
Reply:

What is this

A dead end apparently :)

Blog: http://codemidden.wordpress.com

------------------------------------

SSIS Improve simple load performance

Hi

I just published a new post on SQL Server Central

6 Million rows in 60 seconds using standard laptop and I was wondering if there are any other ways to speed it up?

I want to use one physical disk and source as text file (later on I will try additional USB drives and convert source to RAW File)

Here is my set up:
Recovery Model: Simple
Initial DB Size: 1000MB (above what I need)
Connections: Flat File (fast parse property had little effect) + OLE DB (I tried SQL Server Destination but had minor improvement)
Buffers: Tried various settings but it seems in this case it doesn't have much affect.

Is there anything else I can try?
Man thanks
Emil

Reply:

Hi,

Remove any constraint, trigger and index on your destination table before the data load.

Once the data is loaded, you can recreate them.

Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu

------------------------------------
Reply:

What's the destination table like?
Any indexes? Already data present?

You could also set the network package size of the OLE DB connection to the maximum of 32K (Top 10 SQL Server Integration Services Best Practices), but I doubt if that will give any significant results.

Which buffer sizes did you try? Also change the DefaultBufferSize if you change the DefaultBufferMaxRows.

MCSA SQL Server 2012 - Please mark posts as answered where appropriate.
SQL2012

------------------------------------
Reply:

I have heap table with no indexes. I tried buffer size for both properties which had very little effect.

I'll try package size next. Thanks for this tip.

Regards

Emil

------------------------------------
Reply:

I also changed commit size to 0 and that reduced load time to 43s (139k rows per second).

I wonder if it can go below 30s? Any other suggestions?

Regards

Emil

------------------------------------
Reply:

Hi,

If you are having OLE DB source, use sql command and select only required columns insteading of peforming select *

Thanks,

hsbal

------------------------------------
Reply:

Source is a text file

------------------------------------
Reply:

Then I think loading 6M records in 1 min is acceptable on standard laptop. Do you still looking for cutting down this time?

this may help

http://microsoft-ssis.blogspot.com/2010/12/performance-best-practices.html

http://sqlcat.com/sqlcat/b/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx

Thanks,

hsbal

------------------------------------
Reply:

Thanks for the links. My load is a test of how fast the load can be done (using heap table and TPC-H Data), which I will than use to record additional videos for our 'SSIS Performance Tuning' series and upload to our Katie And Emil YouTube Channel

First test was 4 minutes (With deliberate bad db settings), Test no.7 is 43 seconds and still hope there might be some settings that can help... I'll try partitioning later on..it generally shouldn't have much impact on one physical disk however this is 2 platters / 4 heads so I'm hoping the drive will take advantage of that and maybe it will save several secs.

Any other suggestions (for one physical disk, later on I'll try USB per drive/external drive)?

Many thanks in advance

Emil

------------------------------------
Reply:

There's a whitepaper on SSIS performance published, that also involves setting certain trace flags on the SQL Server side.
I'm not sure if it will help in your case, but the article is worth the read:

The Data Loading Performance Guide

MCSA SQL Server 2012 - Please mark posts as answered where appropriate.
SQL2012

------------------------------------
Reply:

Thanks for the link... it is very useful.

It seems flag might not work in my case as heap table with tablock is minimal logging... the link might actually answer my next idea... which was to use page compression on heap table but it seems I might get worse performance (I'll try it anyway).

Thanks

Emil

------------------------------------
Reply:

Personally, I think 6 million rows in 43 minutes is still pretty amazing.

Another option that you can test out is to do it entirely in .NET using the SQLBulkCopy class. I've read this can have some astonishing speeds.
Also try out bcp and see if it can outrun SSIS.

MCSA SQL Server 2012 - Please mark posts as answered where appropriate.
SQL2012

------------------------------------
Reply:

I might try .net sqlbulkcopy... I haven't hear about it...I've tried bulk insert and bcp and there are ok but to get better performance I would probably still have to fiddle with settings so i'll stick with SSIS (but I'll try .net out of curiosity)

Latest update

I installed SQL 2012 Enterprise (I had BI before) and it seems it had affect on performance; maybe some BI limitations or maybe it is just positions differently on a disk...

I got (after multiple ran) 36s!

I tried page compression and I got 49s but then I thought row compression might be worth trying and now I get 33s! which 181k rows per seconds.

I'll try playing with partitions next and see if 2 platers/4 heads will make a difference..

Emil

Edited by Katie and Emil Monday, January 28, 2013 9:26 PM typo

------------------------------------
Reply:

I think you wanted to say 43 seconds not 43 minutes ;)

------------------------------------
Reply:

I think you wanted to say 43 seconds not 43 minutes ;)

Indeed. I was thinking at the time that my Oracle migration took about 45 minutes to transfer 30 million rows.

MCSA SQL Server 2012 - Please mark posts as answered where appropriate.
SQL2012

------------------------------------
Reply:

Two partitions was terrible! 3min 9s.

Any other suggestions?.... I hope we can get below 30s using one physical disk (after that I will plug in USB pen drive and hard drive and play with partitioning and Raw file as source).

Regards

Emil

------------------------------------
Reply:

A RAW file should in theory read faster than a flat file.

Try using the Balanced Data Distributor to parallellize the streams:

The "Balanced Data Distributor" for SSIS

MCSA SQL Server 2012 - Please mark posts as answered where appropriate.
SQL2012

------------------------------------
Reply:

First replace the destination with a row count and check what the time is... that's the time you want to approach... Balanced Data Distributor could work...

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

------------------------------------
Reply:

Just an update I got 28s after doing windows file compression on text file and removing row compression from table (is faster on standard txt file but slower on compressed text files).

I wanted to try Balanced Data Distributor but it doesn't work with SSIS 2012.

I also tried RAW file and I was quite surprised to notice that raw file size is 0.99GB comparing to txt file 730MB and I get 28s which is the same as compressed text file and compressed raw file is 27s.

I got below 30s over 200k rows per seconds so I'm happy with this result. Over the next several days I'll try USB external drives / pen drive and see if I can get below 20s. Read is 16s so I don't I can do anything about it unless I split the file, which I may try later on....

Thanks for your time and suggestions!

Emil

------------------------------------
Reply:

I found Balanced Data Distributor for 2012... I got 26s for compress text file for other scenarios it was actually slightly slower...for compressed raw file was much slower. I did notice much higher CPU usage so I presume in other environment it might perform much better.

------------------------------------
Reply:

With an SSD disk you probably will get even faster results. Or you can try a fast USB 3.0, this is also flash memory so about the same speed.

MCSA SQL Server 2012 - Please mark posts as answered where appropriate.
SQL2012

------------------------------------
Reply:

Tweak the virusscanner http://support.microsoft.com/kb/309422

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Edited by SSISJoostMVP Wednesday, January 30, 2013 7:37 AM

------------------------------------
Reply:

Virus scanner is off during the load ;)

Thanks to BDD I managed to load text file (without compressing it) in 29.s

Final outcome is recording on this video SSIS 6 Million rows in 30 seconds using standard laptop

Koen, SSISJost

I will create SQLServerCentral post soon and if you don't mind I'll would like to mention your input and with links to your websites.

Is that ok with you?

Regards

Emil

------------------------------------
Reply:

Sure, no problem.

MCSA SQL Server 2012 - Please mark posts as answered where appropriate.
SQL2012

------------------------------------
Reply:

No problem...

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

------------------------------------
Reply:

I am curious what is the speed of the load on a freshly booted machine?

The speed you show (my understanding) is so fast due to the memory buffers still being filled with the original data loaded at the 1st run.

Arthur My Blog

------------------------------------
Reply:

I am curious what is the speed of the load on a freshly booted machine?

The speed you show (my understanding) is so fast due to the memory buffers still being filled with the original data loaded at the 1st run.

Arthur My Blog

Perhaps clearing cache with tsql?
http://www.mssqltips.com/sqlservertip/1360/clearing-cache-for-sql-server-performance-testing/

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

------------------------------------
Reply:

Hi Arthur,

You are right I am relying on cached data which is much easier to compare results with various settings.

I'm going to restart my machine and run it.

How long do you think it will take?

Regards

Emil

------------------------------------
Reply:

Much longer

Arthur My Blog

------------------------------------
Reply:

Safe guess? ;)

It took 32.1s (187k rows per seconds).

Which is an interesting result in itself.

Regards

Emil

------------------------------------
Reply:

Interesting, I expected the load to last longer the 1st time.

I am curious, what are the specs of your laptop?

Things is I am thinking - when you are on a local connection you use shared memory to shove data into SQL Server so basically it equals to the time needed to read the data from disk (the slowest part).

Arthur My Blog

------------------------------------
Reply:

The laptop is acer aspire 5750 p5we0

http://www.tesco.com/direct/acer-aspire-5750-laptop-intel-core-i5-8gb-1tb-156-display-red/215-1703.prd

here is the drive spec for toshiba mk5059gsxp

https://storage.toshiba.eu/cms/en/hdd/multimedia/product_detail.jsp?productid=382

Read on its own (without write) is 16s

------------------------------------
Reply:

How large is a single record in the file?

Arthur My Blog

------------------------------------
Reply:

It's not one column with 1 bit ;) Text file is over 0.7GB and table is over 0.8GB

I'm using TPC-H Data generated from DBGEN with 1GB files (LineItem that I'm using is over 0.7 GB

------------------------------------
Reply:

You could also set the network package size of the OLE DB connection to the maximum of 32K (Top 10 SQL Server Integration Services Best Practices), but I doubt if that will give any significant results.

Just wondering... does this property has any result for local databases or does it only work for remote database?

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

------------------------------------
Reply:

Just wondering... does this property has any result for local databases or does it only work for remote database?

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

I think only for remote databases.
If SSIS runs on the same server as the destination, I think shared memory is used, so the TCP/IP layer isn't used.

edit: so why did I suggested it in the first place? Seems I wasn't awake at the time :)

MCSA SQL Server 2012 - Please mark posts as answered where appropriate.
SQL2012

Edited by Koen VerbeeckMVP Thursday, January 31, 2013 1:29 PM

------------------------------------
Reply:

Thx Koen... not criticizing, just wondering. Was testing this a while ago on my home network with my pc and a laptop and couldn't get big differences. Only a couple of seconds. Too little to make it a blog item :-(

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

------------------------------------
Reply:

The Packet Size actually makes several seconds difference with my test. I thought it wouldn't for local set up but it does so from my point of view I will most likely try to set connection strings with this property set to 32k. I think it can only help and I currently don't see any drawbacks.

Regards

Emil

------------------------------------

windows 8 to server 2008 tial and back

Hi Guys,

I have recently purchased asus laptop which came with pre-installed windows 8. I wanted to install windows server 2008r2 trial copy for study purpose. After trial period is over how can I get my windows 8 back. what are my options. please help

Reply:

Hello,

You should be able to use this command this is assuming X: is your external device or \\server\dir\ for network path.

wbadmin start backup -backupTarget:X: -include:C: -vssFull -quiet -AllCritical

Let it run make sure there are no errors then you are good to restore it later.

"solutions are not the answer" - Richard M. Nixon

------------------------------------
Reply:

You probably have the option to create recovery disk from asus. Create these dvd's and you will be able to restore the laptop to default.

The second option is you don't delete the recovery partition on the disk. Asus should be able to recover the laptop to default by pressing for example f8 on startup.

I recommend option 1

------------------------------------
Reply:

Recovery partition is too small for a bare metal backup, so I would not encourage that. As far as Asus software I won't take a chance with something when you know windows backup does exactly what you need.

"solutions are not the answer" - Richard M. Nixon

------------------------------------

Samsung Galaxy S 2 i9100 not Recognized by Windows 8 Pro x64

A few weeks ago I upgraded from Windows 7 Ultimate x64 to Windows 8 Pro x64 and ever since I have not been bale to get the PC to recognize the device.

I've downloaded the latest version of Samsung KIES to no avail. downloaded other Samsung mobile related drivers to no avail. Reformatted my C: drive and did a fresh install of Windows 8 and still can't get the bloody PC to recognize my phone. The only positive thing I can do is charge the battery.

Can anyone out there offer up some help?

Changed type Niki Han Wednesday, December 19, 2012 2:57 AM

Reply:

With the new OS releasing, there would be a lot of compatibility issues. I think you need to wait for new Samsung KIES software for Windows 8.

------------------------------------
Reply:

I have exactly the same problem.

I am glad to see your question before I also reformatted my drive as well......

Same thought :)

I gues I have to wait as well for the new Kies version windows8 compattible.

------------------------------------
Reply:

I have the same problem with my windows 8 x64 brothers.

------------------------------------
Reply:

I found someone who got it working, and his fix fixed it for me. (Kies not seeing my Samsung Galaxy S III phone) I downloaded the latest Kies as well..

From his post:

People on most forums are waiting patiently for Samsung to rectify the issue - but I came across a very simple solution in the meantime which works wonders.

After installing Kies - find the folder C:\Program Files (x86)\Samsung\Kies [If you're using 64bit] or C:\Program Files\Samsung\Kies [for 32bit]
Open the file named Kies.exe.config in a text editor (Notepad will do)
Find the line the bottom which says: <supportedRuntime version="v4.0" />
Delete that line, save the file, then open Kies.

Huzzah!

http://community.o2.co.uk/t5/Android-Devices-Samsung-HTC-Sony/Samsung-Kies-amp-Windows-8-A-fix/td-p/353372

Bob Comer - Microsoft MVP Virtual Machine

------------------------------------
Reply:

I found someone who got it working, and his fix fixed it for me. (Kies not seeing my Samsung Galaxy S III phone) I downloaded the latest Kies as well..

From his post:

People on most forums are waiting patiently for Samsung to rectify the issue - but I came across a very simple solution in the meantime which works wonders.

After installing Kies - find the folder C:\Program Files (x86)\Samsung\Kies [If you're using 64bit] or C:\Program Files\Samsung\Kies [for 32bit]
Open the file named Kies.exe.config in a text editor (Notepad will do)
Find the line the bottom which says: <supportedRuntime version="v4.0" />
Delete that line, save the file, then open Kies.

Huzzah!

http://community.o2.co.uk/t5/Android-Devices-Samsung-HTC-Sony/Samsung-Kies-amp-Windows-8-A-fix/td-p/353372

Bob Comer - Microsoft MVP Virtual Machine

Still does not work! Maybe it was better to buy a windows phone?

------------------------------------
Reply:

Bummer that it doesn't work, maybe it works for some phones and not

others.

>Still does not work! Maybe it was better to buy a windows phone?

I wouldn't know, never tried one and contracts are long... :(

What would be good is for Samsung to write a better Kies -- it never

worked as good as it should, even when it does work. I don't know if

that's a problem with Android, or just Kies, but it should work

better!

Bob Comer - Microsoft MVP Virtual Machine

------------------------------------

customsettings.ini not working

Hello

I am very new using MDT/WDS, but I cannot get any settings within the cusomtsettings.ini to work. It is as if customsettings.ini is blank.

It is the in the \control folder. I have updated the Deployment share. Found a script called wdscongsettingstest and when I run it, I receive the following error:

FAILURE (Err): 429: CreateObject(Microsoft.BDD.Utility) - ActiveX component can't create object

I registered Microsoft.BDD.Utility.dll and still receive the same error, so I do not if this bogus or actually an error that could be casuing the customsettings.ini to fail.

Here's a copy of my customsettings.ini

[Settings]
Priority=Default
Properties=MyCustomProperty

[Default]
OSInstall=Y
SkipAdminPassword=YES
SkipApplications=YES
SkipAppsOnUpgrade=NO
SkipBDDWelcome=YES
SkipBitLocker=YES
SkipCapture=YES
SkipComputerName=YES
SkipComputerBackup=YES
SkipDeploymentType=YES
DeploymentType=NEWCOMPUTER
SkipDomainMembership=YES
JoinDomain=MYDOMAIN
DomainAdmin=MYID
DomainAdminDomain=MYDOMAIN
DomainAdminPassword=MYPW
SkipFinalSummary=YES
SkipLocaleSelection=YES
KeyboardLocale=en-US
UserLocale=en-US
UILanguage=en-US
SkipPackageDisplay=YES
SkipProductKey=YES
SkipSummary=YES
SkipTaskSequence=NO
TaskSequenceID=W7-X86-001
SkipTimeZone=YES
TimeZoneName=Central Standard Time
SkipUserData=YES

Any and all help would be most appreciated!

Regards

Harry

Changed type MedicalSMicrosoft contingent staff Monday, February 4, 2013 2:15 AM not resolved

Reply:

have you checked the bdd.log?

------------------------------------
Reply:

The Hello,

The following errors are in this log file:

FAILURE (Err): 424: GetVirtualizationInfo for Gather process - Object required ZTIGather 1/25/2013 9:11:27 AM 0 (0x0000)

FAILURE (Err): 429: CreateObject(Microsoft.BDD.Utility) - ActiveX component can't create object ZTIGather 1/25/2013 9:11:27 AM 0 (0x0000)

FAILURE (Err): 424: GetVirtualizationInfo for Gather process - Object required ZTIGather 1/25/2013 9:11:27 AM 0 (0x0000)

I have registered the Microsoft.BDD.Utility.dll file, but this does not correct the error.

Thanks for responding

Regards

Harry

------------------------------------
Reply:

I plan to rebuld from scrath.

Regards

harry

------------------------------------

junk mail

How can I get rid of my junk and scam mail and recieve only mail from people on my contat list?

Reply:

You need to speak to your Exchange admin and ask him to setup some sort of filtering and maybe deploy an Edge server (depending on your env).

Other options are to point your MX records to a hosted AS/AV provider like message labs/symantec cloud and let them filter out the junk.

Seems like Outlook/Cloudmark is doing what it's meant to be and you just want to prevent if from even entering the mbx.

Sukh

------------------------------------

App-V 4.x fix in Symantec Endpoint Protection 12.1 Release Update 2

New fixes and enhancements in Symantec Endpoint Protection 12.1 Release Update 2

SEP 12.1 Update 2 includes a fix for an issue that affects App-V clients: Application Error when launching an App-V virtualized application on a computer with SEP 12.1 client installed

App-V virtualized applications cannot load with Proactive Threat Protection installed

Fix ID: 2689005 Symptom: App-V virtualized applications cannot load with Proactive Threat Protection installed.

Solution: Changed Application Control and User Mode Hooking to allow NTDLL image validation.

via: Symantec Endpoint Protection 12.1 RU1 and AppV 4.6

Please remember to click "Mark as Answer" or "Vote as Helpful" on the post that answers your question (or click "Unmark as Answer" if a marked post does not actually answer your question). This can be beneficial to other community members reading the thread.

This forum post is my own opinion and does not necessarily reflect the opinion or view of my employer, Microsoft, its employees, or other MVPs.

Twitter: @stealthpuppy | Blog: stealthpuppy.com | The Definitive Guide to Delivering Microsoft Office with App-V

Reply:

Hello,

Just a reality update;
This has supposedly been fixed in several versions, but keep poping up as an issue. I would deactive the function on an endpoint where App-V is used.

Nicke Källén | The Knack| Twitter: @Znackattack

------------------------------------
Reply:

It's par for the course with any AV vendor really. ;)

This forum post is my own opinion and does not necessarily reflect the opinion or view of my employer, Microsoft, its employees, or other MVPs.

Twitter: @stealthpuppy | Blog: stealthpuppy.com | The Definitive Guide to Delivering Microsoft Office with App-V

------------------------------------

Can not open powerpivot excel sheet for editing

Hi;

I am facing a strange problem in project server /sharepoint environment.

I have been publishing powerpivot reports on project server environment (in powerpivot gallery) and people have been using it without any issues. The problem is that If I want to change any of the reports, I can not open these files in edit mode. While clicking on 'open in excel' it opens the files in read only mode (for me) - from the permissions perspective, I am part of the administrative group as well as Project Manager group.

Other people in Project manager group can open these files in edit mode, but I can't.

any ideas?

Az.

Reply:

Funny - I found the solution as well... don't know the logic behind it... but...

Firstly - I noticed I could have the edit functionality If I was using another machine... so it was something related to my machine / browser.

So I went to security settings in the browser and ntoiced the sharepoint site was added as trusted site. I just removed it from there on a hunch - and then tried it... and voila... now I can open the file in edit mode.

Cheers

Az.

------------------------------------

Performence Issue

Hello,

I have temp table #test with column name ID varchar (max) . I inserted a value in this DELHI.

Now problem is when I am Writting another query and passing value city value in this query like this where city in (Select Distinct City from #test) then its running long

Or when I pass value Delhi directly it is producing the result with in Seconds

please let me know what can be the reason

Reply:

Does the city column have an index? How big is the table?

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance

------------------------------------
Reply:

Hello Uri,

City column does not have any index and it is containing only single value

------------------------------------
Reply:

Create UNIQUE nonclustered index and see how was it working?

------------------------------------

Who can help me about this topic Proxy (Microsost TMG server)?

Please !!

THANKS!

Changed type Nick Gu - MSFTModerator Thursday, February 7, 2013 1:56 AM

Reply:

Speaking for all of us that usually chimes in;

What's the problem? If we know that, then it'll be a lot easier to help out...

Hth, Anders Janson Enfo Zipper

------------------------------------

How to Retrive image from mysql display on vb2008 form(WindowApplication)

Hai all

How to Retrive image from mysql database using vb2008 to display on Picture box

I Stored Image path in mysql text field from that

if i store image file in root Folder(E:image.jpg) mean i can retrive image from mysql and display on vb Picturebox

But if i stored image file in sub folder(E:/Picture_fldr/image.jpg) cant able to display on picture box

What i need to do Please help me

image from mysql using root directry image path.

Ms Support forum

Sunday, February 20, 2022