Viewing 15 posts - 10,906 through 10,920 (of 22,224 total)
I've hit similar issues in the past. What we found was that there was a system backup software that was monitoring the files and reading them as we created them....
"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
May 15, 2012 at 10:51 am
reks12 (5/14/2012)
but write me page were i can find that questioni just want to learn that program
maybe to pass exam
please dont be angry
:crying:
Not in any way angry. Sorry if 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
May 14, 2012 at 9:05 am
Eugene Elutin (5/14/2012)
BTW, the only way to see the questions legally is to take the test. Any other way you're "seeing the questions" is illegal. We absolutely won't help 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
May 14, 2012 at 8:55 am
HowardW (5/14/2012)
You can find out if Session ID is unique at any given...
"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
May 14, 2012 at 7:58 am
reks12 (5/14/2012)
i have some page for that question but it ask me to download it
i want to see question with download it on my pc
that page...
"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
May 14, 2012 at 7:57 am
Duran (5/14/2012)
The session table has no indexes. Its always functioned ok in the past, this problem appears to have come out of nowhere. I'm not sure how to find...
"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
May 14, 2012 at 7:55 am
Duran (5/14/2012)
"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
May 14, 2012 at 7:49 am
You've got multiple full scans running on millions of rows. Until you make the query filter that data, performance is going to stink and there's almost nothing you can 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
May 14, 2012 at 7:46 am
Ah, I didn't spot the Exchange Event the first time through. This is a parallelism deadlock. Best solution in this case is to eliminate the parallelism. As a starting point,...
"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
May 14, 2012 at 7:32 am
Dynamic Management Function? Part of the Dynamic Management Objects (DMOs) which include DMFs and DMVs (Dynamic Management Views).
"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
May 14, 2012 at 7:07 am
Spend lots of money and buy a 64-bit Enterprise version of SQL Server then you can spend lots more money on tons of CPUs and Memory. Then buy lots 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
May 14, 2012 at 7:06 am
To create this through maintenance plans, just follow the wizard. It'll walk you through it. It's easy. Try it out first on your QA system so you feel confident, but...
"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
May 14, 2012 at 6:37 am
The easiest way to get rid of the table is to use the command, DROP myschema.mytable. That will immediately remove it, assuming you haven't created foreign key constraints to 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
May 14, 2012 at 6:32 am
You'll need to build a query to return that data. Best thing to do is take your requirements and then start putting together the SELECT statement. Once you have 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
May 14, 2012 at 6:31 am
You need to aggregate data, and then, once aggregated filter out the results? Is that a good summary? There are two approaches to this. First, use the HAVING clause as...
"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
May 14, 2012 at 6:29 am
Viewing 15 posts - 10,906 through 10,920 (of 22,224 total)