Viewing 15 posts - 7,951 through 7,965 (of 59,072 total)
Yo, Jeff --
So, here's a detail...
When I compile my sp's, in 'my database', with EXECUTE AS OWNER it's fine, but now there are problems in the production db. The...
January 5, 2020 at 7:07 pm
One of the greatest values of commenting is to answer the proverbial 'What was I thinking ?' question.
Heh... spot on. I use comments for the following...
January 5, 2020 at 5:46 pm
I recently experimented with MAXDOP using a pretty huge statement. Here is a summary of the results:
MAXDOP = 0. CPU = 36790 ms, elapsed = 12838 ms.
MAXDOP = 1....
January 4, 2020 at 1:05 am
They claim to have been able to get queries down from hours to seconds by doing this.
I've seen a lot of strange claims and they normally turn out to...
January 4, 2020 at 12:51 am
(although I know where you can get even better than native compression <cough> Redgate </cough>)
Sounds like the making of an article, Grant. A comparison using the same database...
January 4, 2020 at 12:03 am
p.s. If your indexes are random GUID based, you MUST stop using REORGANIZE on them. REORGANIZE does not work the way most people think it does, especially when it comes...
January 3, 2020 at 11:39 pm
I wouldn't change fill factor setting on Instance Level, and its not recommended. It might worsen your performance, so be careful in with this setting.
Now with Fill factor on...
January 3, 2020 at 11:34 pm
I think we need clarification on what the desired output of this query is. To me, the whole Quaters table seems unnecessary if all you are returning in your...
January 3, 2020 at 11:13 pm
Unless you're using TDE then compression prior to 2016 can be bad. ( or so I've read, I don't care to tempt it myself )
Just to give you some...
January 3, 2020 at 8:31 pm
Is there any way to tweak the following query? Thanks
; WITH CTE AS
(
SELECT DATEPART(QUARTER, GETDATE()) as 'Quarter', DATEPART(YEAR, GETDATE()) as 'Year'
)
select Quarter,Year from CTE where Quarter...
January 3, 2020 at 8:01 pm
Vendors are a huge problem in patching. I'd like to see contracts explicitly state they'll certify within xx months, with xx being < 3.
That's not easy to do. Look...
January 3, 2020 at 7:44 pm
I just expect minimal polite behavior from people that post. And I do not suffer, rude, lazy people easily.
To be honest, it's ironic that you would post such a...
January 3, 2020 at 7:39 pm
Yes it's very clear the backup system is flawed but unfortunately our IT is outsourced and that was all I was given and have access to. I've requested a...
January 3, 2020 at 3:18 pm
p.s. And, yeah... it even works with refreshable spreadsheets that call stored procedures. As you know, the spreadsheets should absolutely be calling stored procedures so that you're not chasing down...
January 3, 2020 at 3:36 am
Thanks, Richard. It's only because I have a long beard and that it took me 30 years of answering questions on forums to get there. 😀
To be honest, I don't...
January 3, 2020 at 3:32 am
Viewing 15 posts - 7,951 through 7,965 (of 59,072 total)