Viewing 15 posts - 1,171 through 1,185 (of 22,224 total)
Just take up 3d printing and laser engraving. Then you can print parts for the radio and engrave all the parts. It's a never ending loop.
HA!
"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 28, 2021 at 6:29 pm
In addition to books, you might look above, on the menu bar at the top of this web site, at the Stairways series. They provide a lot of structured learning...
"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 28, 2021 at 12:57 pm
This isn't a bad place for those newly graduated... BUT
Only if they're working with the Microsoft Data Platform. We have some forums on other database systems and some on development,...
"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 28, 2021 at 12:55 pm
Or, look to Extended Events to capture each batch call or each procedure call. It's also possible to capture each statement for either of these, but that results in LOTS...
"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 28, 2021 at 12:49 pm
SQL Server is not open source, so you won't be able to get at the source code. That's a hard limit set by the use of the NVARCHAR data type....
"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, 2021 at 3:43 pm
Strangely, during the first lockdown, when I (a DBA, mind) was furloughed (but not for long - they realised their mistake quickly enough) I went looking for things 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
September 27, 2021 at 1:03 pm
I used to do a lot of volunteering when I was a child but I have since lost that charitable spirit. I do have much less free time but...
"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, 2021 at 1:02 pm
Grant, you are a busy man! What timely post, b/c I was just thinking that I might have stop my volunteer work with the PA Master Naturalist group 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
September 25, 2021 at 4:55 pm
Hi Grant
Nice post and Thanks
By the way, what is your call sign?
KC1KCE
And thanks.
"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, 2021 at 4:53 pm
Thank you very much for the valuable feedback. So does my suggestion to add more data files to TempDb sound reasonable then?
To me... no. Even if you do...
"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 24, 2021 at 2:55 pm
How many files do you have now?
"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 24, 2021 at 2:26 pm
It sounds like you didn't actually do an upgrade. By default, assuming no instance names, running the install against an existing instance, it will replace it. You should go 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
September 24, 2021 at 12:09 pm
Without execution plans, I'm guessing here.
Changes in statistics caused a change in execution plans. Changes in data caused a change in behavior (as data changes, row counts change, which causes...
"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 24, 2021 at 12:07 pm
AH!!!
Sorry. I really did misunderstand.
So, Ken is right. Don't do that. That is two, distinct queries. While yes, there are ways to force them into a single procedure or batch,...
"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 23, 2021 at 1:20 pm
It's just a loop that's needed. Try using the SELECT statement above and create a cursor. Then execute an a dynamic statement with the kill and the session_id value.
"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 23, 2021 at 1:05 pm
Viewing 15 posts - 1,171 through 1,185 (of 22,224 total)