Viewing 15 posts - 7,516 through 7,530 (of 22,226 total)
Can you further define what you mean by "extensibility of environments"? Are you talking about a scale out scenario? Scale out means that in order to support an increasing load...
"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 4, 2014 at 7:03 am
a2zwd (9/4/2014)
I have worked on different DB projects. All the companies I worked will design DB/tables directly in sql server management studio. Means they 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 4, 2014 at 7:00 am
Here's the issue:
dbo.NEW_ORDER WITH (serializable updlock)
You need to change it to:
dbo.NEW_ORDER WITH (serializable, updlock)
"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 4, 2014 at 6:54 am
BWFC (9/4/2014)
Grant Fritchey (9/4/2014)
"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 4, 2014 at 6:47 am
The hardest thing standing between you and a job is not knowledge or a particular course. The hardest thing is experience. Few companies have entry level data professional positions. It's...
"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 4, 2014 at 6:09 am
mario17 (9/3/2014)
Hey all !!!we have Grant Fritchey here !!!!
Thanks much for your help !!!!
M
Ha!
I wasn't aware that was an event, especially with all these people.
"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 3, 2014 at 10:51 am
SQLRNNR (9/3/2014)
Luis Cazares (9/3/2014)
xsevensinzx (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
"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 3, 2014 at 9:04 am
Sean Lange (9/3/2014)
Gazareth (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
"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 3, 2014 at 9:02 am
HowardW (9/3/2014)
Grant Fritchey (9/3/2014)
"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 3, 2014 at 8:34 am
Core problem there is that you may not know what you don't know, meaning, it's entirely possible for there to be queries coming from sources that you don't know 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
September 3, 2014 at 7:39 am
I'd simply set up a test to show it. Create a copy of your tables and show queries with and without Column C. Specifically, focus on the execution plan 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 3, 2014 at 7:09 am
Pretty much that whole WHERE clause is an issue. Functions on columns or functions to determine values within a WHERE clause, JOIN criteria or a HAVING clause will all impact...
"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 3, 2014 at 7:06 am
Adding a new table, no. If we're just talking about adding a blank table to the database and nothing else.
Adding that column to a table, well, it depends. If it's...
"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 3, 2014 at 4:01 am
There are also a number of limits on data types. There are no foreign keys supported. Not all T-SQL statements are supported. It's a very specialized set of functionality.
"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 3, 2014 at 3:40 am
You should run the SQL Server 2014 Upgrade Advisor.
"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 2, 2014 at 3:41 pm
Viewing 15 posts - 7,516 through 7,530 (of 22,226 total)