Viewing 15 posts - 8,086 through 8,100 (of 49,571 total)
curious_sqldba (8/15/2014)
i can only scale-up so much on sql server, but if i have multiple databases i can easily scale-out them across multiple servers.
What is your current maximum sustained transactions/sec...
August 15, 2014 at 4:12 pm
curious_sqldba (8/15/2014)
In total there will be 10,000 commits per hour on the same log file
10 000 an hour? Unless my log file's on a 3.5" floppy disk, I'm pretty sure...
August 15, 2014 at 4:07 pm
Evil Kraig F (8/15/2014)
August 15, 2014 at 3:57 pm
Eirikur Eiriksson (8/15/2014)
Koen Verbeeck (8/15/2014)
GilaMonster (8/15/2014)
Eirikur Eiriksson (8/14/2014)
You can try out these methods as previously suggested
However OP said
I really don't like this temp table creation
So, no row number, no...
August 15, 2014 at 12:46 pm
They're just log backups. There's nothing different about log backups used with log shipping than log backups you'd get from maintenance plans
August 15, 2014 at 10:09 am
Take your last full backup, copy over all the logs that ran since that full backup (from the log shipping secondary), including one log backup that occurred after the data...
August 15, 2014 at 5:21 am
Ah. Then out of ideas. Sorry I can't help.
August 15, 2014 at 4:12 am
Reorg of the clustered index, with lob_compaction on?
August 15, 2014 at 3:30 am
Try an index reorganise with LOB Compaction on
August 15, 2014 at 3:02 am
WhiteLotus (8/14/2014)
What about if I want to know the query that consume the biggest memory ?
Your largest memory consumer won't be a query. Most of the memory will be going...
August 15, 2014 at 2:18 am
Eirikur Eiriksson (8/14/2014)
You can try out these methods as previously suggested
However OP said
I really don't like this temp table creation
So, no row number, no temp tables. Really limits the...
August 15, 2014 at 2:13 am
I have really un-fond memories of doing replication with an Oracle publisher (with SQL 2005). That was a nightmare, random data conversion errors that were incredibly hard to track (errors...
August 14, 2014 at 2:46 pm
Evil Kraig F (8/14/2014)
djj (8/14/2014)
ChrisM@Work (8/14/2014)
remember '76/'77
Wish I could remember what last year was like, I remember some nice days for '77 as I have a picture of me...
August 14, 2014 at 11:33 am
Gary Varga (8/14/2014)
Surely the big question is whether you will be sporting a matching Hawaiian shirt???
Steve's shirts don't match anything. Including themselves. 😀
p.s. Please donate fast, I need to know...
August 14, 2014 at 7:08 am
Viewing 15 posts - 8,086 through 8,100 (of 49,571 total)