Yes, if you manage multiple versions you really need the different version Mgt Studios. There are some things you do that just don't work in the wrong version of...

After I install a new SQL Server one of the first things on the check list is to set Max memory. Rule out a potential problem in the future.

calvo (5/27/2015)

---

And what about these pitchers? Rosin, pine tar, sunscreen on arms? Their argument is that they need a better feel and control of the ball for the batter's safety....

calvo (5/27/2015)

---

47 games in, we need a recap.

Look at Houston! 2nd best record in baseball at 30-17. I love rooting for the underdog, with a couple exceptions. Washington is doing...

So what team will be wanting to acquire a Cy Young contender at the trade deadline...... Johnny Cueto of the Reds will be available as my Red's are...

RTaylor2208, we just did the change early this morning on a Non Prod Cluster and it worked just fine as you stated.

Thanks.

My big question will be for the encryption... does it come in Standard Edition or do you have to have Enterprise Edition to get that feature?

Now that is VERY bizzare... very.

If you are manually upgrading the dbs remember to script out logins, SQL Agent jobs and any linked servers.

Also, run a Check Integrity and rebuild indexes after you upgrade the...

Wow... we only have one instance of SQL 2014 here and now a new version is coming out. I am still fighting to get people to upgrade what we...

I have not queried dm_tran_locks when this has happend. There are no foreign keys on this table. I do have DB settings set to this:

ALTER DATABASE MYDB_PRD

SET ALLOW_SNAPSHOT_ISOLATION...

I know.. that is what I thought as well. I open up Activity Monitor and find the Session ID that says head blocker with a 1 in it....

Last Thursday we just retired our last two SQL Server 2000 databases. They were small dbs, one was used by 3 people and the other the app was being retired...

Great. Thank You for the response.

There is no way to tell you that you won't have issues or you will have issues unless you test your applications in a non prod environment. Every installation...