Viewing 15 posts - 2,461 through 2,475 (of 19,564 total)
Koen Verbeeck (7/31/2014)
ChrisM@Work (7/31/2014)
Koen Verbeeck (7/31/2014)
Lynn Pettis (7/31/2014)
Lynn Pettis (7/31/2014)
SQLRNNR (7/30/2014)
Lynn Pettis (7/30/2014)
Really?? Let's put a 500 million row table into an in-memory table.
It could work - depending on what...
July 31, 2014 at 7:54 am
Koen Verbeeck (7/31/2014)
Lynn Pettis (7/31/2014)
Lynn Pettis (7/31/2014)
SQLRNNR (7/30/2014)
Lynn Pettis (7/30/2014)
Really?? Let's put a 500 million row table into an in-memory table.
It could work - depending on what the data is...
July 31, 2014 at 7:50 am
GilaMonster (7/31/2014)
Lynn Pettis (7/31/2014)
Okay, he has the memory;Size of the table: 195 GB
Number of Indexes: 90
220GB memory is allocated only for the sql server....out of total 260 GB Server memory
No...
July 31, 2014 at 7:49 am
With 90 indexes you are over a constraint right there.
You are limited in number of indexes (8 iirc) you can create on an in-memory table.
With the table being 195GB, I...
July 31, 2014 at 7:48 am
What is the size of your table?
How many indexes?
And is that 220GB allocated explicitly to SQL Server or is that what is available to the server? If explicitly, how...
July 30, 2014 at 10:06 pm
Lynn Pettis (7/30/2014)
Really?? Let's put a 500 million row table into an in-memory table.
It could work - depending on what the data is in that table and the data types....
July 30, 2014 at 10:02 pm
I believe you are going about this the wrong way.
How big is your table with 500 million records?
How many indexes do you plan to have on that table?
How much memory...
July 30, 2014 at 9:02 pm
Lynn Pettis (7/30/2014)
Jeff Moden (7/30/2014)
autoexcrement (7/30/2014)
How about "crap answers only"?Heh... maybe that would make a good alternative to "The Thread". 😀
Careful, we don't want to provoke The Thread. ...
July 30, 2014 at 8:48 pm
Good Question.
I do think the answer is a dead give away if you have familiarity with sys.objects though.
July 30, 2014 at 8:45 pm
Recap...
So restore database with backup on NAS = fail
Restore database with backup on backend storage = fail
Restore database from vendor backup = fail
Restore database from newly created backup after vendor...
July 30, 2014 at 7:00 pm
Evil Kraig F (7/30/2014)
SQLRNNR (7/30/2014)
Sadly I have heard that same recommendation from more than one vendor and it is even printed in some vendor documentation for databases on SQL Server.
From...
July 30, 2014 at 4:39 pm
Sadly I have heard that same recommendation from more than one vendor and it is even printed in some vendor documentation for databases on SQL Server.
July 30, 2014 at 4:32 pm
Sean Lange (7/30/2014)
Ed Wagner (7/30/2014)
SQLRNNR (7/30/2014)
djj (7/30/2014)
whereisSQL? (7/30/2014)
Ed Wagner (7/30/2014)
TomThomson (7/30/2014)
SQLRNNR (7/30/2014)
Ed Wagner (7/30/2014)
Stuart Davies (7/30/2014)
SQLRNNR (7/29/2014)
aardvarkDigger
Hunting (for antiques)
Pecheur
é or ê?
Tomato
ketchup
hot dog
breakfast
Dinner
Bacon
Pork Belly
July 30, 2014 at 3:14 pm
Evil Kraig F (7/30/2014)
Steve Jones - SSC Editor (7/30/2014)
Lynn Pettis (7/30/2014)
July 30, 2014 at 3:08 pm
Viewing 15 posts - 2,461 through 2,475 (of 19,564 total)