Viewing 15 posts - 4,606 through 4,620 (of 22,219 total)
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
johnwalker10 (7/9/2016)
Sometimes this error message occurs due to network traffic on the server. In such situation you need to change the Time
The time? Changing the date & time 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
July 11, 2016 at 5:47 am
How are your wait statistics?
This indicator is just an indicator of load. If it goes up or down compared to the baseline (which I get that you're just establishing), 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
July 11, 2016 at 5:45 am
you might want to explore Minion Reindex. It has a bunch of mechanisms for dealing with blocking that might make it work better for you than Ola's scripts.
"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 8, 2016 at 10:40 am
SQL!$@w$0ME (7/8/2016)
Grant Fritchey (7/8/2016)
So the majority of your queries, or the most frequently called queries use all these columns when filtering:
[Col1] ASC,
[Col2] ASC,
[Col3] ASC,
[Col4] ASC
Majority of the queries use all...
"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 8, 2016 at 10:34 am
So the majority of your queries, or the most frequently called queries use all these columns when filtering:
[Col1] ASC,
[Col2] ASC,
[Col3] ASC,
[Col4] ASC
That's a very wide key, three 256 varchars. 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
July 8, 2016 at 8:37 am
The core guideline that the best clustered index is a unique, not null, monotonically increasing integer column (basically, identity), is true. That said, it doesn't rule my life. For example,...
"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 8, 2016 at 8:30 am
SQL!$@w$0ME (7/8/2016)
Or is it better to create Primary key (identity...
"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 8, 2016 at 7:19 am
Phil Parkin (7/8/2016)
Grant Fritchey (7/8/2016)
Since the clustered index defines data storage, I recommend that the cluster be the most commonly used path to the storage. If...
"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 8, 2016 at 6:38 am
Viewing 15 posts - 4,606 through 4,620 (of 22,219 total)