Viewing 15 posts - 6,496 through 6,510 (of 13,876 total)
mark 4643 (10/19/2016)
Our dev team is growing. We use red-gate toolbox, so we have schema compare, data compare and source control. for the past few years we have used...
October 19, 2016 at 6:01 am
Thom A (10/19/2016)
October 19, 2016 at 5:54 am
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
Viewing 15 posts - 6,496 through 6,510 (of 13,876 total)