Viewing 15 posts - 1,681 through 1,695 (of 11,678 total)
TomThomson (10/9/2014)
XKCD doing a cartoon version of a BOFH episode?
I had to google that one...
October 10, 2014 at 12:19 am
I'm not sure you can achieve this in Report Manager. Maybe you can upload a .htm file?
You can upload various types of files, but it's hard to predict how SSRS...
October 9, 2014 at 1:05 pm
kshatriya24 (10/9/2014)
EncryptSensitiveWithUserKey
Either change it to DontSaveSensitive and store user names and passwords in configurations, or change it to SavenSensitiveWithPassword and supply the password to SQL Server Agent.
October 9, 2014 at 1:01 pm
santoshkal (10/9/2014)
when i run the query it always taking non clustered index scan on execution plan...
October 9, 2014 at 7:31 am
Good to know. Thanks for posting the solution.
October 9, 2014 at 7:29 am
Your SSRS home page, is this Report Manager?
October 9, 2014 at 7:29 am
Abhijit More (10/9/2014)
we do not have flat files as I mention source and target both are SQL
Right, I got confused with the "flat structure table".
You mentioned "incremental load" in your...
October 9, 2014 at 6:26 am
santoshkal (10/9/2014)
after using where clause also its taking 100% cost ?any other way to improve ?
thanks
I'll say it again.
If it is the only query in the batch, it will...
October 9, 2014 at 6:02 am
santoshkal (10/9/2014)
or any other which can improve performance when i run the select * from & checked the execution plan its cost 100%
The execution plan will...
October 9, 2014 at 5:49 am
Phil Parkin (10/9/2014)
Never mind your old friend. Your two new friends, Koen and Phil, beat him to it, and in public 😀
😎 :w00t:
October 9, 2014 at 5:44 am
Jason Shadonix (10/9/2014)
And look at the disk space the table is using before and after the index. Especially if you do a lot of included columns in that index.
It's...
October 9, 2014 at 5:42 am
Maybe also compare if INSERTS have slowed down or not.
October 9, 2014 at 5:39 am
Phil Parkin (10/9/2014)
DECLARE @strdate varchar
SET @strdate = '2004-01-01'
select @strdate
By declaring your variable as Varchar but without a length, SQL Server assumes a...
October 9, 2014 at 5:26 am
Shame on you for not specifying the length of the VARCHAR variable 🙂
If you do not specify the length of the VARCHAR datatype, it takes 1 as default.
Basically your @strdate...
October 9, 2014 at 5:23 am
Eirikur Eiriksson (10/8/2014)
Suggest using a staging area on the target Sql Server and replace the Lookup transformation with a merge statement.
+1
Go for a staging area. Back updating the flat file...
October 9, 2014 at 5:02 am
Viewing 15 posts - 1,681 through 1,695 (of 11,678 total)