Viewing 15 posts - 7,801 through 7,815 (of 22,224 total)
Jeff Moden (7/7/2014)
"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, 2014 at 4:40 am
Most of the functions are the same with 6-8 joins or one. Most of the rules are the same dealing with a few rows or a few million. The real...
"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 7, 2014 at 10:04 am
If you're really going to be building a lot of databases, I'd suggest reading Louis Davidson's book. It's a great way to learn how to do database design.
"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 7, 2014 at 9:56 am
After you restructure it as was suggested already, this needs to be addressed:
(RTRIM(pc.CODE))
That will lead to scans which will seriously hurt performance. You shouldn't have functions on columns like...
"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 7, 2014 at 8:54 am
You can. I haven't done it myself, so I can't offer advice. But it's absolutely doable.
"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 7, 2014 at 8:30 am
I'd create a table for the Make. Then I'd create a table for MakeModel. That will have the primary key from the Make and the Model. Then you create 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
July 7, 2014 at 8:28 am
You are absolutely in a tough spot. But if you want to be technical, you don't have many choices.
"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 7, 2014 at 8:11 am
No. You can have multiple clusters on shared hardware, but you can't put different versions of SQL Server into the same cluster.
"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 7, 2014 at 7:47 am
Because DBCC runs on a snapshot of the database, the two processes won't interfere with each other.
"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 7, 2014 at 4:43 am
From this code alone there's no way to tell you how it's going to perform. In addition to the code requests, if you can capture the execution plans, that would...
"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 6, 2014 at 4:17 am
Either get a lot more space for the thing so it doesn't fill the drive, or, look into your ETL process and determine what is allocating so much space into...
"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 6, 2014 at 4:16 am
Lempster (7/3/2014)
SQLRNNR (7/3/2014)
"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 3, 2014 at 10:30 am
No offense at all. I just wanted to be clear. I did assume that you didn't mean to literally make stuff up.
As to interviewing, it's subjective. There just isn't 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
July 3, 2014 at 9:05 am
Something that severe sounds like a major issue with the SQL Server installation. First I'd try putting on the CU. If that doesn't resolve the issue, I'd get in touch...
"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 3, 2014 at 9:01 am
It did start out as a figurative unit of time. Now it's just a figurative unit. It's never been meant as an actual measure.
"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 3, 2014 at 8:07 am
Viewing 15 posts - 7,801 through 7,815 (of 22,224 total)