Viewing 15 posts - 166 through 180 (of 22,219 total)
So anyone got suggestions on things to do in Seattle in two weeks, after the Summit is done for the day, for someone who won't have 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
October 21, 2024 at 2:31 pm
So anyone got suggestions on things to do in Seattle in two weeks, after the Summit is done for the day, for someone who won't have a rental car?
Go...
"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
October 21, 2024 at 2:19 pm
FWIW : Scientists are currently busy recreating tissues or animals that have been extinct for millions of years. Perhaps that will be the fate for relational DBA and this...
"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
October 21, 2024 at 1:37 pm
We're not dinosaurs! I saw a Star Trek movie (from the 23rd century mind you) where Spock said that a SQL injection attack was used to do nefarious stuff. ...
"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
October 21, 2024 at 1:36 pm
Thanks everyone for the feedback. Sorry for the late reply, I've been visiting Persian War battlefields in Greece the last couple of days (I love my job, yes, I'm in...
"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
October 20, 2024 at 4:20 am
There are lists of exceptions to this as long as... well, very long. However, as a general rule, pick the clustered index based on the most frequently used path to...
"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
October 15, 2024 at 3:44 pm
There isn't a single true path through this.
Generally, a database gets one storage location. Depending on the tools I'm using (I work for Redgate, so Flyway is the tool of...
"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
October 15, 2024 at 3:41 pm
That's what I get for not using the GUI for backups.
"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
October 14, 2024 at 7:24 pm
This occurs when the logins have different IDs between servers. Here's an article that discusses dealing with this.
"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
October 14, 2024 at 12:48 pm
I'm not sure why it went wonky Rod. A restore of a full backup shouldn't be doing tail log backups, successful or otherwise. Something odd going on. Did you 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
October 14, 2024 at 12:46 pm
I've always found attending conferences to be valuable. I've learned lots at the conferences I've attended and have made life-long friends.
Which is why it is strange that...
"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
October 8, 2024 at 8:24 am
I've always found attending conferences to be valuable. I've learned lots at the conferences I've attended and have made life-long friends.
Which is why it is strange that my current...
"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
October 7, 2024 at 7:07 am
In my 42 years in IT with most of it as a DBA I never got to go to a conference. The closest was a very few meetings with...
"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
October 7, 2024 at 7:07 am
Being an introvert at a conference is exhausting. Utterly and completely.
And totally worth it.
No one believes me when I say I'm an introvert because I'm always up on stage, running...
"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
October 7, 2024 at 7:05 am
Johan, did you try doing sni_trace? That is an event, in the debug channel. I guess I somehow missed that on the first read through.
I don't have the setup handy...
"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
October 3, 2024 at 12:26 pm
Viewing 15 posts - 166 through 180 (of 22,219 total)