if only I had read this a month ago… need to improve the code base 🙂 #sqltip #amo #sqlserver amzn.com/k/20YEJ78S2A0MM #Kindle
— Jens Vestergaard (@vestergaardj) February 26, 2012
You can partition an existing table by creating a clustered index on your new Partition Scheme #SQLTip #SQLServer ow.ly/k3ZYJ
— Jens Vestergaard (@vestergaardj) April 15, 2013
To install a #SQL2012 instance, a user must be a member of the local Administrators Group #SQLTip #SQLServer
— Jens Vestergaard (@vestergaardj) May 12, 2013
A table w/out clustered ix that uses page compression, will only compress pages with BULK INSERT or INSERT INTO…WITH (TABLOCK) #SQLTip
— Jens Vestergaard (@vestergaardj) May 17, 2013
Availability groups are not supported on domain controllers. #SQLTip #SQL2012 #SQLServer
— Jens Vestergaard (@vestergaardj) May 17, 2013
