Viewing 15 posts - 17,026 through 17,040 (of 22,226 total)
A backup of a database is just a file, so you can move it any way you want. Copy & paste, as mentioned before will work. XCopy will work. If...
"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 15, 2009 at 6:53 am
You need to ensure that all connections are clear with the database you're attempting to restore, even your own. Once all the connections are clear, you can restore.
If it's an...
"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 15, 2009 at 6:51 am
There is no way to update multiple tables from a single TSQL statement. If you want to update multiple tables, you will need multiple statements. I'm not sure that you'd...
"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 15, 2009 at 6:44 am
Assuming that you're working with SQL Server 2008 since you posted to this forum, you could also look at using the Hiearchy data type. That's for establishing Parent/Child type 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
July 15, 2009 at 6:41 am
Jan Van der Eecken (7/14/2009)
GilaMonster (7/14/2009)
Jan Van der Eecken (7/14/2009)
Are you saying I'm out of the office at an inapproriate time?
It's 10pm. What self-respecting IT person is not still working...
"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 15, 2009 at 5:36 am
I agree. That's a pretty poor choice for design. Not to mention the horrible chattiness of the app on your network, it's going to cause some major league contention within...
"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 14, 2009 at 1:23 pm
RBarryYoung (7/14/2009)
Grant Fritchey (7/14/2009)
"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 14, 2009 at 1:18 pm
GilaMonster (7/14/2009)
Grant Fritchey (7/14/2009)
No kaboom.No boom today. Boom tomorrow. There's always a boom tomorrow.
:-D:-D:-D:-D:-D
One of my favorites:
You're sitting at my station, using my equipment. Is there a reason for 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
July 14, 2009 at 12:37 pm
No kaboom.
"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 14, 2009 at 12:13 pm
Oooh, look... pulling the pin...
"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 14, 2009 at 12:13 pm
It could be bad or missing indexes. It could be that your process is blocked by others. It could be simply resource contention.
Hard to know with out quite a bit...
"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 14, 2009 at 10:38 am
If we are coming up on the number of the beast & the end times & all that because of the Thread, then the four horseman & the anti-guy must...
"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 14, 2009 at 10:00 am
I hate to pop everyone's bubble, but wasn't it established a while back that the 666 number is either a mistranslation or a bad copying job and tha thte actual...
"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 14, 2009 at 9:22 am
It really depends on the configuration of your tables & indexes, but if the IN clause is causing poor performance, you could try creating a temp table, load the variables...
"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 14, 2009 at 6:42 am
Bruce W Cassidy (7/13/2009)
Grant Fritchey (7/13/2009)
You mean if you change fonts you get better performance? Holy smokes! I've got to get some edits into the chapter on tuning...
[font="Verdana"]I'm also thinking...
"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 14, 2009 at 5:34 am
Viewing 15 posts - 17,026 through 17,040 (of 22,226 total)