Are the posted questions getting worse?
-
And now back to the non-technical portion of The Thread...
Has anyone had one of those days where you look at your inbox and you realize your entire day has been taken up by 20+ (sometimes 40+) replies back and forth on the same 2 email chains and the users STILL haven't answered your questions?
#headdesk
-
Brandie Tarvin (11/28/2012)
And now back to the non-technical portion of The Thread...Has anyone had one of those days where you look at your inbox and you realize your entire day has been taken up by 20+ (sometimes 40+) replies back and forth on the same 2 email chains and the users STILL haven't answered your questions?
#headdesk
Yep, that's usually when I resort to replying with a single question and repeating that reply until I get an answer, then moving on to the next question. Drives me crazy.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams -
One thing that's important to note is that the query processor is a pipeline. It does not execute each operator one by one on the entire resultset, so, in the absence of blocking operators (like hash joins, sorts and similar), some rows will already have been sent to the client before others have even been fetched from the index.
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 -
Revenant (11/28/2012)
For example - and it is one out of many -, when a result of an outer join is really big and the server runs out of disk space, the engine is expected to drop the rowset and terminate the query gracefully with an error message, and it apparently does, or the build would not pass.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
Koen Verbeeck (11/28/2012)
Revenant (11/28/2012)
For example - and it is one out of many -, when a result of an outer join is really big and the server runs out of disk space, the engine is expected to drop the rowset and terminate the query gracefully with an error message, and it apparently does, or the build would not pass.
Something like that. 😉
BTW, it takes 420 VMs over a week to run all tests on a candidate build.
-
At a SQL Server conference I was speaking at two weeks ago, I met one of the co-founders of lessthandot.com/[/url]. Later that day he asked me if I wanted to start blogging for LTD.
After some thinking I bit the bullet and started my own blog at LTD:
http://blogs.lessthandot.com/index.php?disp=authdir&author=940
I have currently the staggering amount of 2 blog posts :w00t: 😎
(and the first one is just a Hello blog post)
My first actual blog post is about SSIS & Excel - the horror - and someone already took advantage of it to advertise for their own ETL tool :angry:
Anyway, you can drop by if you like, I promise there will be more blog posts 😀
(unfortunately for most of you mostly about BI and SSIS :-P)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
Koen Verbeeck (11/28/2012)
At a SQL Server conference I was speaking at two weeks ago, I met one of the co-founders of lessthandot.com/[/url]. Later that day he asked me if I wanted to start blogging for LTD.After some thinking I bit the bullet and started my own blog at LTD:
http://blogs.lessthandot.com/index.php?disp=authdir&author=940
I have currently the staggering amount of 2 blog posts :w00t: 😎
(and the first one is just a Hello blog post)
My first actual blog post is about SSIS & Excel - the horror - and someone already took advantage of it to advertise for their own ETL tool :angry:
Anyway, you can drop by if you like, I promise there will be more blog posts 😀
(unfortunately for most of you mostly about BI and SSIS :-P)
Cool... we finally have an SSIS x-pert that can answer the questions on those forums here. Thanks for stepping up!
(Seriously... congrats. Now to go check out that blog.)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2 -
Koen Verbeeck (11/28/2012)
At a SQL Server conference I was speaking at two weeks ago, I met one of the co-founders of lessthandot.com/[/url]. Later that day he asked me if I wanted to start blogging for LTD.After some thinking I bit the bullet and started my own blog at LTD:
http://blogs.lessthandot.com/index.php?disp=authdir&author=940
I have currently the staggering amount of 2 blog posts :w00t: 😎
(and the first one is just a Hello blog post)
My first actual blog post is about SSIS & Excel - the horror - and someone already took advantage of it to advertise for their own ETL tool :angry:
Anyway, you can drop by if you like, I promise there will be more blog posts 😀
(unfortunately for most of you mostly about BI and SSIS :-P)
Congrats and Good Luck
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 -
Koen Verbeeck (11/28/2012)
At a SQL Server conference I was speaking at two weeks ago, I met one of the co-founders of lessthandot.com/[/url]. Later that day he asked me if I wanted to start blogging for LTD.After some thinking I bit the bullet and started my own blog at LTD:
http://blogs.lessthandot.com/index.php?disp=authdir&author=940
I have currently the staggering amount of 2 blog posts :w00t: 😎
(and the first one is just a Hello blog post)
My first actual blog post is about SSIS & Excel - the horror - and someone already took advantage of it to advertise for their own ETL tool :angry:
Anyway, you can drop by if you like, I promise there will be more blog posts 😀
(unfortunately for most of you mostly about BI and SSIS :-P)
Congrats! And very nice reply to the crazy advertiser 🙂
-- Gianluca Sartori
-
Hey, all. Anyone have any experience with MS Access applications (adps, etc.) that use SQL Server as a back end?
I have experience on the SQL side, but a lot of what this poster needs is help with the connection pooling on the program side / network sniffing / other things that my knowledge is vague on (that may be SQL related). And the way he's phrasing some of his answers makes me wonder if he's reading the entire post replies or just part of them (or maybe I'm just not able to understand his vagueness).
Anyway, help appreciated here: http://www.sqlservercentral.com/Forums/Topic1389436-391-1.aspx, please.
-
GilaMonster (11/28/2012)
One thing that's important to note is that the query processor is a pipeline. It does not execute each operator one by one on the entire resultset, so, in the absence of blocking operators (like hash joins, sorts and similar), some rows will already have been sent to the client before others have even been fetched from the index.That's good information to have. Thank you.
-
Brandie Tarvin (11/29/2012)
Hey, all. Anyone have any experience with MS Access applications (adps, etc.) that use SQL Server as a back end?None whatsoever, but I do know what error 10048 is and how it sometimes is fixed so I've thrown something into that topic.
I have experience on the SQL side, but a lot of what this poster needs is help with the connection pooling on the program side / network sniffing / other things that my knowledge is vague on (that may be SQL related). And the way he's phrasing some of his answers makes me wonder if he's reading the entire post replies or just part of them (or maybe I'm just not able to understand his vagueness).
Anyway, help appreciated here: http://www.sqlservercentral.com/Forums/Topic1389436-391-1.aspx, please.
Basically, I reckon he's doing no, or almost no, connection re-use within his app, and pushing connections up and down faster than teh server can cope with in its currect configuration. That's data comms stuff, there should be no need for an sql specialist to know anything about it. I'm happy if my suggestion is right, because it means there's still a niche for us unfashionable generalists sometimes.
Tom
-
L' Eomot Inversé (11/29/2012)
Basically, I reckon he's doing no, or almost no, connection re-use within his app, and pushing connections up and down faster than teh server can cope with in its currect configuration. That's data comms stuff, there should be no need for an sql specialist to know anything about it.That's my thought process, which is why I asked him about connection pooling, but neither he nor I know enough about the subject to discuss it accurately.
-
Koen Verbeeck (11/28/2012)
At a SQL Server conference I was speaking at two weeks ago, I met one of the co-founders of lessthandot.com/[/url]. Later that day he asked me if I wanted to start blogging for LTD.After some thinking I bit the bullet and started my own blog at LTD:
http://blogs.lessthandot.com/index.php?disp=authdir&author=940
I have currently the staggering amount of 2 blog posts :w00t: 😎
(and the first one is just a Hello blog post)
My first actual blog post is about SSIS & Excel - the horror - and someone already took advantage of it to advertise for their own ETL tool :angry:
Anyway, you can drop by if you like, I promise there will be more blog posts 😀
(unfortunately for most of you mostly about BI and SSIS :-P)
Good for you. If you want to syndicate here, send a note to the webmaster once you get 10 or so posts.
Viewing 15 posts - 38,341 through 38,355 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply