Viewing 15 posts - 1 through 15 (of 429 total)
TomThomson (3/8/2015)
Jeff Moden (3/2/2015)
sqldriver (3/2/2015)
This is a great day! I get to tell people I'm as good at something in SQL as Jeff Moden, even if it is SSIS. 😀😀
I'll...
March 9, 2015 at 8:08 am
Jeff Moden (3/7/2015)
Gosta Munktell (3/7/2015)
I would nether recommend anybody to use SSIS or an ACE driver in order to import sheets in native Excel...
March 8, 2015 at 8:35 am
This is a great day! I get to tell people I'm as good at something in SQL as Jeff Moden, even if it is SSIS. 😀
March 2, 2015 at 9:11 am
It sounds like you're just trying to do too much at once. I would suggest batching your update.
Here's the skeleton of one I use successfully on some really large...
February 15, 2015 at 5:16 pm
Your best bet is probably SQLCMD. You can read more about it here.
sqlcmd -S Server\Instance -i C:\path\to\script\Script.sql
February 15, 2015 at 4:58 pm
CooLDBA (2/10/2015)
That's the reason it is good practice to do it on Development first. Test the Service Pack then apply to Production.
I've updated 5 servers from RTM to SP3 in...
February 15, 2015 at 4:09 pm
Hi Perry,
Yeah, this is the first time I'm adding a file because I'm coming up against a limit. When I've done stuff like this before it's always been either to...
February 11, 2015 at 9:17 am
dwain.c (2/10/2015)
sqldriver (2/10/2015)
SQL_Surfer (2/4/2015)
ANSI_NULLS: True, ANSI_PADDING: True, ANSI_WARNINGS: True, ARITHABORT: True, CONCAT_NULL_YIELDS_NULL: True, NUMERIC_ROUNDABORT: False, QUOTED_IDENTIFIER: True => Through SSMS
ANSI_NULLS: True, ANSI_PADDING:...
February 10, 2015 at 8:38 pm
SQL_Surfer (2/4/2015)
ANSI_NULLS: True, ANSI_PADDING: True, ANSI_WARNINGS: True, ARITHABORT: True, CONCAT_NULL_YIELDS_NULL: True, NUMERIC_ROUNDABORT: False, QUOTED_IDENTIFIER: True => Through SSMS
ANSI_NULLS: True, ANSI_PADDING: True, ANSI_WARNINGS:...
February 10, 2015 at 8:17 pm
Cool, thanks Joe. I'll see what I can come up with based on this.
February 4, 2015 at 9:12 am
Hi Joe,
I did take steps to normalize it. The data as I presented it is how I received it in a load file. Not making excuses, but I didn't want...
February 3, 2015 at 12:32 pm
Hi Eirikur,
I feel a lot better about how I set things up now. That's about the identical schema that I made after the loading files were staged, with the exception...
February 3, 2015 at 8:08 am
Proximity on a small scale, but on a larger scale you'd need to choose connecting paths. Or even on a not very large scale; think about a subway system. Certain...
February 2, 2015 at 6:34 pm
Ah, yeah, it's not much more rows than this. I guess the point of the secondary relationships is 'route choosing' of sorts. Like, if you start with BarX, these are...
February 2, 2015 at 6:14 pm
dwain.c (2/2/2015)
sqldriver (2/1/2015)
Hello,Given the below table, how would you go about finding bars that carry the same brands of scotch?
So I've got to ask, why do you need it...
February 2, 2015 at 5:48 pm
Viewing 15 posts - 1 through 15 (of 429 total)