Viewing 15 posts - 7,246 through 7,260 (of 22,219 total)
If you don't have experience in development overall, then I'd suggest following the suggestions in the post above. If you're trying to understand how to run the debugger within T-SQL,...
"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, 2014 at 4:42 am
sql.querying (11/12/2014)
Even between two different databases in the same instance?
It depends. One thing that the optimizer takes into account is foreign key constraints. Since you can't have those across databases,...
"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, 2014 at 4:40 am
Regardless of what you do to modify the backup, and I like the suggestions, make darned sure you test the restore to ensure you both know how to 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
November 13, 2014 at 4:38 am
zahid.nawaz (11/12/2014)
2) What effect it has if we have one cluster index but many none cluster indexes? according to following blog it can even create extra performance problems instead 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
November 13, 2014 at 4:37 am
If you're working within SQL Server, I wouldn't worry that much about product specific T-SQL. The vast majority of applications developed stay within the RDBMS that they're developed within. So,...
"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, 2014 at 4:27 am
Because it's so very easy to undo stored procedure encryption, it's really a waste of time. Why do you think you need to encrypt your procs?
"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, 2014 at 4:24 am
spaghettidba (11/12/2014)
Thanks for correcting me, Grant.Sorry for posting incorrect information.
Not a correction, an enhancement.
"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 12, 2014 at 6:33 am
Unclear how many transactions you're dealing with. That can still affect your choices. Is the system going to be OLTP or Reporting focused? That's also going to affect how it...
"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 12, 2014 at 6:25 am
Oh yeah, I've seen that before. It comes from several sources. It could be that you're dealing with table variables or multi-statement table valued user defined functions. Because they don't...
"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 12, 2014 at 6:16 am
Just no way to say without the query and the execution plan to understand what's happening and why.
"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 12, 2014 at 4:44 am
I'm with Gianluca on this. It's hard to tell you what the problem is without actual error messages.
Do you have a backup available? It sounds like you might need 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 12, 2014 at 4:43 am
Which event did you use? Showplan XML Statistics Profile will capture actual plans. But, it has an extremely high overhead. Because trace has such lousy filtering, I don't recommend 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
November 12, 2014 at 4:39 am
Some other issues include the fact that while the indexes on in-memory tables have statistics, you can't see the statistics information using DBCC SHOW_STATISTICS. Further, because of this, while 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 11, 2014 at 10:23 am
From the slides on the precon I did last week at Summit, this is just a list of table restrictions:
Restrictions
No LOB
No CLR
No user defined types
No VARIANT
No ROWVERSION
No foreign keys
Must have...
"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 11, 2014 at 10:21 am
No. No, no, no. Don't do that. Everything just doesn't belong within the in-memory sphere. If you're not experiencing significant slow downs due to latch waits, you really shouldn't even...
"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 11, 2014 at 10:05 am
Viewing 15 posts - 7,246 through 7,260 (of 22,219 total)