Grant Fritchey

Forum Replies Created

Viewing 15 posts - 3,286 through 3,300 (of 22,227 total)

RE: Purge database

Lidou123 - Tuesday, April 3, 2018 5:31 AM
Thanks a lot.
I will try SQL Dependency Tracker.
And there is primary Key in 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

April 3, 2018 at 5:42 am

#1985268
RE: Purge database

Lidou123 - Monday, April 2, 2018 9:24 PM
Hi Grant.
Thank you for your help.
Is there a way to determine relationship between 700...
"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

April 3, 2018 at 4:43 am

#1985259
RE: Purge database

Lidou123 - Monday, April 2, 2018 2:31 PM
This application is 15 years old.
It means deleting from the database all data older...
"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

April 2, 2018 at 5:24 pm

#1985227
RE: Purge database

Assuming you mean remove either unnecessary or unwanted data when you say "purge" (although I'm with everyone else, what do you mean?).
Normally, a properly structured database will foreign...
"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

April 2, 2018 at 9:05 am

#1985200
RE: Different plan on secondary vs Primary

butcherking13 - Thursday, March 29, 2018 7:22 AM
Thanks Grant and appreciate the response! Oddly enough, I tested on two different dev boxes...
"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 29, 2018 at 7:45 am

#1984947
RE: Different plan on secondary vs Primary

butcherking13 - Thursday, March 29, 2018 7:22 AM
Thanks Grant and appreciate the response! Oddly enough, I tested on two different dev boxes...
"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 29, 2018 at 7:43 am

#1984946
RE: SP_UPDATESTATS vs UPDATE STATISTICS

In your situation, you need to be using UPDATE STATISTICS, not sp_update_stats. The latter is just a shortcut to performing the former. You can look at the code. All 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

March 29, 2018 at 7:20 am

#1984939
RE: How to get a Max Count

pietlinden - Wednesday, March 28, 2018 7:19 PM
One way of doing this is to wrap your query in a TOP predicate ---...
"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 29, 2018 at 7:16 am

#1984938
RE: Different plan on secondary vs Primary

butcherking13 - Wednesday, March 28, 2018 1:53 PM
I have found an issue where a query plan on the secondary replica is much...
"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 29, 2018 at 7:13 am

#1984936
RE: Persistence of function parameters

Nesting functions, even inline functions, leads to all sorts of performance problems.
"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 28, 2018 at 4:49 am

#1984753
RE: Need to improve Performance issue

So, if we have to have linked queries (and eliminating these ought to be a goal), then we should at least push the filtering down to the linked servers. See...
"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 28, 2018 at 4:36 am

#1984752
RE: Need to improve Performance issue

Things like this destroy the possibility of performance enhancement
ON LTRIM(RTRIM(WP.ITEMID))
"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 28, 2018 at 4:30 am

#1984751

RE: Need to improve Performance issue

saptek9 - Tuesday, March 27, 2018 9:51 AM
Thank you. What about creating view instead table variables?

A view is nothing but 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 28, 2018 at 4:27 am

#1984750

RE: Storing and Retrieving historical data

There are all sorts of mechanisms around something like this. Using the baseball example, I'd look to the database design to deal with this. You have a team. You have...

"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 27, 2018 at 6:23 am

#1984638

RE: Are the posted questions getting worse?

Jeff Moden - Wednesday, March 14, 2018 7:30 AM

Heh... good grief. Check this out, folks...
http://bgr.com/2018/03/12/slingshot-malware-routers-infected-pcs/

The follow up article containing the nitty-gritty...

"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, 2018 at 9:02 am

#1983181

Viewing 15 posts - 3,286 through 3,300 (of 22,227 total)