Are the posted questions getting worse?
-
Grant Fritchey (4/7/2016)
SQLRNNR (4/7/2016)
Grant Fritchey (4/7/2016)
I'm wrestling with an Octopus.How are you faring against all of those arms?
Winning!
Woot
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
TomThomson (4/7/2016)
ChrisM@Work (4/6/2016)
Crowdie's very easy to make, Tom - and tastes wonderful when it's freshly made. Ullapool, camping, many years ago; I watched the crofter's wife make it."Crowdie" is ambiguous; I could have beem less amiguous by using a gaelic word (but even then not 100% unambiguous, as usage varies from place to place). The version (stapag) which is oatmeal stirred into cream or milk or water or any combination of some/all of them is indeed easy. The version (gruitheam) which is curds (whey-less - all whey pressed out) mixed with an equal quantity of freshly made butter may be easy if you have access to fresh curds and freshly made butter, but if it involves starting from new milk and generating the whey-less curds and the butter and then mixing them that's not easy.
Good Lord Tom you're a walking Wiki. It's the latter stuff I watched being made. I always missed the part the day before when rennet was added to whole fresh milk, only seeing the product flopping out of a tied-up muslin sheet the next morning. I also don't recall fresh butter being added - this was nearly fifty years ago after all - but I'm sure you're right as the flavour and texture were different to plain curds, less tart and more creamy and a different, pellety structure. It's a very long time since I gave up buying Crowdie, it was always cottage cheese with a different label.
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden -
SQLRNNR (4/6/2016)
Brandie Tarvin (4/6/2016)
Folks, we have someone who is deliberately trying to force a deadlock to test some stuff. Can anyone give him advice on how he might do that?Dang it - too late to that party.
I have 3 different routines that guarantee a deadlock. Grant gave him something works great. Plus he was able to repro his deadlock in test - which is great news.
All you need is Navision and you can find plenty of code that generates deadlocks.:-D
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 -
Jack Corbett (4/7/2016)
SQLRNNR (4/6/2016)
Brandie Tarvin (4/6/2016)
Folks, we have someone who is deliberately trying to force a deadlock to test some stuff. Can anyone give him advice on how he might do that?Dang it - too late to that party.
I have 3 different routines that guarantee a deadlock. Grant gave him something works great. Plus he was able to repro his deadlock in test - which is great news.
All you need is Navision and you can find plenty of code that generates deadlocks.:-D
Websense is awesome for that and plenty more examples of performance tuning opportunities.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
SQLRNNR (4/7/2016)
Brandie Tarvin (4/7/2016)
Brandie Tarvin (4/7/2016)
SSIS is freaking out on me all of a sudden. I would appreciate help on this.NEVERMIND.
Stupid power users changing table definitions... grumble mumble curse.
I'd be grumbling that any user has the ability to change table definitions.
users are not masters of the universe and therefore should never have the power
It is a user database specifically built for this business area. Three people have db_owner and it's one of those "rogue unit" kind of things. They pretend their stuff is production level even though their dbs are in our QA environment. In this particular instance, we do have a feed that comes from an external vendor that they need to do their jobs. Someone changed things around in the database and caused the feed to break. So my boss, when he saw what was going on, decided to have a little conversation with the user in question.
Much steam coming out of our office today.
-
Brandie Tarvin (4/7/2016)
SQLRNNR (4/7/2016)
Brandie Tarvin (4/7/2016)
Brandie Tarvin (4/7/2016)
SSIS is freaking out on me all of a sudden. I would appreciate help on this.NEVERMIND.
Stupid power users changing table definitions... grumble mumble curse.
I'd be grumbling that any user has the ability to change table definitions.
users are not masters of the universe and therefore should never have the power
It is a user database specifically built for this business area. Three people have db_owner and it's one of those "rogue unit" kind of things. They pretend their stuff is production level even though their dbs are in our QA environment. In this particular instance, we do have a feed that comes from an external vendor that they need to do their jobs. Someone changed things around in the database and caused the feed to break. So my boss, when he saw what was going on, decided to have a little conversation with the user in question.
Much steam coming out of our office today.
While it sounds like the environment is not ideal, at least they can't impact performance on your production server. 😉
Regarding the steam, it it nuclear-powered or just normal? You may need to watch out for melt downs.
-
Ed Wagner (4/7/2016)
Brandie Tarvin (4/7/2016)
SQLRNNR (4/7/2016)
Brandie Tarvin (4/7/2016)
Brandie Tarvin (4/7/2016)
SSIS is freaking out on me all of a sudden. I would appreciate help on this.NEVERMIND.
Stupid power users changing table definitions... grumble mumble curse.
I'd be grumbling that any user has the ability to change table definitions.
users are not masters of the universe and therefore should never have the power
It is a user database specifically built for this business area. Three people have db_owner and it's one of those "rogue unit" kind of things. They pretend their stuff is production level even though their dbs are in our QA environment. In this particular instance, we do have a feed that comes from an external vendor that they need to do their jobs. Someone changed things around in the database and caused the feed to break. So my boss, when he saw what was going on, decided to have a little conversation with the user in question.
Much steam coming out of our office today.
While it sounds like the environment is not ideal, at least they can't impact performance on your production server. 😉
Regarding the steam, it it nuclear-powered or just normal? You may need to watch out for melt downs.
Depends if it is light-water reactor or a LMS reactor. The latter will fail safe instead of melting down.
-
Chocolatey is amazing. If you haven't tried it, I recommend it. I've used it more and more, grabbing software as I need it rather than trying to get things setup on a new machine.
-
Would anyone find an article on Azure's SQL elastic pools worth reading? More on the basic setup and screen navigation? Just to understand where you would add a DB, change DTUs etc?
thoughts?
-
Jack Corbett (4/7/2016)
SQLRNNR (4/6/2016)
Brandie Tarvin (4/6/2016)
Folks, we have someone who is deliberately trying to force a deadlock to test some stuff. Can anyone give him advice on how he might do that?Dang it - too late to that party.
I have 3 different routines that guarantee a deadlock. Grant gave him something works great. Plus he was able to repro his deadlock in test - which is great news.
All you need is Navision and you can find plenty of code that generates deadlocks.:-D
If you want some deadlocks, the system I'm currently fixing generates about 200/hour. On a 30GB DB. With ~25 concurrent users.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
They pretend their stuff is production level
Aww :-D.
-
Steve Jones - SSC Editor (4/7/2016)
Chocolatey is amazing. If you haven't tried it, I recommend it. I've used it more and more, grabbing software as I need it rather than trying to get things setup on a new machine.Hey thanks for the link Steve!
I'm far from a Linux expert but I always loved using apt-get on Ubuntu.
SELECT quote FROM brain WHERE original = 1
0 rows returned -
Anyone have any insight on SQL 2012 jobs failing due to SSIS access denied problems?
We've been working on this for almost 8 hours now and we've started to repeat our efforts.
-
BL0B_EATER (4/8/2016)
Would anyone find an article on Azure's SQL elastic pools worth reading? More on the basic setup and screen navigation? Just to understand where you would add a DB, change DTUs etc?thoughts?
Yes
-
Brandie Tarvin (4/8/2016)
Anyone have any insight on SQL 2012 jobs failing due to SSIS access denied problems?We've been working on this for almost 8 hours now and we've started to repeat our efforts.
Make sure that you have the latest SP and CU installed. 2012 had a few "regression" problems along the way.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 15 posts - 53,461 through 53,475 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply