Viewing 15 posts - 7,801 through 7,815 (of 22,219 total)
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
Backups work in 2014, so we'll need more information. I would suggest you install the cumulative updates though. They fix some pretty serious bugs.
"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:03 am
vsamantha35 (7/3/2014)
... make up a story ...
Let me first assume this is just an "English as a second language" moment and point out that "make up a story" would mean...
"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 7:35 am
Sometimes I wish I could just vote for answers here.
Karen has the cause, Sean has the solution.
"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 7:29 am
Who says it needs correcting? PLE < 300 is not necessarily a bad thing. It could be that your system just has a highly volatile memory use. I'd want 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
July 3, 2014 at 7:11 am
And... what's the question? Ha!
That would have made a great blog post.
"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 7:05 am
Viewing 15 posts - 7,801 through 7,815 (of 22,219 total)