Viewing 15 posts - 6,496 through 6,510 (of 13,877 total)
While it will probably have little effect, I would suggest reducing the varchar(max) column to something more realistic.
October 18, 2016 at 1:28 pm
Thom A (10/17/2016)
Phil Parkin (10/16/2016)
Your lab would need SQL server 2016 developer, VS2015 SSDT and VS2015 SSDT-BI, so three installs at a minimum. ...
Actually, this bit is not quite correct....
October 18, 2016 at 1:25 pm
dc4444 (10/18/2016)
Yes, I tried increasing it to 2 minutes. But it still fails after the 3rd poll.
Yes, I redesigned the logic so that it uses a "table valued parameter" passed...
October 18, 2016 at 1:21 pm
dbaforever (10/18/2016)
1. I don't see the link you referred to
2. These packages work well on the old 2012 instance (Visual Studio 2012). Are you suggesting I install VS...
October 18, 2016 at 12:05 pm
SQLHeap (10/18/2016)
October 18, 2016 at 11:59 am
sqlfriends (10/18/2016)
yes, sometimes I use stored procedure to return result.So for those, I give user the public role, and grant execute to the stored procedure.
Is that OK?
Thanks,
Not the best....
October 18, 2016 at 11:07 am
ZZartin (10/18/2016)
The easiest way is probably just to add them to the db_datareader group in the database. Assuming you don't need any more granular permissions.
I'd create an AD group,...
October 18, 2016 at 11:06 am
ChrisM@Work (10/18/2016)
mitzyturbo (10/18/2016)
Sorry Chris, forgot to attach the indexesHappy enough to go with the TOP 1 in a CROSS APPLY
Thanks anyway
Here's the ROW_NUMBER version. I think the index I posted...
October 18, 2016 at 10:12 am
dbaforever (10/18/2016)
In the Integration Services 2014 Project Conversion Wizard, it shows Package Status "Not Loaded", "One or more packages are not ready".
Also "Cannot create a task for XML...
October 18, 2016 at 10:09 am
Misha_SQL (11/17/2014)
Quick question...
October 18, 2016 at 9:23 am
sindhupavani123 (10/18/2016)
I need to write a query for teachers who dont have classes on a particular day.
like ex: name, day, courseid
Mary, MON, Science
Surya, TUE ,Maths
Mary, TUE ,Biology
The teacher teach...
October 18, 2016 at 7:57 am
river1 (10/18/2016)
Hello,The ssis as a loop also. It is a forearm loop container.
A what?
October 18, 2016 at 6:53 am
ChrisM@Work (10/18/2016)
BLOB_EATER (10/18/2016)
Grant Fritchey (10/18/2016)
Evidently stating the obvious when others are stating the opposite is not allowed amongst...
October 18, 2016 at 6:51 am
Wow. It's clear from the amount of detail included in your post that you've tried very hard to make this work. I feel your pain.
If you increase the polling interval,...
October 18, 2016 at 5:56 am
river1 (10/18/2016)
The ssis package was not done by me. But the for loop that exists in the spring should be fast. Faster then cursor, correct?
I have no idea how spring,...
October 18, 2016 at 5:41 am
Viewing 15 posts - 6,496 through 6,510 (of 13,877 total)