|
|
-
|
|
**Virtual Memory**
roughly 300 fewer DLLs [were] being loaded and nearly 400MB of VM savings when loading a Web solution within Visual Studio". Performance gains for other solution types was not provided directly,
**Improved Solution Load Times**
The...
|
|
-
|
|
Make a string operation using for loop to string length is costly on performance bases compare to convert it to character array and make string operation on that array...
|
|
-
|
|
If you are using environment variables in SSIS when using package configuration, chances are you will run into a situation where you add or change the value of an environment variable, and SSIS does not recognize it. There is a misconception that in or...
|
|
-
|
|
In general the package will be validated during design time itself. However, we can control this behavior by using "Delay Validation" property.
Default value of this property is false. It means that all actions taking place on the designer pane will b...
|
|
-
|
|
I do not need to "reset" password for my demo machine - so learned how to change the password policy.
my server was domaincontroller also, so it was > Group Policy Management > configuration > polices > windows settings > security settings > account p...
|
|
-
|
|
Go to MSDN profile > Edit my profile > Input URL's of your social network profiles
I just did, [My profile][1]
[1]: http://social.msdn.microsoft.com/Profile/Paras%20Doshi...
|
|
-
|
|
I have three-four vm's for playing with SQL. And all have 40 GB disk attached to it. I keep running out of disk space and so from now -
1. I'll give it 50+ GB or
2. Make the disc with dynamic growth.
Note that: I am NOT implying that your SQL serve...
|
|
-
18
Liked
| 15
Learned
| 3
Comments
|
|
In SQL Server Management Studio, we can select text and press SHIFT+CTRL+U and SHIFT+CTRL+L to change the selected text to upper case and lower case respectively. I have been looking for a similar option in Microsft word and just learned that this can b...
|
|
-
|
|
I just learned from Jacob sir that one can capture (only) the active window by using ALT + PrtScn command. Previosuly i used snipping tool for capturing "active windows" but now having learned about ALT + PrtScn would make my life easier. It's a nice ke......
|
|
-
|
|
I am a fan of hashtags on twitter because it makes categorizing and searching content very easy. sql server community has a great hashtag (#sqlhelp) for quick QA's on sql server. Any-who i found that "#"'s are searchable in Google+ too.......
|
|