domingo, 10 de janeiro de 2016
When you conquer a language in DUOLINGO your are going to see this
sábado, 9 de janeiro de 2016
Why duollingo does not understand what I say? This is a possible reason...
When you are practicing, set Microphone Boost to zero.
I did this, and rarely duolingo says it does not understand what I say.
Well, of course we must not forget the other reason duolingo does not uderstand what you say is because your pronunciation is wrong.
I hope this helps you.
I'm currently finishing he Italian course. What about you?
sexta-feira, 8 de janeiro de 2016
INCREASE SIZE COLUMN SQL SERVER
ALTER TABLE MY_TABLE ALTER COLUMN MY_COLUMN VARCHAR(250)
quarta-feira, 6 de janeiro de 2016
You should use sqlcmd.exe using dos prompting to execute large sql files (GREATER THEN 1gb)
Whenever I have to execute a huge file, I use sqlcmd.exe via dos.
My strategy is
STEP 1
Create a specific user for that - something like USR_TOUGH_GUY
OWNED SCHEMAS
db_accessadmin
ROLE MEMBERS
db_accessadmin
STEP 2
Find the executable sqlcmd.exe in the machine where SQL SERVER is installed.
STEP 3
Execute
sqlcmd -S myServer\instanceName -U USR_TOUGH_GUY -P THE_PASSWORD_OF_MR_TOUGH_GUY -i C:\yourscript.sql
STEP 4
Disable mr TOUGH_GUY
Final considerations
You could do this using the SQLStudio but it will consume a lot of memory of the machine, if you are, for instance, trying to execute a 4GB file.
Good luck!
My strategy is
STEP 1
Create a specific user for that - something like USR_TOUGH_GUY
OWNED SCHEMAS
db_accessadmin
ROLE MEMBERS
db_accessadmin
STEP 2
Find the executable sqlcmd.exe in the machine where SQL SERVER is installed.
STEP 3
Execute
sqlcmd -S myServer\instanceName -U USR_TOUGH_GUY -P THE_PASSWORD_OF_MR_TOUGH_GUY -i C:\yourscript.sql
STEP 4
Disable mr TOUGH_GUY
Final considerations
You could do this using the SQLStudio but it will consume a lot of memory of the machine, if you are, for instance, trying to execute a 4GB file.
Good luck!
Marcadores:
command,
execute,
from,
line,
script,
SQL,
SQL Server 2008,
SQL Server 2008 R2,
SqlCommand
Assinar:
Postagens (Atom)

