I had this issue with a SAN I was using. The engineer I worked with found that a new "firmware" update was available, he applied it and a new...

Gui = bad

TSQL = Good

For instance I generated this script using the gui. I only asked to add the login to another role but its altering the login as...

Not really the right forum area.

You need to empty the files using the DBCC SHRINKFILE command. This clears them and marks them not to be used.

DBCC SHRINKFILE

(

...

Based on this recent case study, you should reserve 1 GB per CPU on a 64bit OS. You can likely halve or third this on a 32 bit OS.

http://sqlcat.com/technicalnotes/archive/2011/04/26/lessons-learned-from-benchmarking-a-tier-1-core-banking-isv-solution-temenos-t24.aspx

This is a little bit vague so I suggest you do a little bit of research into what types of replication are available as there are a lot of variables...

I was implying transactional as a design concept which can help minimise the number of updates.

sp_repladdcolumn is an alternative but this will be removed in Denali.

sp_repladdcolumn offer useful parameters that ADD COLUMN does not. Such as the ability to add the column to a...

That is an incorrect statement. Its also incorrect if you meant horizontal...

Craig Purnell (5/18/2011)

---

You may be running into a limitation in the mini-shell. I seem to recall there are some limitations there. Try rewriting it and directly invoke Powershell.exe and change...

GilaMonster (5/18/2011)

---

MysteryJimbo (5/18/2011)

---

What is your current page life expectancy? A minimum of 600 is the generally accepted limit. If you have plenty of memory it could be much...

Yes. It will be added to the tail end of the backup.

What is your current page life expectancy? A minimum of 600 is the generally accepted limit. If you have plenty of memory it could be much higher.

Can't tell by that that example as it is a select. Generally you can tell by the table structures and relationships or you will have to ask the application...

You could use a powershell sql agent task. I've not tested this but I know the agent module has certain filesystem restrictions so if this isnt possible you could...

I would generate the scripts from the existing publication (right click context menu) to get the existing setting from another table article and use that as a template.

You will also...