Forum Replies Created
Viewing 15 posts - 15,661 through 15,675 (of 22,227 total)
-
RE: Table Splitting
If you're seeking to break it up in that way, then instead of ID & foreign key, maybe breaking it up by date makes more sense.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Injecting Your Own Bias
I'll try to attend the Summit regardless of where it's held. That said, I'd still like to see it move around a bit. Seattle is a pretty major travel commitment...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
GilaMonster (3/23/2010)
Changing the subject (if there is one), any art critics here?Been fiddling with this on and off for a couple years now. Initial idea was just the light from...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Good to have you back Barry!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Clustered Index Modification
Nice high level of paranoia. Good job.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Lynn Pettis (3/22/2010)
GSquared (3/22/2010)
tstaker (3/22/2010)
Anyone have anything funny, interesting or weird to talk about today? I'm bored.My main subjects of conversation so far today have been politics (Obamacare passed...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Clustered Index Modification
As far as the process goes, I think you have it right. The only suggestion I can make is to script the process. I'd open up PowerShell and put it...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: OPTION(KEEPFIXED PLAN) for SQL 2005?
You can do the same with SQL Server 2005.
You also have the option of provide plan guides. Here's an introduction on the topic from Microsoft.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: how to use sql sever 2005
That's a pretty big topic for a web post. You might want to try tracking down a few books. Here's some information to get you started from MSDN.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Maybe I misunderstood, but this sure looks to me like someone asking how to hack SQL Server. Am I way off?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Object tampering within SQL Server 2008??
amandix (3/22/2010)
Does anyone known a method of object tampering within SQL Server 2008?The goal is to use an attached copy of mssqlsystemresource db and alter some system stored procedures, and...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: How To Obtain "Buffer Cache Hit Ratio" and "Page Life Expectancy"?
It's good that you can use the DMV to satisfy your need, but you should be able to see it in Performance Monitor too. It can be a common problem...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Splitting Large table
Please don't cross-post. This just leads to confusion and bad information.
Do not reply.
Discussion already started here: http://www.sqlservercentral.com/Forums/Topic887267-373-1.aspx
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Table Splitting
Without knowing more about the structure and what exactly is performing badly, it's going to be very hard to suggest solutions. Is the performance bad on inserts or on reads?...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Steve Jones - Editor (3/22/2010)
I can't believe I left a perfectly good country behind 🙁I made it, a definitely journey from hell. Last year (2009), I had an only slightly...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 15,661 through 15,675 (of 22,227 total)