Viewing 15 posts - 2,251 through 2,265 (of 2,603 total)
August 3, 2018 at 8:34 am
you running that on your machine or on the server through cmdshell or sql server agent job? if on the server the files need to be on the server C:...
August 2, 2018 at 4:06 pm
Free versions already mentioned.
For paid versions
RedGate - SQL Prompt
DevArt - SQL Complete
Neither completely good, one better on particular things, the other better on other things. DevArt...
August 2, 2018 at 3:47 pm
can you post the sql you using as your source on the dataflow mentioning which column is giving you the undesired result.
August 2, 2018 at 12:18 pm
Taking in consideration what the output is I do not believe that you are doing a convert to decimal 38,10 on source, neither is the output defined with the same...
August 2, 2018 at 5:27 am
Could you post the C# code here so we can have a look at it and eventually suggest any modification.
And it will always be slow - just not...
July 31, 2018 at 12:00 pm
Trick is "do not use SSIS".
SSIS is very slow with clobs regardless of the driver used (possible exception of third party ones like CozyRoc and similar as i do...
July 30, 2018 at 5:22 am
Luis, I think you failed to understand what others were trying to explain but as I may be wrong can you explain to us how you will determine the content...
July 29, 2018 at 12:01 pm
perfectly normal - floats do not convert to varchar the way you expect.
DECLARE @myInt float = 5555555;
SELECT CAST(@myInt AS VARCHAR(12)), RIGHT(REPLICATE('0',8) + CAST(cast(@myInt as int) AS VARCHAR(8)),8)
July 29, 2018 at 4:35 am
small error on it as first 2 options are the same - did pick up one of the 2 set nulls off and got the wrong one
July 29, 2018 at 1:21 am
This really should not be sent to standard output but rather redirected to a database or a file as volumes can be quite high.
Import-Module sqlps -DisableNameChecking
July 28, 2018 at 4:43 pm
try
Import-Module sqlps -DisableNameChecking
$path='C:\localhost\serveur.txt'
$serveurs=Get-Content -path $path
$query="exec xp_readerrorlog 0,1"
foreach ($server in $serveurs)
{
invoke-sqlcmd -Query $query -ServerInstance $server
}
July 28, 2018 at 11:18 am
you also need to take in consideration licensing - if your dev boxes are using a SQL Server Developer license (being it a MSDN one or not) they can not...
July 25, 2018 at 9:05 am
Issue with MS CRM is that you cannot insert data directly onto their tables as doing so will void the maintenance contract.
if this is a PasS or SaaS you...
July 22, 2018 at 3:40 am
1 - and how many files you backing up to?
2 - Using backup compression or not?
3 - How many cores on the server?
4 - Server Memory?
July 20, 2018 at 11:00 am
Viewing 15 posts - 2,251 through 2,265 (of 2,603 total)