Viewing 15 posts - 5,311 through 5,325 (of 22,219 total)
jevitts (12/10/2015)
I figured that was the case. Thanks for confirming!I've definitely got my work cut out for me... the table in question has 55 indexes. :crazy:
Ow.
The place to start with...
"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
December 11, 2015 at 7:10 am
There's nothing uniquely special about an ODS. It's a SQL Server database that will primarily be used for reporting. I can't think of any special configurations that I've had 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
December 11, 2015 at 7:08 am
Yikes.
Why not simply keep the database unrecovered and continue to apply log files to it every day? Basically build your own log shipping process. It's still subject to utterly breaking...
"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
December 11, 2015 at 7:04 am
I agree with everything Gail says (shocker).
However, if you don't already have a clustered index, then maybe using the same key structure she suggests will make for a good cluster....
"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
December 11, 2015 at 6:59 am
rustman (12/11/2015)
"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
December 11, 2015 at 6:56 am
rodjkidd (12/11/2015)
ThomasRushton (12/11/2015)
rodjkidd (12/11/2015)
ThomasRushton (12/10/2015)
Pity they can't seem to stabilise...
"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
December 11, 2015 at 6:53 am
Eirikur Eiriksson (12/11/2015)
ThomasRushton (12/11/2015)
Grant Fritchey (12/10/2015)
Grant Fritchey (12/10/2015)
BrainDonor (12/10/2015)
Bought this one in Portland - designed to upset as many sci-fi fans as possible - http://fashionablygeek.com/t-shirts/trolling-shirt/
That is beautiful. The sad 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
December 11, 2015 at 4:57 am
Yep. I get it. Log files. Created when you create a database. The process of creating that database is to copy what's in the "model" system database. I suspect 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
December 10, 2015 at 12:00 pm
Without seeing the actual structure and queries, these are, at best, suggestions for testing.
rhans (12/10/2015)
"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
December 10, 2015 at 11:07 am
Grant Fritchey (12/10/2015)
BrainDonor (12/10/2015)
Bought this one in Portland - designed to upset as many sci-fi fans as possible - http://fashionablygeek.com/t-shirts/trolling-shirt/
That is beautiful. The sad thing would be the people who...
"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
December 10, 2015 at 9:01 am
Then the first index I'd put on the table is the clustered index. And, if you're going to be using this month field for lots of deletes, it might make...
"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
December 10, 2015 at 8:57 am
You'll want to look at the WITH MOVE option if the disks are configured differently between the two servers. But yeah, a RESTORE in a situation like this is 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
December 10, 2015 at 8:48 am
BrainDonor (12/10/2015)
Bought this one in Portland - designed to upset as many sci-fi fans as possible - http://fashionablygeek.com/t-shirts/trolling-shirt/
That is beautiful. The sad thing would be the people who don't get...
"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
December 10, 2015 at 8:46 am
karthik82.vk (12/10/2015)
Hi,I am thinking of creating a column store index for the table i am using?
Is there any specifications for creating it?
Yeah, tons! Go and read the documentation. It's vital.
"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
December 10, 2015 at 8:07 am
Steve Jones - SSC Editor (12/9/2015)
"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
December 10, 2015 at 3:56 am
Viewing 15 posts - 5,311 through 5,325 (of 22,219 total)