Viewing 15 posts - 5,221 through 5,235 (of 22,219 total)
So I assume it's keyed off the accountid, but what determines the order? if it's just ordinal, we might have a problem because you can't guarantee order without an ORDER...
"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 18, 2016 at 6:01 am
I'm with John, that makes perfect sense based on the data you're showing.
Side note, get in the habit of identifying the owner of every column in your queries, not just...
"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 18, 2016 at 5:15 am
I'm confused then.
As written, you can run the code you're showing, anywhere at all. It's basically hard coding values into a table variable. What does that have to do 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
January 18, 2016 at 4:44 am
By and large, if the data entry is variable in length, I use VARCHAR even though it might be more likely to fragment. That's why we do maintenance on 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
January 18, 2016 at 3:10 am
I don't see either a WHILE loop or OPENQUERY in the code.
"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 18, 2016 at 2:26 am
rodjkidd (1/15/2016)
I...
"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 15, 2016 at 3:42 am
Not if they're dbo. You can't deny much to someone at that level. Instead you'd need to grant them individually each of the dbo level permissions, but not allow them...
"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 15, 2016 at 3:07 am
Ed Wagner (1/14/2016)
Alvin Ramard (1/14/2016)
SQLRNNR (1/14/2016)
Alvin Ramard (1/14/2016)
Anybody coming to Nashville's SQL Saturday this weekend?
I know a few people that are. Timing was bad for me. I am 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
January 14, 2016 at 1:37 pm
Ed Wagner (1/14/2016)
Phil Parkin (1/14/2016)
Grumpy DBA (1/14/2016)
"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 14, 2016 at 7:10 am
Grumpy DBA (1/14/2016)
"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 14, 2016 at 7:09 am
You're stuck.
Trace is probably the best answer, at least in 2008. If you moved to 2012 or greater I'd also suggest looking at moving to Extended Events. It doesn't make...
"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 13, 2016 at 4:12 pm
mvinokur (1/13/2016)
I hope someone has help me with this. I am also getting a warning column with no statistics.
This is on a column that is a primary key.
Auto Create...
"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 13, 2016 at 8:49 am
Except for upgrading (and I wouldn't suggest going to 2012, 2014 has been out for two years and is very stable), and what has been suggested, the only other solutions...
"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 13, 2016 at 6:17 am
Always start with the Microsoft documentation when you have fundamental questions about what something is or how it works. For example, here's the information on indexed views. Then you 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
January 13, 2016 at 6:11 am
Eirikur Eiriksson (1/12/2016)
Grant Fritchey (1/12/2016)
What's the query hint doing?😎
WITH (READ
UNCOMMITTED)???
I know what it does. I just don't understand why it's included.
"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 13, 2016 at 5:25 am
Viewing 15 posts - 5,221 through 5,235 (of 22,219 total)