This SQL-sentence will first of all create a table (destinationtable) containing variable1, variable2 and variable3. Into the destinationtable it will make a tablesample from 10 percent of the observations in the soucetable.
tablesample (10 percent)
You could eg. use tempdb (a temporary database in Microsoft SQL-server) to store the sample.
This SQL-sentence helps you find the tables with enabled or disabled indexs.
I haven’t been able to find this information through SSMC.
SELECT name, is_disabled FROM sys.indexes
where is_disabled = 1
These commands will clear the cache from Microsoft SQL-server. It can be used during test to emulate runing a query against a “cold” server. A server where the cache hasn’t been filled with data.
Incorporating the DevExpress components in your executable can be done using ILMerge. In my case ILMerge is run through a .bat-file and works like this :
.\ILMerge\ILMerge.exe /targetplatform:v4 /target:winexe /out:.\OutputDir\mss.exe mss.exe .\DevExpress\DevExpress.BonusSkins.v11.1.dll .\DevExpress\DevExpress.Data.v11.1.dll
It takes mss.exe and the DevExpress DLL’s and merges them into one executable .\OutputDir\mss.exe
Right after that .\OutputDir\mss.exe is compressed using 7zip.
.\7zip\7z.exe a .\OutputDir\mss.zip .\OutputDir\mss.exe
And finally it is transferred to the website using WinSCP. I’m using Windows XP and as far as I know the build in ftp-client doesn’t support passiv FTP. I believe that ftp-clients in later versions of Windows does support passiv FTP. So if your using a later version than XP of Windows. You can do essentially the same thing with the build in ftp-client. But if your using XP and is connecting to a passiv FTP-server, you can use WinSCP.
Script.txt looks like this:
open <session in WinSCP>
option confirm off
put “.\OutputDir\MSS.ZIP” “/Programs/MSS.ZIP”
“Options confirm off” lets you overwrite a file without being prompted. You also need to create a session in WinSCP (GUI) or else you will get the following message:
Automatic actions are disabled when URL address is provided on command-line.