Viewing 15 posts - 4,006 through 4,020 (of 59,067 total)
Thank you both.
The product is good, but it is expensive. Not sure if we can get approval to have budget for that.
Any other recommendations?
Thanks
It'll be cheaper that writing your...
January 26, 2022 at 9:57 pm
You're going to have to write some code that checks sys.tables for names using wild cards and check their "create_date" for the date and time they were created. If that...
January 26, 2022 at 9:54 pm
If, however, it's ALWAYS in the proverbial toilet, THAT can be an indication of a much larger problem.
It may not actually show up as "spills", either.
January 26, 2022 at 9:41 pm
A cte query which joins couple of tables and then updates is in suspended state. Is it possible it is blocking itself?
SP who is active shows NULL in the...
January 26, 2022 at 9:39 pm
It doesn't matter if the 'on' is followed by 'on' or 'off', just add up all the 'on' times.
It actually does matter because two on times without an off...
January 25, 2022 at 11:39 pm
From the Article:
"Without a baseline, every issue encountered could be considered normal and therefore not require any additional intervention."
Another way to look at it is "Without a baseline, every non-issue...
January 25, 2022 at 7:33 pm
what is the impact of too many .ldf''s in a database?
To be honest, there's no impact other than maybe on your reputation if someone else finds out... that's also...
January 25, 2022 at 7:18 pm
Such workarounds are absolutely stupid. Not because the workaround itself is stupid but, rather, because Microsoft has made such a workaround NECESSARY. .......
F@#$%NG EPIC!
BWAAAAA-HAAAA!!! At least I know...
January 25, 2022 at 6:55 pm
Before you go rebuilding the table to recover the space, at least find out why there's so much unused space in the table. Is it due to forwarded rows or...
January 25, 2022 at 6:46 pm
Thanks for your response Jeff. Glad to see you are still going strong. I will have a play. Keep up the great work.
Kind Regards,
Phil.
It's been a while since I've...
January 25, 2022 at 6:41 pm
... Using end of month dates is actually a WORST PRACTICE! ...
I agree with a lot of what you said Jeff, but I can't agree here. I've...
January 25, 2022 at 6:39 pm
Again... if you post some sample data in a readily consumable format, we can help a whole lot more. See the first link in my signature line below for one...
January 25, 2022 at 6:34 pm
I have gone through the two parts of Jeff's articles. But I still couldn't figure out the solution. here's my sample data:
businessday category itemno value
2022-01-01 xyz...
January 25, 2022 at 1:47 pm
Thank you for your replies.
I added: CAST(FileSize AS decimal(35,2)) AS FileSize,
+
WHERE Domain = @Domain AND convert(bigint, Filesize) > 50000
That worked so many thanks.
One last question...
--I added
ROUND(SUM(CAST([FileSize]...
January 25, 2022 at 1:23 pm
Hi All ,
I need to restore database 1.2 TB .. bak files are on network share drive .
the time i run restore .. it shows no progress . Status...
January 24, 2022 at 11:16 pm
Viewing 15 posts - 4,006 through 4,020 (of 59,067 total)