Forum Replies Created
Viewing 15 posts - 12,121 through 12,135 (of 22,224 total)
-
RE: Frequently used DMV's & DBCC commands.....
Out of time for what? Is this about you learning or about an emergency at work, or are we filling in for an interview?
For a great start on DMVs, I'd...
"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: Interview question
How to reduce the workload? Shoot the users? No, probably not.
You actually can't "reduce" the workload. What you can do is make the workload more efficient through design, construction &...
"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?
mazzz (8/9/2011)
I spotted this drinking establishment during a fleeting visit to Bradford, UK, and thought of this thread...
Anytime we're in Bradford, I have a pub selected. The only bad thing...
"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: I can't restore anymore...
I suspect some of the databases probably have different drive or file configurations. You can't just replace these. You'll need to use a MOVE operation.
"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: what we have to do when sql server agent was down
Have you tried to start the service? You can do that through the Management Studio interface or by opening the SQL Server Configuration Manager. You can even use netstart commands...
"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: avoid the failure alerts from decommisioned server
this implies that your backup process is managed somewhere else. Where is that? Remember, we're not there and can't see what you see. What service is sending out the email?
"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?
SQLRNNR (8/8/2011)
Grant Fritchey (8/8/2011)
SQLRNNR (8/8/2011)
Grant Fritchey (8/8/2011)
I've been failing at Google-Fu today. I'm trying to track down the name of that pet store (or at least a good copy of..."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?
SQLRNNR (8/8/2011)
Grant Fritchey (8/8/2011)
I've been failing at Google-Fu today. I'm trying to track down the name of that pet store (or at least a good copy of the story about..."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?
I've been failing at Google-Fu today. I'm trying to track down the name of that pet store (or at least a good copy of the story about it, name or...
"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?
SQLRNNR (8/8/2011)
Grant Fritchey (8/8/2011)
SQLRNNR (8/8/2011)
GilaMonster (8/8/2011)
Ask Grant about GoDaddy, and take a couple steps back.Grant didn't like it at all, but I also believe his configuration was a bit different...
"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?
SQLRNNR (8/8/2011)
GilaMonster (8/8/2011)
Ask Grant about GoDaddy, and take a couple steps back.Grant didn't like it at all, but I also believe his configuration was a bit different than what they...
"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 (8/8/2011)
Ask Grant about GoDaddy, and take a couple steps back.He should take a couple of steps back, then ask about GoDaddy.
Short answer, no, I don't think much of them....
"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: SQL 2000 to 2005 Upgrade
I don't have a good tutorial for you on doing this upgrade for replication. By & large, upgrades are better and safer when they're done as a side-by-side upgrade, meaning...
"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: Jobs in SQL Server 2005
Also, depending on how the jobs are configured, you might have a single job doing things for multiple databases. Just to be aware in case whatever search mechanism you put...
"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: avoid the failure alerts from decommisioned server
right there with you too, bu what generated the error? Go there first. I don't know, there's got to be more to this question than first appears.
"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 - 12,121 through 12,135 (of 22,224 total)