quackhandle1975 (8/18/2014)

---

Brandie Tarvin (8/16/2014)

---

Those are good answers, though I would be looking for you to ask the business user what he means by "doesn't work' and does he have a...

GilaMonster (8/18/2014)

---

senthil kumar d (8/18/2014)

---

And the reason for simple recovery model is that the transaction logs are really huge and they do not want to have a back up of...

TomThomson (8/18/2014)

---

Oh dear! "all Hardware"???

Soundcard? Joystick? USB devices?

Or am I answering the wrong question?

See this MSDN library page.

Or am I just a couple of years...

It seems that you are in a position where you are looking to architect a solution that may be out of your breadth.

I'd recommend taking a step back and looking...

curious_sqldba (8/15/2014)

---

GilaMonster (8/15/2014)

---

curious_sqldba (8/15/2014)

---

Ok, i have a application generating about 10,000 transactions read/write per hour. we have 50 + clients, should i partition per client ( data has to be...

curious_sqldba (8/15/2014)

---

Ok. What about scalability, as i add more partitions activity also goes up so i can only scale-up so much on sql server, but if i have multiple databases...

curious_sqldba (8/15/2014)

---

Lets say you have database partitioned, all the transactions need to commit to same log file. In total there will be 10,000 commits per hour on the same log...

curious_sqldba (8/15/2014)

---

Assuming i have enterprise edition, is partitioning recommended for OLTP? My thought is it is good for OLAP and might not suite for OLTP ( 1000 read/writes per hour):

i)...

verse

Woohoo - good to hear.

Not entirely possible.

Policy Based Management won't prevent the name...

dan-572483 (8/15/2014)

---

I've also posted my resume on portals and have been contacted by many recruiters for jobs I am not qualified for, over-qualified for, or are out of my area....

I wouldn't leave filegrowth set at 1mb. There isn't much use for a growth that low. With Instant file initialization, data file growths in the GB range are...

You're welcome.

Try the following type of query

SELECT PARSENAME('asdf.domain.com',2) + '.' + PARSENAME('asdf.domain.com',1) AS url