Grant Fritchey

Forum Replies Created

Viewing 15 posts - 3,166 through 3,180 (of 22,219 total)

RE: In what twisted SQL world will a JOIN result in more records than a LEFT JOIN

Are there additional joins in this query that could also be affecting the number of rows returning? It does sound like it's a bit of a mess. Best of luck...
"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 20, 2018 at 11:57 pm

#1991167
RE: Easily grant access to a single Azure sql database-view

No matter what, you have to query the database (unless you export the data), so there has to be either an AD login or SQL login that can run 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 16, 2018 at 7:59 am

#1990663
RE: Are the posted questions getting worse?

BrainDonor - Tuesday, May 15, 2018 2:01 AM
Over the years I've seen a lot of threads where people complain that they're backups...
"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, 2018 at 5:18 am

#1990490

RE: Stored procedure running in loop is taking time to load . Is there any alternate way to run in a single execution ?

All these calculations on columns

SUBSTRING(InvoiceNumberMapping, 2, 7) = 
"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, 2018 at 5:12 am

#1990488

RE: Are the posted questions getting worse?

jonathan.crawford - Monday, May 14, 2018 4:25 PM
I have this query that uses the same code over and over and I'm thinking...
"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, 2018 at 8:46 pm

#1990443
RE: SQL Overview ( Questions and Answers to SQL Creation)

Sorry, not the person to help you with that. My C# skills are rusty to the point of immobility. Pretty sure there's a programming forum. I'd post there. Someone will...
"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 13, 2018 at 6:14 am

#1990281
RE: Multiple FK Tables or Single Table w/ Nullable/Empty Fields

I like option 2 for a bunch of reasons. If there is flexibility in what is included/not included in a location, that means that those values are not dependent on...
"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 12, 2018 at 12:24 pm

#1990272
RE: SQL Overview ( Questions and Answers to SQL Creation)

Happy to help. I'm always around here on the forums, or you can go to my blog. I also post the occasional video.
One recommendation...
"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 12, 2018 at 6:18 am

#1990267
RE: SQL Overview ( Questions and Answers to SQL Creation)

So, your question is, can you make the four columns a primary key on one of the tables and then make a foreign key on the other table, right? 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 11, 2018 at 4:23 pm

#1990258
RE: Are the posted questions getting worse?

Hugo Kornelis - Friday, May 11, 2018 6:15 AM
OT question (on SnagIt).
Using SnagIt's video capture, is it possible to remove frames from...
"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 11, 2018 at 7:44 am

#1990190
RE: SQL Overview ( Questions and Answers to SQL Creation)

You can, although overall that sounds like a poor design. Name and address in both tables could lead to duplicate data and all sorts of issues.
I'd rather...
"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 11, 2018 at 6:05 am

#1990179
RE: Performance Question

Not to mention NOLOCK everywhere, SELECT *... This is just a series of common code anti-patterns.
"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 10, 2018 at 12:29 pm

#1990108
RE: Point in time recovery with backups from different sources

TrailRunner - Thursday, May 10, 2018 11:00 AM
They use Unitrend to back up the database. Unitrend only restores back to a live...
"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 10, 2018 at 12:26 pm

#1990106
RE: Adding Addtional TempDB Files

Sue_H - Thursday, May 10, 2018 9:57 AM
ericwenger1 - Thursday, May 10, 2018 9:14 AM
"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 10, 2018 at 12:19 pm

#1990105
RE: Performance issue with the table having 40M rows

So you're moving 3.3 million rows filtered down after the JOINs, etc., from 120 million rows. In short, you're moving close to 3% of the data. That's actually not usually...
"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 9, 2018 at 8:37 am

#1989865

Viewing 15 posts - 3,166 through 3,180 (of 22,219 total)