Viewing 15 posts - 5,461 through 5,475 (of 59,068 total)
I firmly believe there is danger in the 'cookie-cutter' approach to systems which depend far too much on distant developers instead of hands-on awareness.
Heh... preach it, Brother!
Is it...
March 22, 2021 at 2:59 pm
I don't understand why you people are complaining about the lack of automated DB tuning.
You've been given Auto Index Tuning - don't you have enough of it?
Want more?
Heh... in...
March 22, 2021 at 2:41 pm
This is one of those places where the first step should have been an online search for "sp_spaceused" to find the documentation on the subject. It's pretty explicit about having...
March 22, 2021 at 2:35 pm
To be honest, I don't want anymore "help" from MS in managing databases. For example, their insistence on permanently implementing the equivalent of TF11117 on TempDB with no way to...
March 21, 2021 at 9:00 pm
What's the best way to know which index statistics need to be updated on a daily basis? I currently update stats on Friday, but I've noticed SQL is updating...
March 19, 2021 at 12:39 pm
Thanks.
I want the user to be able to insert, amend and delete records within tables, but not to be allowed to create or delete any tables.
How do I achieve...
March 18, 2021 at 6:09 pm
There are a few things wrong with you query. You need to use queryout to get that to work, but remember, that xp_CmdShell is actually shelling out to a...
March 18, 2021 at 3:29 pm
The SQL would look like the following... 😀
WITH ctePreAgg AS
(--==== Pre-aggregate the relevant columns to make display easier.
SELECT DBName ...
March 17, 2021 at 9:27 pm
There are several different "broad categories" of real snowflakes. From what I've seen, each shop really is unique even if they fit one of the broad categories. To wit, I...
March 17, 2021 at 2:23 am
One advantage of virtual meetings would be, if permissible, for us this side of the pond attending. Would love to see you presenting Jeff 🙂
Lordy... I'm sorry, David... I...
March 16, 2021 at 2:17 am
That seems to have done the trick. Thanks!
Be careful of "the trick". I may be causing unnecessary rebuild of the clustered index and a wad of non-clustered indexes, to...
March 15, 2021 at 5:21 pm
No code can fix performance issues caused by faulty database design.
If you think otherwise - try to fix performance (and scalability) issues on msdb.
I'll be the first to agree...
March 15, 2021 at 2:44 pm
However, that's true only when returning the entire XML value. The query() method retrieves a subset of untyped XML from the target XML instance. location within the document, I...
March 15, 2021 at 6:23 am
Hello all,
Maybe this is my own ignorance showing, but I think I've hit a brick wall. I can't seem to bulk insert a dataset. I create a temp table...
March 15, 2021 at 1:18 am
Let try below 2017 version
I'm not sure I understand what you're saying. If you mean to try it on something less than 2017, then here's what you get...
Msg...
March 15, 2021 at 12:23 am
Viewing 15 posts - 5,461 through 5,475 (of 59,068 total)