Viewing 15 posts - 8,806 through 8,820 (of 59,078 total)
The optimizer may be deciding to ignore the index because of the SELECT * because it may be figuring that it's cheaper to do an index scan rather than do...
August 15, 2019 at 2:41 pm
First of all, there are a couple of good articles (I don't have the links handy just now) that demonstrate that a 25% sample rate takes about as long as...
August 15, 2019 at 2:25 pm
i dont think there is any issue with the script as it works fine from SSMS but it does not work from SQL Agent job though it backups only...
August 14, 2019 at 7:11 pm
I find it humorous that, for someone who argued so strongly against Hungarian notation on another thread, this object names starts with "fn". 🙂
Heh... I did explain that in...
August 14, 2019 at 5:28 pm
SQL and HTML/JavaScript are two sides of the same coin. Both languages are easily accessible but broadly misused. Most complaints about "limitations" are actually founded on misconceptions about how...
August 14, 2019 at 4:23 pm
Speaking of website issues, is the bug where you have to unsubscribe from email notifications to a topic every time you reply going to be fixed?
I personally...
August 14, 2019 at 4:21 pm
lol, I'm not even going to try. I almost always miss the Python and R questions. lol
Heh... ditto that. My "correct" answer would be "Why are you doing this...
August 14, 2019 at 4:20 pm
Hi Jonanthan,
No we cannot set it to SQL-2008 as a company standard
You need to read some of the articles at the Google link I posted. You don't need to...
August 14, 2019 at 3:04 pm
This reminds me of discussions on "NULLs".
August 14, 2019 at 3:00 pm
Yes please!
This forum is really quiet now. I know...
August 14, 2019 at 2:58 pm
Some things are much better on the new site. The ability to paste in SQL code without it reformatting it is really good.
That has been a blessing. The ability...
August 14, 2019 at 2:52 pm
Speaking of website issues, is the bug where you have to unsubscribe from email notifications to a topic every time you reply going to be fixed?
I personally don't consider...
August 14, 2019 at 2:50 pm
Perhaps it's the following problem. It was for us.
https://www.google.com/search?q=trace+flag+cardinality+estimator
August 14, 2019 at 2:55 am
I am also amazed at the volume of folks who overuse recursive CTEs. It almost seems that they go out of their way to use them!
They do go...
August 14, 2019 at 1:48 am
Viewing 15 posts - 8,806 through 8,820 (of 59,078 total)