Viewing 15 posts - 8,791 through 8,805 (of 22,224 total)
Cascade delete is pretty dangerous. I don't know of many people that use it. It tends to create very large transactions that lead to lots and lots of blocking. You're...
"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
March 5, 2014 at 4:20 am
Sure you can. The connection string is a little funky. This is my "server name" for connecting to one of my databases vx6jxrb86b.database.windows.net, well almost. I modified that a little....
"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
March 5, 2014 at 4:14 am
How about, instead of GeneralInformation, we think of those things as what they are, People. You can then create a People or Person table and there you can locate the...
"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
March 4, 2014 at 8:37 am
I have never had to do this before, so I could be very wrong, but, based on my understanding of replication, you're going to have to rebuild the entire thing....
"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
March 4, 2014 at 8:35 am
Yep, it includes all the changes made within a database, both structure and data, so no worries.
"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
March 4, 2014 at 8:31 am
You need to check all the hardware and configurations. If you've never done that, I strongly recommend getting an expert in the door. Hardware configs, especially I/O, can be extremely...
"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
March 4, 2014 at 8:30 am
Assuming it's getting backed up on a regular basis, I'd just access it's backup to do the restore. You can restore from a file share using "\\myfileshare\myfilename.bak" just fine.
"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
March 4, 2014 at 8:17 am
dbalmf (3/4/2014)
I'm assuming your laptop is part of the same domain as the SQL Server. Create a shared folder on your laptop, You will need to give the user which...
"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
March 4, 2014 at 8:16 am
If it has to be near real time, replication or an availability group (2012 and greater) are your only real options.
By the way, this is a 2014 forum. If people...
"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
March 4, 2014 at 8:15 am
george sibbald (2/28/2014)
thats me out then, xquery gives me a headache. 🙂
Ha! It gives everyone headaches. But you can search out scripts online to pull the information out. It 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
February 28, 2014 at 4:00 pm
george sibbald (2/28/2014)
Grant, is system_health extended...
"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
February 28, 2014 at 3:47 pm
That's a lot of deadlocks. You might actually have impacted performance using the traceflag.
"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
February 28, 2014 at 3:46 pm
dan-572483 (2/28/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
February 28, 2014 at 12:35 pm
I'd suggest running DBCC CHECKDB. If that passes, you're OK in terms of corruption. That index may still be fragmented. Actually, pretty sure it will be.
"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
February 28, 2014 at 12:13 pm
There is only limited ability of distributed queries to get and use statistics, so, when it can't get them, it just moves the entire data set over. You can read...
"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
February 28, 2014 at 12:11 pm
Viewing 15 posts - 8,791 through 8,805 (of 22,224 total)