Viewing 15 posts - 391 through 405 (of 22,227 total)
The default value was set in 1998 on SQL Server 7. It's utterly and completely out of date. It bears no relation to the modern world. It should be a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 27, 2023 at 12:33 pm
The default value was set in 1998 on SQL Server 7. It's utterly and completely out of date. It bears no relation to the modern world. It should be a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 27, 2023 at 12:33 pm
It's another day when I think SQL Server Central must have been spying on us, producing such on-topic editorials, as here I am, old enough to claim my UK...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 25, 2023 at 1:45 pm
To summarize, if you (again, used figuratively an not pointed at anyone in particular) really want to learn something new, learn what you've been missing in SQL for the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 25, 2023 at 1:44 pm
If you want to have a life, find a new career outside of IT. Find a role that uses the technology skills you have in a privately held company...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 25, 2023 at 1:40 pm
Grant, thank you for the gentle reminder, but I fear that my response is not what I would have hoped and expected of myself. I have become acutely aware...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 25, 2023 at 1:38 pm
Hey Jeff,
I was talking to Bob Ward about your tests. He was interested in an introduction to talk about them. Any interest? If so, which email should I...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 16, 2023 at 4:38 pm
Hey Jeff,
I was talking to Bob Ward about your tests. He was interested in an introduction to talk about them. Any interest? If so, which email should...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 15, 2023 at 10:14 am
Hey Jeff,
I was talking to Bob Ward about your tests. He was interested in an introduction to talk about them. Any interest? If so, which email should I use?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 14, 2023 at 1:20 pm
The reason I can think about the posts are because of may Accidental DBAs who are forced to do the DBA job who are Developers, Network admins, I also...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 5, 2023 at 5:56 pm
Thanks for the comments. Sorry I haven't gotten back. I was on vacation.
And yeah, I'm assuming a bug-in scenario more than a but-out one. However, set for both if necessary.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 5, 2023 at 12:33 pm
Hey Brandy,
Another vote for getting them to go with read_uncommitted. When they realize they've dug a hole, let 'em out easy.
And welcome back!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 23, 2023 at 2:35 pm
Here you go. You can see the allocated & unallocated space.
Frequently, log growth is because you either don't have log backups enabled while in full recovery, or you don't...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 23, 2023 at 12:13 pm
Once a file size is allocated within SQL Server, it stays allocated. You can delete every bit of data from a 5tb data file, and the data file will still...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 23, 2023 at 12:08 pm
I made a boo boo and reported a wrong post.
Steve/Grant/Webmaster - could you please reinstate post 4268917 on this thread?
https://www.sqlservercentral.com/forums/topic/logical-consistency-based-i-o-error-for-tempdb-ndf
Thanks muchly
Done!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 23, 2023 at 11:54 am
Viewing 15 posts - 391 through 405 (of 22,227 total)