Viewing 15 posts - 6,571 through 6,585 (of 22,226 total)
Thanks for the update.
"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
March 16, 2015 at 7:01 am
I'd strongly suggest you look into database design and normalization processes. Using referential tables you shouldn't be looking at tables with 100 columns, let alone 10000. Louis Davidson is 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
March 16, 2015 at 6:25 am
ricardo_chicas (3/16/2015)
What is really annoying is that I even trimmed the query as to return the same column where I have the clustered index on..
I know that the solutions provided...
"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
March 16, 2015 at 4:52 am
ricardo_chicas (3/16/2015)
The option(recompile) or the optimIze hint work, but, MS SQL shouldn't be doing this, I have a clustered index for a reason, I 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
March 16, 2015 at 4:39 am
The idea behind a cluster is to have two machines, one running all your databases, and one standing by. If something happens to the first machine you get an automatic...
"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
March 16, 2015 at 1:37 am
Are @lowerlimit and @upperlimit local variables or parameters? If they're local variables, you're probably seeing, well, the opposite of parameter sniffing. it's using average values rather than specific values against...
"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
March 16, 2015 at 1:35 am
I'd probably reverse build on this. If you need to manipulate files and do t-sql, I'd write it in PowerShell and call the T-SQL from there rather than trying 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
March 16, 2015 at 1:30 am
At the most basic level, yes, only one plan is in the cache for a given query. But, things can affect this. For example, if the same query is called...
"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
March 14, 2015 at 10:10 am
There are tons and tons of white papers on SQL Server at the VMWare web site. Also, a good name to know is David Klee[/url]. He does tons and consulting...
"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
March 14, 2015 at 4:25 am
ignez.mello (3/13/2015)
I tried the fastest and simplest way to start. I used "DBCC TRACEON (9481);" and ran the query. And ... yes, it performs in only 4 seconds. I tried...
"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
March 14, 2015 at 4:21 am
muthyala_51 (3/13/2015)
"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
March 13, 2015 at 9:24 am
Right. I watched the video. It doesn't change anything or provide us with more information than you already provided.
You need to look at the execution plan for the query....
"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
March 13, 2015 at 9:14 am
yuvipoy (3/13/2015)
As i said in my first post i am able to open and create/write/delete files in \\mynetwork\yuvipoy\ path.Unable only when i used sp_trace_create function.
The key word there is 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
March 13, 2015 at 8:59 am
and, where possible, switch to extended events.
"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
March 13, 2015 at 7:13 am
But the plans between the 2008 compatibility and the 2014 compatibility are different, right? They have to be. There's nothing in just changing the compatibility mode that would make a...
"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
March 13, 2015 at 6:35 am
Viewing 15 posts - 6,571 through 6,585 (of 22,226 total)