Viewing 15 posts - 2,311 through 2,325 (of 22,224 total)
A timeout is caused when resources are unavailable, causing excessive waits. So, something is going south there. You've narrowed it down to the EMC backup solution running. What do 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
November 26, 2019 at 12:52 pm
Not sure I agree here. There is a lot of paperwork, and both your agent and the lender ought to be walking you through these items. There are checklists...
"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
November 25, 2019 at 7:20 pm
Spin up containers. Easier, faster. Or, a VM on Azure. Again, easier & faster. Especially just for testing stuff out.
"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
November 25, 2019 at 3:15 pm
Database or not, listen to me, listen to Jeff, listen to both of us, you should be able to access a file system and retrieve these objects for display 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
November 15, 2019 at 2:02 pm
X,
You're not wrong. It's not the choices I would make, but the way you've laid it out, they're not bad choices.Others may not agree, but I'd say that others can...
"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
November 14, 2019 at 3:37 pm
Just noticed this.
Minor nit.
I'm all about clarity. The more the better. So, with that in mind, naming two different columns in two different tables, ID, especially when we're going 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
November 14, 2019 at 3:33 pm
Is it only consisting of pdf, images, videos? If so, a relational database would be a poor choice.You might want to look to some other kinds of data storage 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
November 14, 2019 at 3:25 pm
I'm weird as a DBA. I'm all in on new stuff. I love Entity Framework and other ORM tools. I'm good with semi-structured and unstructured data management systems. I love...
"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
November 14, 2019 at 3:07 pm
Oh boy.
Are there strong opinions on natural keys versus artificial keys?
Yes.
You may get some very strongly worded responses to this question, depending on who sees it and how they respond....
"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
November 14, 2019 at 2:43 pm
Let's, just for a minute, assume that the use of WITH(NOLOCK) was ok to do. It's stupid to mark every single table with the hint especially if you ever...
"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
November 13, 2019 at 1:51 pm
Honestly, this sounds like the DBA job of the future. The easily automated stuff, server allocation, SQL Server installs, backups, consistency checks, all these things, should be already automated. 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
November 1, 2019 at 12:50 pm
PIRATE!!!!
Except Alice says no.
"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 31, 2019 at 12:22 pm
But could the same thing be done with a UDF?
I'd say no. Not the same way as stored procedures. An inline UDF (heck, even a multi-statement UDF) are treated...
"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 30, 2019 at 12:29 pm
Maybe OP re-creating index, not rebuilding it? Last sentence ("i have application which drops indexes") kind of implies that?
Could be, but recreating an index after data changes requires pretty...
"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 29, 2019 at 7:05 pm
To the person with the crystal ball, any prediction when SSIS projects will work properly in Visual Studio 2019?
BWA-HA-HA-HA-HA!!!!!
Oh, wait. You were serious?
"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 29, 2019 at 4:54 pm
Viewing 15 posts - 2,311 through 2,325 (of 22,224 total)