Viewing 15 posts - 7,621 through 7,635 (of 22,219 total)
As has been stated, SQL Server will use all the memory you make available to it. In order to understand if you have enough memory, I'd suggest using some 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
August 4, 2014 at 4:45 am
There's no magic. The creation of the index requires locks placed on the table that are going to prevent inserts. You'll have to finish the creation of the index prior...
"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
August 4, 2014 at 4:43 am
Completely guessing, your database is in FULL recovery and you don't run log backups? Is the drive where the log files live full?
"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
August 1, 2014 at 11:25 am
2gb is a very small environment. 2012 has a lot more functionality built in than 2000 does. It's entirely possible that 2000 runs faster in such a tiny environment 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
August 1, 2014 at 8:45 am
jarupan (7/18/2014)
This is the first time I see about infinity switch. Does it mean unlimited growth in TempDB? If not, would you pleasee explain and how can I...
"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
August 1, 2014 at 5:55 am
cdm33.com (7/31/2014)
After poking around and reading what you had to say about what I wanted to do, I think I'm off to a good start. It's...
"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
August 1, 2014 at 5:32 am
William J. Fellows (7/31/2014)
To qualify my statement, Steve stares at my legs a lot. 😛
Me too! Va-va-va-voom!
"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 31, 2014 at 1:03 pm
Another vote for the side-by-side upgrade. In place upgrades burn sometimes. I'm just not a fan.
And yes, your boss is wrong. That's not the right way to go about 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
July 31, 2014 at 12:14 pm
Sarah Wagner (7/31/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 31, 2014 at 8:57 am
New Born DBA (7/31/2014)
Grant Fritchey (7/31/2014)
Oh, and if you are in Europe, I'm doing a full day on execution plans at SQL Server Days.I live in Chicago, IL
So, you're employer...
"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 31, 2014 at 8:56 am
A CTE is just a query. All by itself, it's not good, it's not bad. It's just a query. What will hurt performance is what you're querying, how you're querying...
"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 31, 2014 at 7:36 am
The DMV is going to readout what it gets from the performance counters, yes. Are there changes in behavior between 2008 and 2012? Yes. Will those changes possibly be evidenced...
"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 31, 2014 at 7:01 am
Serializable has to take exclusive locks of everything it touches, including reads. So, any other process that is reading anything that the process running in Serializable needs, is going 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 31, 2014 at 6:58 am
patrickmcginnis59 10839 (7/30/2014)
Grant Fritchey (7/30/2014)
patrickmcginnis59 10839 (7/30/2014)
Then whats the problem with defending SO?I wasn't aware there was one. Someone offered an opinion. You disagreed. Others disagreed with you. Etc.
I...
"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 31, 2014 at 6:56 am
Lynn Pettis (7/31/2014)
Lynn Pettis (7/31/2014)
SQLRNNR (7/30/2014)
Lynn Pettis (7/30/2014)
Really?? Let's put a 500 million row table into an in-memory table.
It could work - depending on what the data is in that...
"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 31, 2014 at 6:48 am
Viewing 15 posts - 7,621 through 7,635 (of 22,219 total)