The Heap™ – Consultancy ©®

9:58 AM

Friday! ;)

10:09 AM

Friday... and some monkey moved a LUN containing a 2.5TB database without detaching it first. Thankfully a not yet production database.

Phil

Ouch

gbn

10:33 AM

Hurrah! Friday

Phil

:)

gbn

We want this?

1

Q: Performance impact of having gaps in Identity Column in SQL Server 2005

We have a number of tables in our database with an identity column as the primary key & clustered index. Over the years records have been added and deleted from these tables and of course there are now gaps in the primary key column. Is there any impact to the performance of the clustered in...

Mark Storey-Smith

@gbn Thoughts on first week at new job? All good so far?

gbn

@MarkStoreySmith interesting

Mark Storey-Smith

@gbn Looks good

gbn

10:34 AM

Probably MySQL but will have SQL Server also

But not OLTP MySQL

Phil

It's about time I looked I think. The market looks pretty good at the moment

gbn

Still fun though: conceptual model to do etc

Mark Storey-Smith

@Phil Are you UK/US/?

Phil

UK

Mark Storey-Smith

Seems to be plenty of demand around London. One client of mine has been struggling to recruit since early last year.

Phil

10:38 AM

I turned down 2 jobs at the tail end of last year because I didn't like the location. Not sure if I'd want to do the London thing again. I've got used to the calmness of the North ;)

gbn

@Phil whereabouts? Are you northern anyway?

Phil

I'm in Manchester at the mo

Was offered one in Stockport & one in Warrington

gbn

I'm from them parts, not worked there though, but looked on occasion-

LucianU

Hello. Anyone knowledgeable about SQL Server around?

gbn

10:55 AM

@LucianU most of us :-)

How can we help you?

LucianU

Ok, I'll ask my question. I've installed SQL Server 2008 and I'm trying to connect to it with the Python driver

I've enabled TCP/IP in the configuration manager and added an inbound rule in the windows firewall. However, every time I try to connect, I get the following error: paste.pocoo.org/show/540471

gbn

same or different boxes?

LucianU

gbn, it's the same box, a windows 7 virtualbox instance

btw, doing 'nestat -an' doesn't show the port 1433 as active

and in the configuration manager > client protocols > TCP/IP the default port is set to 1433

and the configuration manager is telling me that both SQL Server and SQL Server Browser are running

gbn

is it a SQL Server named instance?

LucianU

yes, it's called SQLEXPRESS

that's what shows up after the host name when I connect with the Management Studio

gbn

11:08 AM

It isn't port 1434 then

1433 I mean

so hostname\SQLexpress require a UDP call to port 1434 to get the port for the named instance. Port 1434 is whe SQL browser listens on

LucianU

ah, I saw the UDP 1434 port opened

Ok, I'll look for a way to specify the port from SQLAlchemy

gbn

you maybe don't need it

LucianU

how should I do it then?

gbn

if you do specify port, you don't need instance name

hostname\SQLexpress or hostname,1234

I'd have to check sql alcheny docs

LucianU

ah, okay. I'll have a look

so the idea is that I either specify the hostname and instance name or the hostname and the port, right?

gbn

11:12 AM

See stackoverflow.com/questions/2745525/…

and you're using JTDS?

LucianU

I don't know what that is

I haven't installed it in any case

gbn

in my SQL error log, I see "Server is listening on [ 'any' <ipv4> 55743]."

this is hostname\SQLEXPRESS

LucianU

where is the log located?

gbn

In SSMS, management node

hhm. Not sure what the problem is because I don't know SQLAlchemy

LucianU

gbn, ok I managed to connect to the server, because I got a different error

thanks for all your help so far

LucianU

11:48 AM

gbn, do you know what happens if the port used by SQL Server is in use by another program?

my current solution is to hardcode the port number in the connection string, but I don't know how feasible this is

Mark Storey-Smith

12:06 PM

Only on a Friday would your data centre suffer a power cut... and the generator fail to start

gbn

@LucianU SQL won't start if you have forced the port

otherwise, it will change dynamically

LucianU

gbn, if it's going to change dynamically, I need a way to find a way to connect without looking for the port every time

maybe I should just force it

gbn

I'd force it

gbn

12:34 PM

@ConcernedOfTunbridgeWells: more your line of work... stackoverflow.com/q/9033298/27535

LucianU

gbn, thanks again. in any case, do you know where to find the protocol used to query SQL Server browser for the port of a certain instance?

SQLAlchemy doesn't have that and maybe it could be implemented

gbn

@LucianU It is TDS

WHich is proprietry

did you look at this: docs.sqlalchemy.org/en/latest/dialects/…

LucianU

gbn, I'm using a different driver

gbn

which one`?

LucianU

pyodbc

gbn

12:45 PM

and your connection string?

LucianU

'mssql+pyodbc://username:password@host:port/database'

gbn

interestingly, the exampkle with port shows

oops

LucianU

anyway, now I have a different issue. for some reason, I don't have the SELECT permission on the database

gbn

you need to grant permissions in the database for "username"

LucianU

hmm, I thought I did

from the Management Service

I followed this stackoverflow.com/questions/3998634/…

never mind, I did something silly

gbn

1:07 PM

Lordy. stackoverflow.com/questions/9033547/…

"Well is a client driven call, and they don't want indexes, am not arguing with them more on this! "

LucianU

I'm more and more convinced that you should argue with the client or not work for them at all

gbn

yep

LucianU

gbn, thanks again for all your help!

gbn

You're welcome.

Another "simplified" problem stackoverflow.com/q/9033760/27535

ConcernedOfTunbridgeWells

1:56 PM

@gbn Worth migrating to dba.se?

gbn

already flagged it

thought it matched the BI merge proposal scope thingies

flag this? stackoverflow.com/questions/3725863/…

gbn

2:13 PM

@jcolebrand: Old MySQL load balancing/cluster Q, stackoverflow.com/questions/894401/…

good fit for here but old: your opinion please?

gbn

2:53 PM

@jcolebrand; ditto this stackoverflow.com/q/105776/27535

jcolebrand

3:11 PM

@gbn this one I like.

@gbn do we already have a dupe of this one?

it feels like something we would have a dupe on already

gbn

flagged first one

for 2nd, several dba.stackexchange.com/search?q=%2Bmysql+%2Brestore+%2Bdump

Ben Brocka

@jcolebrand how long do meta pro temp elections usually last?

jcolebrand

@BenBrocka You are the second person asking me about pub-beta :p

You two should be asking on Meta.

as in Meta Stack Overflow

Phil

Hmm, pub. Only 2 hours to go :)

Ben Brocka

You're the nearest mod :P

jcolebrand

3:23 PM

lol

@BenBrocka the answer is "as long as it takes"

Ben Brocka

That's kinda what I assumed, but we dont' have many meta people

It's not very pressing though, I was just wondering

jcolebrand

You could always email community@stackexchange and ask them when they think they're going to do the pro-tem's. You should provide reasons for expediency when you do, and not just "wah wah why not yet"

Ben Brocka

I just noticed we kinda don't have anyone else to nominate and all our common meta users have spoken, I guess that might change as public beta people come in however

gbn

@BenBrocka: some of the game designers/artists here are interested in ux.se

any similar sites that may appeal to them that you can think of?

(.se sites)

Ben Brocka

What's wrong with UX.SE/GD.SE? game UX questions are welcome there. Game Dev.SE for development questions

gbn

3:33 PM

nowt. Sorry, I mean nothing is standard English. "nowt" is Northern Brit dialect

I've recommened ux.se already

Ben Brocka

Cog Sci is strongly related to the Human Computer Interaction side of UX so they may find it interesting if they understand/want to understand the psychological side of things

aside from that, UX and graphic design I'm not aware of other design-relevant ones

gbn

ta

Ben Brocka

3:52 PM

Do try and funnel them to cog sci if they're interested in the area though :) we're just starting: cogsci.stackexchange.com

jcolebrand

1

Q: SQL Server - Multiple running totals

I've got a base table with transactions and I need to create a table with running totals. I need them to be per account and and also have a few running totals for each account (depending on the transaction type), and inside that, some running totals per sub-account. My base table has these fiel...

sql sql-server performance query scalability

This seems like it needs query voodoo magic above and beyond simple syntax yeah?

gbn

@BenBrocka already done

Ben Brocka

@jcolebrand shudder at the idea of keeping the total in a separate table. Our ERA software does that, which meant our general ledger total balance could be updated while the actual invoice changing the balance wasn't entered. Fun times.

jcolebrand

@BenBrocka So the Q remains, does it belong here or on SO?

I think it would be a valid fit here

gbn

Sometimes the easiest way

it's a better fir for SQL Server 2012

jcolebrand

3:57 PM

@casperone stackoverflow.com/questions/9035502/… wanna slip it here?

Ben Brocka

DBA IMO, I Already flagged it

gbn

All of a sudden we can do so much more

Ben Brocka

There are a few possible ways to do that and I would want DB expert advice on that, not programmer expert advice

casperOne

@jcolebrand It's there, and I asked you guys about it in TE, thought it was a little on the NC side

jcolebrand

@casperOne I know you did.

casperOne

4:02 PM

@jcolebrand It's here now, enjoy!

Cade Roux

So programmers (who are programmers, so that's why they go to StackOverflow) to ask their programming questions on StackOverflow (which happen to be kind of database centric) and then we move them to DBA to be answered and answer them there? Only relational database questions? Are we going to encourage them to ask them at DBA, and what would make them want to do that? Would this include table-design questions stated in problem domain language?

jcolebrand

@CadeRoux I tend to describe it simply as "If you have a simple syntax or design problem, take it to SO or Programmers, if it's a complex problem, take it to DBA. If it's not a coding issue, but something about the specific engine in use, take it to DBA. If it's about the server OS, take it to SF, but if it's about server SPEC, take it to DBA."

That covers most of the use cases

SF already wants to push most DB oriented Q towards DBA

Ben Brocka

I would have thought DB design would be more our thing as well

jcolebrand

simple db design does not require experts

If I asked you how to implement googledocs forms, would you need an experienced DBA to store those records in a table? (not the exact current implementation of googledocs forms which is quite complex but a single form, with direct field to column mappings)

JNK

wow cade is in here too

jcolebrand

4:11 PM

However, let me ask you the counter: What makes a db design complex

Cade Roux

Sweet, I love it that the rapidly proliferating computer-related StackExchanges are going to mirror the fragmented dysfunctional silos in the real world and push problems around.

jcolebrand

@CadeRoux yeah, we complained about that a bit a long time ago

JNK

cade that may be a topic to bring up on chat.meta.se not here

KIDDING!

jcolebrand

we need one massive Q&A engine with complex tagging

Cade Roux

If no one minds, I'm still going to just start all my Oracle questions on StackOverflow.

jcolebrand

4:12 PM

the idea of multiple small silos seems to make more sense

Ben Brocka

@jcolebrand that's exactly what I was thinking. If I need to draft out an ER diagram I'd consider it complex

JNK

I have a question that may turn into a real Q for the site

jcolebrand

@BenBrocka So do you want to answer non-ER diagram Q all day here? There's a site for that ... Programmers

JNK

but for now I need to know if anyone has any insight into SLEEP_TASK waits in SQL Server 2008 r2 enterprise

jcolebrand

@JNK this is a good place to ask that

gbn

4:13 PM

@CadeRoux it depends on what you're asking

jcolebrand

However, I encourage (the same as I do on chat.so) to make a Q anyways, so that it can be found by google

JNK

I will

jcolebrand

/afk

Cade Roux

@gbn All PL/SQL and Oracle best practices (for database development - i.e. no temp tables, what to do, etc.)

gbn

We've had some good Oracle Q's these last few days that have been migrated

Ben Brocka

4:14 PM

@jcolebrand I'm not as familiar with programmer's scope any more

JNK

afk could be read in olde englishe as ask

Cade Roux

@JNK is there a migrate off-topic chat thread feature yet?

JNK

@CadeRoux I don't think so

chat is thankfully not heavily regulated

jcolebrand

4:31 PM

@BenBrocka programmers.stackexchange.com/faq

Cade Roux

@jcolebrand Another pointless fork - you can ask freelancing and business questions but not salary or compensation questions and all the things they do allow could just have been tags on StackOverflow. I would have thought the success of facebook and iOS and Android tags on SO would have made it obvious that people want to go to one place no matter what they are talking about.

Does this one get migrated?: stackoverflow.com/questions/9036797/updating-mysql-primary-keys

Mark Storey-Smith

@CadeRoux Don't take offence to this but can I use one of your answers on SO as a reason why specialist forums might be preferable?

stackoverflow.com/questions/314824/… +57 upvotes for an old school approach to that particular problem. Migrate it over here and it would be massively downvoted and a preferable approach posted and upvoted

jcolebrand

@MarkStoreySmith Sorry, you're not violating his point, but enforcing it.

The issue is not dilution of viewpoints, it's overwhelming numbers of questions. If the filtering of things you want to see could make things float to the top better, then it would be a different story

as it is, we can't study snowflakes in an avalanche, which is about how it feels trying to keep an eye on the frontpage of SO

JNK

I think part of the benefit of having multiple silos is limiting feedback

Cade Roux

@MarkStoreySmith No offense - I think I have NEVER used a split function myself of any flavor.

JNK

4:47 PM

is it more helpful to know if 120 php monkeys like an answer about SQL Server, or that 10 SQL professionals do?

3

jcolebrand

@CadeRoux It would probably do better here, yes, because swapping primary IDs is a kind of tricky thing to do properly

@JNK very true, and with that you probably hit on the biggest reason for sub-branching. Which may be why they didn't pursue single silo system

JNK

There's no restriction on who can vote on which questions.

I can just go upvote all the ios and cocoa answers

without having a clue

jcolebrand

0

A: Why edit must be at least 6 characters?

So to get an idea of the breadth of discussion already on the network for this, I suggest this search on Meta.StackExchange. Here's the more succint version http://meta.stackoverflow.com/questions/77962/limit-of-manual-of-6-char-on-edit-size-when-you-dont-have-full-edit-rights and more proof th...

is this clear?

JNK

@jcolebrand yeah, but just add a note that the limit only applies to low rep users. you imply it but don't state it outright

once you are "trusted" enough you can make a 1 char edit if you like

Cade Roux

@jcolebrand His problem is that MySQL doesn't handle the update atomically. But in general, I prefer static PKs, as I assume most do.

JNK

4:51 PM

+1 for the edit

jcolebrand

@JNK If it didn't come across clearly, I wanted it to stand out. Probably need another # at the beginning, seems a bit too large

I'm happier with that

JNK

i threw in an edit for you

jcolebrand

we collided :p check the history

JNK

no YOU check the history

Phil

I agree. PKs should be static. I believe in a seperation of "internal" and "external" IDs

Cade Roux

4:56 PM

@JNK I disagree with the siloing for quality approach - Easy questions over here, harder questions over here. Voting isn't perfect.

jcolebrand

@CadeRoux precisely what is a hard question?

Can I have more rep for answering hard questions?

maybe some sort of specialized rep?

JNK

@CadeRoux - I don't think we should separate for quality necessarily

jcolebrand

This has all been hashed out again and again on meta, and in chats on the network, and in IRC, and in emails, and in face-to-face conversations

JNK

but I do think it's more helpful to get 10 upvotes on dba.se vs on SO for certain types of questions

on SO you will get upvotes for something that looks cool, on the more specialized sites it seems to be more about content

speaking of which, shameless plug:

0

Q: SLEEP_TASK Wait Type in SQL Server - What does it indicate?

I haven't seen the SLEEP_TASK wait type before, and today I seem to be getting a ton of them. I'm not the official DBA, just a SQL Server developer who knows some DBA stuff. We upgraded our servers last weekend to 10.52.2500.0 - R2SP1 I think. All the info I could find online indicates that SL...

sql-server wait-types

Nick Chammas

@JNK this is a good question to refer to for tagging

should it additionally be tagged sql-server-2008 or sql-server-2008-r2?

or both?

should there even be an r2 tag?

Cade Roux

5:04 PM

@jcolebrand I don't have time to follow all that. I come to SO to ask questions and give answers. When the system doesn't behave in a simple, friendly or logical manner, it is offputting. Just like the "no recipes" rule on the SE cooking site - it just puts off users who will come back less.

jcolebrand

@CadeRoux "I don't have time to understand the decisions that were made, but I hate the system and use it daily" ... sounds like almost every user on the planet. This is why we can't have nice things (because it's hard to build good systems that "just work")

@NickChammas we actually just answered that on Database Administrators Meta didn't we? I swear we did...

Nick Chammas

@jcolebrand ah, so we're settling on leigh's answer, which means we should add the r2 tag, correct?

Phil

why was this forked in the first place BTW?

jcolebrand

@NickChammas yes

@Phil dba.se? So that you could get real answers from real experts instead of trusting the hivemind of PHP upvoters who voted for the thing that worked for them, but was the effective same thing as replacing the firing pin in your gun while a bullet was in the chamber

3

Nick Chammas

@Phil More generally, why was anything forked from SO (including SF and SU)?

gbn

5:10 PM

@JNK i like @martinsmith comment. sqlpass bores me

Nick Chammas

3

A: Why is StackExchange split into multiple sites?

Well, the reputation is an indicator of "how much does this user participate here, on a site about x?" For example, if my reputation on SO is 10 thousand points, on MSO 400 points, on SF 2000 points, and 101 on Cooking and on Gaming alike, it gives you a meaningful view of how much I'm active: ...

there are a number of such questions on meta.so

Phil

I guess that makes sense. OTOH, it could have been achieved by having tag-based rep

Nick Chammas

Stack Overflow Blog: Why Can’t You Have Just One Site?

Posted by Jeff Atwood on July 26th, 2009

Now that we have four sites in the Stack Overflow trilogy:

Some users disagree with the idea that there should be four sites.

Why do we need the trilogy instead of just one site? Having four sites to jump between is ridiculous! Why not one Site? Trilogy Portal: Community Colloboration

Having four sites to jump between is ridiculous! Why not one Site? Trilogy Portal: Community Colloboration

Why not one Site? Trilogy Portal: Community Colloboration

Trilogy Portal: Community Colloboration

The whole point of these sites is to form a community around specific topics. There’s nothing more toxic to a …

@Phil @CadeRoux Per Jeff: "There is no (good) community that can form around “let’s just talk about everything and tag it”."

Phil

Yeah. I do agree that SO is a beast

Cade Roux

@jcolebrand So does it go to prove that all the talking about building systems doesn't actually build better systems?

gbn

5:13 PM

lordy, is there some law that describes every bugger asking the same shit over and over on forums. like godwins law say

jcolebrand

@gbn I thought it was Spolsky's law or something

Atwood's law is everything that can be built in javascript, will, iirc

Cade Roux

@gbn yes - all because someone moved a question I was in the middle of answering

gbn

nah, that's leaky abstractions

Mark Storey-Smith

@NickChammas That's a neat explanation if ever one was needed

Cade Roux

@jcolebrand So it's like a star chamger

@NickChammas There is no good cooking community where people aren't supposed to share recipes.

gbn

5:16 PM

@CadeRoux on the upside, you've found us here though

Cade Roux

@NickChammas Also, no good community where the first thing someone tells you is you need to go ask that question over here.

gbn

@CadeRoux is there a better community online for techies than here?

Cade Roux

@gbn I have no problem with questions being moved to DBA SE, but if you are going to move questions which I would not ask a DBA, but would ask an experienced database developer, then DBA needs a new name.

gbn

@CadeRoux yes. indeed. ongoing.

Mark Storey-Smith

@CadeRoux That comes up now and again :)

gbn

5:19 PM

@CadeRoux you like "database monkeys"?

Mark Storey-Smith

@gbn I think you and I were the only ones in favour of that, unfortunately.

I'm (still) all over it

Data Apes was one of your other suggestions no?

Cade Roux

@gbn No, but there are better ones for cooking. And I would still not ask an algorithm or datastructure question at Programmers and I wouldn't ask a database question at DBA unless I would ask a DBA (backup, tuning, SAN, performance counters, replication, partitioning, ...)

gbn

"database great apes"

Cade Roux

@gbn those are the code monkeys that use NoSQL "databases"?

gbn

8

Q: "Database Administrators" needs to die

Every few weeks another sharp poster asks: Why are you asking DBAs about source control? Why are you asking DBAs about performance? Why are you asking DBAs about database design or data warehousing? As a regular DBA.SE patron your response might be: "Because all of those topics are welcome on...

discussion site-definition

jcolebrand

5:24 PM

@CadeRoux We can't find a single good concise name that covers what we want to do here. Advanced Database Programmers and Analysts and their Tools.

That's just too long.

Phil

I like it here. You lot are friendly

5

jcolebrand

@Phil most dba's are, if you get past the billy goat gruff exterior ;-)

Mark Storey-Smith

@jcolebrand ahem not all of us here are DBA folk! ;)

gbn

@Phil we aren't your dbas though...

jcolebrand

@MarkStoreySmith I know, I'm a senior dev

@gbn hahahahahahahahahaha

Phil

5:28 PM

My job title is "Senior Hibernate Denouncer"

Mark Storey-Smith

@Phil Don't knock ORMs, they keep data apes in bananas.

ConcernedOfTunbridgeWells

@MarkStoreySmith As do hypervisors and SANs.

Mark Storey-Smith

True true.

ConcernedOfTunbridgeWells

Perhaps "SQL Simians?" or has that already been done?

Phil

Hehe

Right, time for a pint or 5. Cya ;)

jcolebrand

5:33 PM

@ConcernedOfTunbridgeWells not enough BI

ConcernedOfTunbridgeWells

@jcolebrand OLAP Orangutans?

gbn

@Phil ciao

jcolebrand

I'm gone to lunch you lot

ttyl

Mark Storey-Smith

@Phil Likewise. Cheerio chaps

gbn

bye

Iain

5:41 PM

@gbn all yours

Nick Chammas

@CadeRoux Much to my ire, the name "Database Administrators" leads a lot of people like yourself to believe that we don't do database development, design, NoSQL, or anything that is not within the domain of a good sysadmin.

I'm primarily a database developer myself (though my title is "Database Administrator"), and we have a lot of devs, BI types, storage types, and the like who hang out here and ask and answer questions on the regular.

gbn

@Iain thanks

Iain

no trouble

Cade Roux

@NickChammas I've tried to hire DBAs before and had people come in who didn't know SQL - I used to call them "functional" DBAs.

2

Nick Chammas

@CadeRoux - gbn already linked you to the meta discussion summarizing my complaints against our name, and with the pending merger of BI into our site, the name change will have to happen.

@CadeRoux Yes. Unfortunately, I hear that enough to believe it is a widespread phenomena (something @BenBrocka is skeptical of). A lot of techies have this very limited and, in my view, ugly idea of what a DBA is and does.

I'm sad to say that in some cases it may be accurate.

That's kind of DBA is not what we promote or attract here.

Ben Brocka

5:48 PM

interesting:

0

Q: I built a SQL version of JSFiddle - is it appropriate to update the SQL tag wiki?

I see that for the JavaScript tag, there is a suggestion that questioners use JSFiddle or JSBin as tools for formulating their question. I also see that currently, there is no equivalent suggestion for the SQL tag (presumably because there haven't been many equivalent options). I just built a s...

discussion tag-wiki

Cade Roux

@NickChammas I will contribute there. I tend to think data, in all its forms, is so integral to all software development that it belongs integrated with StackOverflow. And frankly, the functional DBA part might belong in ServerFault (which I do think probably has a place). One might ask if the need for a data-centric site is because StackOverflow is simply too large to manage?

Nick Chammas

5:58 PM

@CadeRoux Data is integral, but it also requires a different mindset than is appropriate for the rest of software development. There is enough depth to data architecture and development to merit a specialized site, and we are aiming to be the place to go to for database development, design, and administration, as well as the BI and systems fields that are closely tied to that.

@CadeRoux It may be true that developers suffer from database-ignorance and that silo-ing sites will shield them from information they would benefit from knowing. That needs to be solved by promoting this site on SO and raising awareness of what we do here. Also, we only encourage "expert" questions here, meaning basic questions of design and querying will always be appropriate and encouraged on SO by us.

Iain

6:29 PM

@gbn (or anyone who cares) do you want this serverfault.com/questions/354324/…

gbn

@Iain yeah, if you think it is databasey enough

Anyone else?

Iain

@gbn We have a mod flag asking for it to be pushed but I wouldn't know if it was advanced enough for you guys

gbn

6:49 PM

@Iain well, that's 2 of us then who say yes. Me and whoevere

Iain

have fun with it

gbn

cheers

DTest

8:44 PM

@jcolebrand just curious, why were my 2 name suggestions deleted by you on meta.dba.stackexchange.com/questions/270/… ?

jcolebrand

9:45 PM

@DTest because at the time I was trying to clean up many answers to reduce the field and get more responses.

there's a lot of them on there

DTest

10:01 PM

@jcolebrand hmm, makes sense. Just saw only mine were deleted, but I don't think i can see others' deleted posts anyway :)

question is...how many votes on an answer is it going to take to make the change happen

Ben Brocka

10:54 PM

Huh, only two of the starred messages involve "php monkey" today. Must be a slow day

2

@Iain didn't we have one just like that where someone wanted to use more memory to decrease cpu load?

can't find it.

Iain

@BenBrocka I don't know this is very out of my comfort zone ~ I'm a sysadmin ;)

Ben Brocka

11:20 PM

@Iain I was referring to the question not you :) there was a question about trying to use more resources to speed up queries that we had before...

Nevermind! I was thinking of this question, where the bottleneck was probably I/O not CPU

4

Q: How can I make my SSIS process consume more resources and run faster?

I have a daily ETL process in SSIS that builds my warehouse so we can provide day-over-day reports. I have two servers - one for SSIS and the other for the SQL Server Database. The SSIS server (SSIS-Server01) is an 8CPU, 32GB RAM box. The SQL Server database (DB-Server) is another8CPU, 32GB ...

sql-server sql-server-2008-r2 data-warehouse ssis etl

Transcript for

The Heap™ – Consultancy ©®