Viewing 15 posts - 136 through 150 (of 405 total)
SSRS does not have a view on what executes inside the sp. so in theory what all possible for the user account running the query.
November 27, 2015 at 9:36 am
sorry for replying late.
As a temporary workaround you can use SQL authentication saved inside your connection manager. Delegation issues happen only when you connect from a different machine. Why don't...
November 27, 2015 at 7:43 am
First, It is not advisable for you to mention your server/ credential names in a public forum 🙂
The issue happening for you here is the delegation does not work for...
November 26, 2015 at 8:12 am
In sys.processess does your waitresource show something like 2:1:1. It might be a tempdb contention.
November 26, 2015 at 2:15 am
You are not doing anything wrong. If not opened in SSRS project, rdl reports are just xml files. However you can import all of these reports into a project and...
November 23, 2015 at 9:13 am
If you are able to use SSIS, there is a task available.
November 23, 2015 at 2:51 am
KcV (11/23/2015)
(After writing SP i do Optimizing using Database Tuning Adviser ) is it OK ?
I am not sure you should completely rely on DTA for performance optimisation that too...
November 23, 2015 at 2:48 am
Does it succeed after some time?, Can you find your session sys.dm_exec_requests? what is the status and waittype ?
November 23, 2015 at 2:37 am
itguy2015 (11/18/2015)
MadAdmin (11/18/2015)
Can you list the SQL services you have as well as whether they are running or not.
Here is a screen shot of the services. Note that where I...
November 18, 2015 at 9:49 am
What do you see when you execute select @@servername from both the instances. I think they both pointing to same instance.
Edit: I mean some alias name
November 18, 2015 at 8:34 am
Great idea, thanks for taking time to share your work.
November 18, 2015 at 8:29 am
TSQL Tryer (11/13/2015)
I have three fields in my query - ContactGroup, Contact and RelationshipID
All 10 entries are part of the same ContactGroup.
ContactGroup Contact RelationshipId
ABL001 ...
November 13, 2015 at 3:36 am
Great topic to discuss,
I have played all kinds of roles for SQL developer, DBA and data modeler and I have always found schema very useful for logically separating the objects...
November 13, 2015 at 3:26 am
Jeremy's script wont alter any database,
you need to select the out put of the query and run it in another query window.
You can develop dynamic query on top of...
November 9, 2015 at 10:27 am
entertaining and informative. I have used rename and partition switch. I think rename is good if its a one time load. Partition switch is something that can be created as...
November 5, 2015 at 2:41 am
Viewing 15 posts - 136 through 150 (of 405 total)