Viewing 15 posts - 496 through 510 (of 59,078 total)
You're not going to use this data as points in time, but as intervals, so model it that way
Create table events (event_number integer not null primary key, event_start_timestamp dateime2(0)...
June 28, 2024 at 7:25 pm
Never mind. AI lied to me.
{sarcasm on}
WHAT??? AI LIED??? Surely, you jest! It's going to take over all our jobs, right? RIGHT? 😉
{sarcasm off (for the moment)}
June 27, 2024 at 7:37 pm
If you use FORMAT anyplace where there are a lot of rows, I can only wish you luck for performance because you're going to need it.
June 27, 2024 at 7:33 pm
Thank you, Jeff. That would only require installing Office, or at least Excel, on the server, correct? I could document which version of Excel is used.
No, this is...
June 27, 2024 at 7:31 pm
Thank you, Jeff. That would only require installing Office, or at least Excel, on the server, correct? I could document which version of Excel is used.
No. Absolutely not. It...
June 27, 2024 at 7:22 pm
I don't know if it would be possible to write reports using Jupyter Notebooks, that would be canned reports accepting only parameters, such as start and end dates....
June 26, 2024 at 5:53 pm
I'm confused.... the log file name of your latest graphic doesn't appear to match or relate to any database names in your first graphic. You've also not said anything about...
June 25, 2024 at 10:12 pm
Please see the article at the first link in my signature line below. Most of us like to test our answers before we publish them. For that, we need "Readily...
June 25, 2024 at 4:30 am
Only 17 responses on Steve Rezhener's thread. I'm not sure that I'd consider that to be a viable source of information considering the previous and expected attendance for these types...
June 24, 2024 at 1:16 am
I don't believe such an alert exists. My recommendation would be to make an SQL Server Agent Job that checks for such things and schedule it to run on a...
June 23, 2024 at 4:12 pm
To be honest, I've found that most such contention is because of what is appropriately referred to as "crap code". 😉
I recommend that you figure out what's beating on TempDB...
June 23, 2024 at 4:05 pm
Post the CREATE TABLE statement for the table the index is a part of including the CREATE statements for the index(es) in quesiton. Then, post the results of a...
June 23, 2024 at 1:13 am
I am attaching the index data collection file. See if you infer any useful information.
Ok then, this will be short.
The code says it ignores UNIQUE indexes. Your spreadsheet says...
June 23, 2024 at 1:07 am
Hi All,
We have a 2 TB disk to stored of the sql database files. db has 3 data files and 1 log file. log file is stored on a...
June 20, 2024 at 4:06 pm
Hey there, Sam...
I took a look at your index spreadsheet. That's a good thing but it's missing some critical information...
June 20, 2024 at 3:36 pm
Viewing 15 posts - 496 through 510 (of 59,078 total)