I attempt to install CUs in bunches... meaning... I will go with a -1 CU for installs for about 6 months or so then install the next -1 CU 6...

I had this happen about 2 years ago. The apps guy called me and said that the identity had hit its max. The way the app works is it...

Simply use the GUI for the restore and click on generate script....

Everyone is going to be different. I don't have any environment setup to keep data in sync 24X7.

I have SQL Agent jobs setup to backup and restore to Non...

ThomasRushton (5/13/2016)

---

Markus (5/13/2016)

---

I find it amazing that still today that if you take the defaults the sizing and growth percentages for TEMP DB, model, msdb and master are so low....

I was using the upgrade path of 2000 SP4 -> 2008R2 -> 2014

seems like the best way. Remember to script out any logins and jobs and if you have...

I find it amazing that still today that if you take the defaults the sizing and growth percentages for TEMP DB, model, msdb and master are so low. 10%...

Great. I typically have our Security Admin team do this before I install SQL Server. However, sometimes I wonder if they actually do this or not all of...

When I install a new SQL Server I usually install the latest SP and the latest CU. With the exception if this is a vendor application then I will...

I think the PORT 1434 is reserved only for the dedicated Admin connection so you cannot use that for general use. Only one Admin at a time can use...

If your databases were set to FULL and you had a good full backup to restore you could have restored transaction log backups to restore the data. Yes, you...

What is the current size of the TEMPDB ldf file, what is the growth size? Is it set to autogrow?

To figure out what is causing it to grow...

Back in 2007/2012 our company was in flux and we didn't do many upgrades at all and we fell way behind in keeping upgrades going... had a lot of SQL2000...

Personally I think they should start the season two weeks later and end it one week earlier. Too many cities the weather is not right for baseball.

As far as...

Big Reds fan... never been to Opening Day yet... tickets sell out in minutes and second hand tickets are very expensive. Plus the weather can be very cold. ...