Viewing 15 posts - 1 through 15 (of 334 total)
If you're doing an in place upgrade you're still using old hardware - another reason not to choose for this option
December 20, 2023 at 8:02 am
I recently migrated a 1.3 TB database to SQL2019 and also had very little downtime. Instead of logshipping, these were my steps:
February 23, 2021 at 9:55 am
Several years ago, microsoft announced SQL server on Linux and we all laughed. Python in SQL server? Azure Data Studio is (indeed) that close. So let's wait for the real...
April 1, 2020 at 6:58 am
The debate about normalizing addresses continues! (see https://stackoverflow.com/questions/5530681/normalize-an-address).
Here in The Netherlands, zip code and house number makes an address unique. With these 2 fields you can determine street, city...
February 18, 2020 at 4:11 pm
It surprises me how little money a company is willing to invest in monitoring tools, just to answer these type of questions. And since I don't have historical data, I...
August 22, 2019 at 1:50 pm
instead of @@SERVERNAME, I would suggest set @svrName = cast(serverproperty('MachineName') as varchar(128))
May 12, 2017 at 2:27 am
A word of warning: if you have CONTAINED DATABASES, don't cleanup orphanded users (in fact all users in a contained database can be orphaned)
July 18, 2016 at 5:37 am
You can change both MaxDOP and Cost Treshold without having to restart the instance.
Make sure you clear the current waitstats before evaluating the new settings( give the server some...
April 10, 2016 at 7:51 am
CXPACKET has to do with Parallellism, it's an indicator of inefficient parallellism. Parallellism is not bad, but is should only be used for queries which benefit.
There are 2 settings...
April 10, 2016 at 5:06 am
Excellent Article!
In the example for an encrypted backup you refer to [MyNewCert], but the certificate is called [MyServerCert]. (Copy/paste issue I guess 😀 )
December 9, 2015 at 1:17 am
WARNING: Don't run this script on a server with multiple instances as it will select all SQL files from other instances (hope these instances are running)
December 8, 2015 at 1:02 am
link not working (TOO_MANY_REDIRECTS)
FIXED! 🙂
November 10, 2015 at 5:28 am
Kris Gruttemeyer (10/16/2015)
One thing which is not mentioned: You can only restore 2008+ in SQL 2014, if you have a SQL2005 (or SQL2000 :w00t: database), you'll have to restore it...
October 18, 2015 at 9:48 am
See Supported Version and Edition Upgrades SQL Server 2012 or Supported Version and Edition Upgrades SQL Server 2014 for the supported in-place upgrade path
October 18, 2015 at 9:30 am
my 50 cents:
- I would suggest to swap step 1 and 2 in post-work, because in one particular case I got errors with DBCC CHECKDB which were fixed with the...
October 15, 2015 at 1:33 am
Viewing 15 posts - 1 through 15 (of 334 total)