Are the posted questions getting worse?
- Lynn Pettis wrote:
Problem is that the person doing this doesn't care and doesn't test. He thinks he knows it all and doesn't listen to my recommendations when I can demonstrate that what he has done or written doesn't work well.
I've got an entire development department like that!
Yesterday, they delayed a release because they were getting timeouts during the load testing.
The proc was a simple upsert, although there was nothing in it to handle concurrency. If exists, insert, else update.
While this being called in the test, one of the QA people was running repeatedly SELECT * FROM against the table that the upsert proc was trying to insert/update.
Of course, I got the what's wrong, showed them, and showed them multiple ways to do this code differently to handle the concurrency. Backed it up with articles, facts, and test.
Nope. They said it would take too long. They stuck NOLOCK everywhere and moved on.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
So, I haven't been on the new site that much, which means I have no bugs to report. Not sure of that's a good thing or a bad thing. Just got bumped to a new Windows 10 box which apparently is even more hard to read (skinny fonts, no way to adjust colors / themes other than Dark and Light and neither theme helps my eyesight especially when I can't see the borders around toolbar buttons, website boxes, etc.) then my last Windows 10 box (not sure how that happened, maybe I was on an older Win10 Sp that didn't completely screw up cleartype).
Comparing this site to Windows 10 font / theme stupidity? This site wins hands down. I can read it!
On another note, I was chatting with someone recently about an interesting problem with High Availability. Guess what? High Availability isn't always available.
Did you know that if you have a situation where your DASD becomes unavailable / locked by a system SPID, you can't flip your HA group to one of the secondaries? System SPIDs can't be killed and server reboots won't help and if there was db corruption before the DASD lost its mind, that corruption promptly found its way over to the other nodes. Even if the HAG is asynch, it's likely the secondaries are all corrupted as well because it's possible the corruption went over before anyone noticed the problem.
Has anyone else run into a scenario like that?
I'm trying to set up virtual machines to game out all the possibilities of this issue, to find if there's a way around it other than "restore the database from backups." But given the course of our conversation, I'm not entirely certain there is another fix.
-
When looking at an old discussion I discovered a new problem with our shiny new site. Any quotations or remrks in any alphabet but standard W.European Latin alphabet are completely garbled, Greek and Russian come out as pure garbage. Has someone decided to restrict us to the usual North American 7-bit ascii character set? Or to the 8 bit ascii set, which allows us some characters allowing characters decorated with accents and umlauts and so on that occur in French, Spanish, German, Irish, Gàidhlig, Welsh, Portuguese, Norwegian and Danish and hordes of other languages using extended Latin alphabets instead of only English characters but still no non-latin characters - that would be slightly better than nothing, but would still exclude Kyrillic and Greek and Arabic and Hebrew characters and so on that we used to be able to use (or, in my case, just to read and in only two of those four, as I couldn't imaginably write anyting in any of them beyond perhaps "my aunt's cat has died" [??? ???? ???? ????? ??? is what the site now makes of me trying to type that in Russian, and I didn't hit the "?" key once]). There were several people a few years back who dropped bits of Greek and/or Russian into conversation (perhaps to see if anyone would notice what they said - the vast majority of SQLServerCentral's users don't want to know anything other than English).
Tom
- Thom A wrote:
Speaking of the QOTD, did the link in the Newsletter today lead to the actual QOTD for anyone today? My newsletter had:
What is the default memory limit that SQL Server on Linux will use? Think you know the answer? Click here, and find out if you are right.
but if you do "click here", you go to an article called "Data Compression Double Take". And if I go to the QOTD page it's yesterday's.
My newsletter did the same thing. QOTD page goes to yesterdays too.
Sue
- Sue_H wrote:Thom A wrote:
Speaking of the QOTD, did the link in the Newsletter today lead to the actual QOTD for anyone today? My newsletter had:
What is the default memory limit that SQL Server on Linux will use? Think you know the answer? Click here, and find out if you are right.
but if you do "click here", you go to an article called "Data Compression Double Take". And if I go to the QOTD page it's yesterday's.
My newsletter did the same thing. QOTD page goes to yesterdays too. Sue
I don't seem to get the newsletter anymore....
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/ -
If you are missing the newsletter, send a note to the webmaster. Likely something is broken, but we can tell you. Mostly we find that we moved services, so some people need to whitelist the same address since it's coming from a different place.
- Grant Fritchey wrote:
We all screw up at one time or another, just me more than most.
I believe that is called... experience.
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 -
Argh!!! Didn't have an email for the thread and the site search engine is so bloody awful it can't find it. I did happen to run across a blog post from Steve from 2009 (yes 10 years ago), referencing the thread.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/ -
Here is a testament to something. I released a web application used only internally in October of 2010. This is an HR thing used to capture annual reviews for the entire company. Traffic is not massive on this site for sure but is reasonably busy at least a couple times a year. I built some error handling into this system so that anytime an unhandled exception occurs the user is presented with a friendly "oh crap" type of page which allows them to enter some details about what they were doing, etc. It also of course logs the exception in a table and sends me an email. The log table simply uses an Identity as a primary key. In 9 1/2 years the number of exceptions just reached 1,000 a few minutes ago. That seems an extremely small number of unhandled exceptions for something running that long.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/ - WayneS wrote:Grant Fritchey wrote:
We all screw up at one time or another, just me more than most.
I believe that is called... experience.
I thought experience was the only difference between a pessimist and an optimist. 🙂
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/ - Sean Lange wrote:
Argh!!! Didn't have an email for the thread and the site search engine is so bloody awful it can't find it. I did happen to run across a blog post from Steve from 2009 (yes 10 years ago), referencing the thread.
But you found your way back, and that's the important thing. 😉
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
A mistake is only experience if you learn what went wrong and fix it so it doesn’t happen again.
Otherwise it is a random error.
- Sean Lange wrote:
Here is a testament to something. I released a web application used only internally in October of 2010. This is an HR thing used to capture annual reviews for the entire company. Traffic is not massive on this site for sure but is reasonably busy at least a couple times a year. I built some error handling into this system so that anytime an unhandled exception occurs the user is presented with a friendly "oh crap" type of page which allows them to enter some details about what they were doing, etc. It also of course logs the exception in a table and sends me an email. The log table simply uses an Identity as a primary key. In 9 1/2 years the number of exceptions just reached 1,000 a few minutes ago. That seems an extremely small number of unhandled exceptions for something running that long.
The Active Threads sub menu now orders the forum threads by the most recent reply, or how the link states, by topic freshness.
-
Anyone feel like they know a darned thing about merge replication? I've been asked to help with this, but I'm way out of date on my knowledge. Go here.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 63,331 through 63,345 (of 66,547 total)
You must be logged in to reply to this topic. Login to reply