Jack Corbett

Forum Replies Created

Viewing 15 posts - 1,201 through 1,215 (of 9,643 total)

RE: Are the posted questions getting worse?

Grant Fritchey (10/1/2013)
Please. For purposes of employment, some of us cannot comment on politics because no matter what side I argue for, I'll yack off a customer or six. Can...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

October 1, 2013 at 7:00 am

#1654876
RE: Are the posted questions getting worse?

jasona.work (10/1/2013)
Well, should be a rather interesting next couple days / weeks / (REALLY hope not) months with the US Government going into shutdown.
As some of you know, I'm now...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

October 1, 2013 at 6:56 am

#1654874
RE: Are the posted questions getting worse?

GilaMonster (9/27/2013)
Thursday at Summit is going to be sooo funny. Just saying...
Okay, I need some more info on this one. I don't see anything on the schedule that funny...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

September 30, 2013 at 6:59 am

#1654536
RE: Are the posted questions getting worse?

Lynn Pettis (9/29/2013)
I am officially a grandfather, again. Kassondra gave birth to her second son, Branson James on 9/28 @ 6:19 PM MDT!
Congrats grampa! I'm hoping I'm at...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

September 30, 2013 at 6:51 am

#1654524
RE: Are the posted questions getting worse?

Jeff Moden (9/28/2013)
GilaMonster (9/28/2013)
Jeff Moden (9/27/2013)
Speaking of "Are the posted questions getting worse"?... I was going through some old responses to some posts and I came across this one that...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

September 30, 2013 at 6:48 am

#1654522
RE: Query Issue

The problem is that you are declaring your variables outside the dynamic sql. sp_executesql changes the execution context so variables declared outside the sql string are not available...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

September 25, 2013 at 2:13 pm

#1653349
RE: Are the posted questions getting worse?

GilaMonster (9/25/2013)
Someone want to add a voice of reason to this?
http://www.sqlservercentral.com/Forums/Topic1493948-391-1.aspx
I'd try but that tempDB thread has worn me out.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

September 25, 2013 at 1:55 pm

#1653345
RE: Force T-SQL Job Step to Run Under Specific SQL Account

Nope, T-SQL job steps can't use proxies but they can use RUN AS which, if I understand correctly, uses EXECUTE AS in the background, so the user has to exist...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

September 25, 2013 at 10:34 am

#1653265
RE: Tempdb data file fills up very often

AlexMcCo (9/25/2013)
You do not need tempdb ndf file as large as you can make them. It is more than enough to put as 50 mb each. They will expand as...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

September 25, 2013 at 8:35 am

#1653199
RE: Force T-SQL Job Step to Run Under Specific SQL Account

You can specifiy the user the job step should run as, http://technet.microsoft.com/en-us/library/ms187358(v=sql.105).aspx
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

September 25, 2013 at 7:28 am

#1653146
RE: SQL Azure install on linux 32 bit.

SQL Azure is not something you install, it is a cloud service offered by Microsoft, so you can access it from Linux since it is a cloud-service.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

September 25, 2013 at 7:23 am

#1653144
RE: A severe error occurred on the current command

JediSQL (9/24/2013)
A major problem with dbmail is that you cannot specify the From address at run time; you have to set up a different profile for every From address you...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

September 25, 2013 at 7:06 am

#1653131
RE: ssis vs jobs

To me it sounds like a process that should use SSIS since SSIS is an ETL tool. I guess it could use BCP, but you mention that it "transforms"...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

September 25, 2013 at 6:51 am

#1653115
RE: SQL cluster installation failed with below error

Looks like this isn't an uncommon problem. Here are a couple of links to go through that might help:
http://sql.nconsulting.net/2012/10/installation-error-mof-compiler-could.html#.UkLaLtXD-Hs
http://connect.microsoft.com/SQLServer/feedback/details/356258/the-mof-compiler-could-not-connect-with-the-wmi-server
http://connect.microsoft.com/SQLServer/feedback/details/357003/the-mof-compiler-could-not-connect-with-the-wmi-server
Please note I have not experienced this issue, but these links...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

September 25, 2013 at 6:47 am

#1653111
RE: Tempdb data file fills up very often

Angeltica (9/24/2013)
Microsoft recommend unlimited growth for temp databases.
Initial size should be 50 MB for all temp dbs with 500MB file growth with unlimited Max Growth. hope it helps
This is totally...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

September 24, 2013 at 9:21 am

#1652804

Viewing 15 posts - 1,201 through 1,215 (of 9,643 total)