Viewing 15 posts - 3,691 through 3,705 (of 7,191 total)
Like I said, I can't see your screen. What is wrong with the results your query produces, and what is wrong with those my query does? Maybe you...
January 3, 2014 at 2:46 am
I have cracked this query upto some extent but there is something missing in this.
What is missing? Don't forget I can't see your screen.
I think you've made it more...
January 3, 2014 at 2:31 am
Gautham
First you said that the _dup table has the same columns plus an ID column, then you said that some columns may be missing. Do I take it you...
January 3, 2014 at 2:14 am
Russell
All five instances will be fighting for that 36GB. I would advise you to set max server memory on each instance, to stop that from happening.
Edit - when you...
January 2, 2014 at 9:38 am
How about the InteractiveMode variable?
Indicates whether the package is run in interactive mode. If a package is running in SSIS Designer, this property is set to True. If a package...
December 30, 2013 at 7:51 am
Presumably you run the debugger on a PC during development, but the package will run on a server in production? If that's the case, you can test the value...
December 30, 2013 at 7:43 am
You can't. Any primary key or unique constraint is enforced by an index. You can choose a non clustered index for the primary key if you prefer.
John
December 20, 2013 at 9:28 am
Not that I'm aware of, but you can use xp_logininfo to list the members of the group.
John
December 19, 2013 at 3:40 am
Rajnidas
Since you didn't post the code, I can only guess. I should think that your stored procedure is attempting a UNION or JOIN operation between a table in the...
December 19, 2013 at 3:09 am
What is the recovery mode of your database? Do you have transaction log backups set up?
John
December 17, 2013 at 3:43 am
Ah yes, that works. I was thinking you need the same columns in the SELECT list as in the GROUP BY clause, but of course you don't. Thanks...
December 16, 2013 at 8:32 am
No need for a cte to do this.
The reason for the CTE is because he wants SubName instead of SubID. Also, if SubName isn't unique, that would mess up...
December 16, 2013 at 8:00 am
Put what you've already got in a Common Table Expression, then join to the Subject table to get SubName.
John
December 16, 2013 at 6:53 am
I think the timeout is in trying to connect, not in running any command. Maybe the MySQL server is down, or there's a problem on the network?
John
December 16, 2013 at 5:19 am
No, I haven't. But you could run a trace to see what SQL is being fired when you bring up the Properties page, and hence why it isn't showing...
December 12, 2013 at 9:45 am
Viewing 15 posts - 3,691 through 3,705 (of 7,191 total)