Viewing 15 posts - 4,606 through 4,620 (of 22,227 total)
wendy elizabeth (7/13/2016)
What other data type would you recommend? That is large but not as large as varchar(max) is?
I'm curious now, what are you trying to store? And which data...
"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
July 13, 2016 at 3:41 pm
Henrico Bekker (7/13/2016)
Sorry to resurrect this thread, has 2014 BPA been released? Can't find it anywhere.
No. I don't think you they are maintaining that code any more.
"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
July 13, 2016 at 11:19 am
durga.palepu (7/12/2016)
text datatype is supported in SQL 2012 but will be deprecated in future versions.alternative is to use varchar(max) and if you need multilingual support use nvarchar(max) datatype.
Thanks,
Durga
Yeah, trace 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
July 13, 2016 at 7:45 am
Oh, and as far as the wait stats go, that's cumulative for the server. Looking at it in isolation for a problem of this type doesn't tell us anything at...
"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
July 13, 2016 at 6:27 am
paolobianchi (7/13/2016)
(can i find waiting cause of a single query someway? I can just profile becuse i don't have sufficient permission on server to use extended events... 🙁
Thank you!
Paolo
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
July 13, 2016 at 6:26 am
To do what you're looking for requires you to change your code to dynamic T-SQL. However, that also exposes you to SQL Injection attacks, so you'll have to write additional...
"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
July 13, 2016 at 5:34 am
paolobianchi (7/13/2016)
they seems identic to me, but ok, take the actual execution plan 🙂
Same plan, but a little bit of added detail. It's the estimate vs. actual that gets interesting...
"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
July 13, 2016 at 5:31 am
For such simple queries, there's not much in the way of tuning opportunities. The SELECT query is TRIVIAL, which means that there is only one possible execution plan. The one...
"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
July 13, 2016 at 5:27 am
For licensing questions, always go to Microsoft. You don't want to put your company at risk because of something that some person on the internet said.
"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
July 13, 2016 at 5:17 am
I wouldn't use TEXT. It's on the deprecation list.
Here are the data types in the SQL Server documentation. You're describing what is CHAR, VARCHAR or TEXT, only you shouldn'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
July 12, 2016 at 3:34 pm
What are your wait statistics? What is the server actually running slow because of? That's one of the most important things to know about.
"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
July 12, 2016 at 11:32 am
GilaMonster (7/12/2016)
Database admin(DBA) (7/11/2016)
It seems like its not related to CPU issue nor memory issue.i beileve its related to SQL Latches and their indicate like performance issue.
Performance tuning shouldn'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
July 12, 2016 at 7:42 am
VastSQL (7/11/2016)
Grant Fritchey (7/11/2016)
This indicator is just an indicator of load. If it goes up or down compared to the baseline (which I get that you're...
"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
July 11, 2016 at 6:31 am
As Gail says, they are per instance. You can create a script that will allow you to create the same trace on all your instances if you so desire. In...
"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
July 11, 2016 at 5:50 am
I'll say the same thing I always say about licensing questions on SQL Server. Go straight to the people who are going to audit you, Microsoft. They determine what's in...
"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
July 11, 2016 at 5:48 am
Viewing 15 posts - 4,606 through 4,620 (of 22,227 total)