Viewing 15 posts - 9,736 through 9,750 (of 22,219 total)
Krasavita (7/1/2013)
hello,I restored database to a new name and want to delete bads one,get error messa:
Cannot drop the database because it is being used for replication,how can I remove it?
Not...
"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 1, 2013 at 11:35 am
GilaMonster (7/1/2013)
Stefan Krzywicki (7/1/2013)
GilaMonster (7/1/2013)
Where did I leave my crystal ball?http://www.sqlservercentral.com/Forums/Topic1469066-5-1.aspx
I think the OP doesn't know enough to know they aren't answering your questions.
Take a look at his posting history....
"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 1, 2013 at 9:53 am
Can you just copy the backup file to a place that is accessible to the second server?
"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 1, 2013 at 9:51 am
GilaMonster (7/1/2013)
Stefan Krzywicki (7/1/2013)
GilaMonster (7/1/2013)
Where did I leave my crystal ball?http://www.sqlservercentral.com/Forums/Topic1469066-5-1.aspx
I think the OP doesn't know enough to know they aren't answering your questions.
Take a look at his posting history....
"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 1, 2013 at 9:47 am
A database in suspect mode may not be recoverable. That's why Gail is asking about backups. But, to understand what is wrong with the database we need more information than...
"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 1, 2013 at 9:47 am
WayneS (6/19/2013)
GilaMonster (6/19/2013)
Please tell me I'm reading that last post from the OP wrong.http://www.sqlservercentral.com/Forums/Topic1464172-391-1.aspx
Wow...
+Infinity
"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
June 20, 2013 at 1:14 am
SQLRNNR (6/17/2013)
SQLRNNR (6/13/2013)
You guys have a "widget" on your blog that allows the display of certain icons or badges (e.g....
"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
June 18, 2013 at 1:16 am
Brandie Tarvin (6/17/2013)
Steve Jones - SSC Editor (6/17/2013)
This week is the first SQL in the City of 2013. Anyone coming?
In Denver, I take it?
No. Can't travel that far on this...
"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
June 17, 2013 at 9:17 am
Lynn Pettis (6/14/2013)
I am officially going to Afghanistan!
I leave for IRDO at Camp Atterbury in Indiana on Sunday, June 23rd. All should go well there with me leaving there...
"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
June 17, 2013 at 2:07 am
It still a linked server in both cases? You should always get the remote scan if it's a linked server, so I'm a little confused by what you're telling me.
"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
June 14, 2013 at 9:10 am
Off the top of my head, no.
It sounds like the optimizer, because the function, assumed it needed to bring back all the data in order to filter it down. But...
"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
June 14, 2013 at 5:42 am
Still pretty much back to where I was. You'll note that one is moving all the data and the other is not. I suspect that the functions on the data...
"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
June 14, 2013 at 4:23 am
Remote scan is pretty much what it says, a scan against a remote machine through linked servers. I didn't talk about that in the book. Maybe something I should add.
So,...
"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
June 14, 2013 at 3:26 am
I'd suggest going to the moment in time when that occurred and look at the top 10 queries. You may have to bounce around the time a little bit 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
June 14, 2013 at 2:50 am
I'm with Ed. The Client Statistics are really only useful if you want to measure round-trip time, from the client to the server and back to the client. They're just...
"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
June 14, 2013 at 2:46 am
Viewing 15 posts - 9,736 through 9,750 (of 22,219 total)