Viewing 15 posts - 2,551 through 2,565 (of 22,224 total)
I just presented a new session on SQL Injection at Techorama in Belgium and before that at SQLDay in Poland. As part of the prep, I did searches on recent...
"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
May 24, 2019 at 1:08 pm
I started watching a YouTube video on Azure DevOps. I can't have the sound turned up where I am, so I turned on subtitles. This is as far as...
"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
May 24, 2019 at 1:04 pm
Ha! Yeah, that kind of thing happens to all of us. Random mouse click, sunspots, it happens.
"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
May 22, 2019 at 8:58 am
Oh, and here's another video on waits and queries.
"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
May 21, 2019 at 3:14 pm
Honestly, the best resource is the query performance tuning book in my signature. It's completely focused on what you need.
However, to get started with extended events, start with Microsoft. "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 21, 2019 at 3:12 pm
Well, then it won't matter. If the data will ALWAYS be less than 50 characters then indexing a VARCHAR(50) or a VARCHAR(500) will be the same. It's completely dependent on...
"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
May 21, 2019 at 3:03 pm
Killing SPIDs just puts them into rollback, same as this. I'd be more concerned about what's happening, what has changed, what's new that something that has ran for years without...
"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
May 21, 2019 at 2:59 pm
Well, the "regardless of who is connected" bit is what you've run into. There was some sort of open transaction and it got rolled back successfully. I'd just suggest changing...
"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
May 21, 2019 at 11:17 am
That's an error from taking a database into single user mode. That shouldn't normally be a part of a restore process unless people on your server have too many permissions...
"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
May 21, 2019 at 3:57 am
This is a very old school (and old) summary of the rules of normalization, with examples. The core concept is, a column or columns has to define what makes...
"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
May 21, 2019 at 3:52 am
Also, there is a 900 byte max key length that you have to stay within.
The simple fact is, it's going to be harder to index 500 characters than 50 because...
"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
May 21, 2019 at 3:44 am
The single best method is to use Extended Events to capture the call. You can get a general set of data through rpc_completed or sql_batch_completed, or you can get individual...
"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
May 21, 2019 at 3:40 am
You've been given a gift... when most folks write a presentation, they practice it at say 20 minutes but they've included so much good stuff that it will actually...
"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
May 20, 2019 at 2:22 pm
You've been given a gift... when most folks write a presentation, they practice it at say 20 minutes but they've included so much good stuff that it will actually...
"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
May 20, 2019 at 2:21 pm
Alright, Threadzians. Who's responsible for this one? https://www.zdnet.com/article/faulty-database-script-brings-salesforce-to-its-knees/ Seriously. What were they thinking and why didn't they test this first?
Cause the vast majority of people out there are...
"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
May 20, 2019 at 2:18 pm
Viewing 15 posts - 2,551 through 2,565 (of 22,224 total)