Viewing 15 posts - 2,086 through 2,100 (of 22,219 total)
The trick is in the name. People read common TABLE expression when they should read common table EXPRESSION. A CTE is not a table. It's just a query. There is...
"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
January 27, 2020 at 12:19 pm
I'll do a little editing on the answer.
"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
January 27, 2020 at 12:08 pm
Yes, I am cranky. Because I am tired of being the guy with the shovel and broom who walks behind the horses in the parade.
wait - ???? you...
"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
January 27, 2020 at 11:36 am
You kind of laid out my argument to a degree. "...except as source of information from others..."
If you want to be those "others" who are a source of information, 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
January 27, 2020 at 11:33 am
Yay! I got it right.
"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
January 24, 2020 at 1:35 pm
OK. That's odd. I'm not sure.
Do you have customizations in the model database? It's possible that if you have stuff there, it gets created when you create the new database,...
"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
January 24, 2020 at 1:33 pm
Wait, wait, wait.
There isn't a compile of procedures in SQL Server. So that's not something you can grant permission for. There is a process where SQL Server will "compile" an...
"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
January 24, 2020 at 1:27 pm
Does it work on other databases on the same server? If so, the problem is strictly with this database.
"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
January 24, 2020 at 1:21 pm
If it's always going to be one of the three values, but not the other two, you could do a bunch of OR statements for the three different clauses. However,...
"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
January 24, 2020 at 1:19 pm
Or is the database corrupt? Have you run DBCC on it recently?
"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
January 24, 2020 at 1:14 pm
That"s great. You have a wide world of radio things to enjoy. Sample as much as you can then focus on what you find most interesting.
As for the CC...
"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
January 24, 2020 at 12:54 pm
I've been around a long time and will freely admit that I cast a jaundiced eye to changes mostly because most of them have been at the cost 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
January 23, 2020 at 9:42 pm
I think the titles, terms, and skills are changing but they will always need DBA's of some kind.
Yes, yes and yes!
"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
January 23, 2020 at 6:19 pm
Sounds like you're on the path and headed in the right direction. Know that something like this is not simple. Happy if I've helped even a little.
"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
January 23, 2020 at 6:18 pm
Congrats on the license upgrade. one more level to go.
We aren't Cranky, it's just hard to get people to understand that everything that's new isn't always better or...
"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
January 23, 2020 at 2:48 pm
Viewing 15 posts - 2,086 through 2,100 (of 22,219 total)