Viewing 15 posts - 166 through 180 (of 710 total)
If you're running Windows Pro 8.1 or later, Hyper-V is built in. Just hit the Windows key, type "Hyper-V" and then select the option to add Windows components. Select Hyper-V...
February 12, 2019 at 3:18 pm
February 8, 2019 at 3:29 pm
February 6, 2019 at 12:34 pm
For our upgrades from SQL2008r2 to SQL2016, we used Microsoft's SQL Server Database Experimentation Assistant:
https://blogs.msdn.microsoft.com/datamigration/2017/07/25/dea-2-1-general-availability-release-overview-database-experimentation-assistant/
This tool does exactly what you're after, using your actual workload.
January 17, 2019 at 7:19 pm
At a point in the process I have to execute code as that windows...
January 16, 2019 at 1:08 pm
INSERT INTO [dbo].[tblOrderNumberLog]) VALUES)I agree with everyone suggesting you replace...
January 16, 2019 at 11:36 am
January 13, 2019 at 1:43 am
sqldba4u - Tuesday, January 1, 2019 3:17 AMCan SQL Server 2016 license be used to install SQL Server 2008? Editions are same.
That's a license...
January 2, 2019 at 10:15 am
November 27, 2018 at 9:11 am
November 9, 2018 at 3:01 am
polkadot - Wednesday, November 7, 2018 12:38 PMLarge datatypes require more space to index as well, don't they?
With character data, no.
Physically, there's...
November 7, 2018 at 3:30 pm
Memory allocated for the execution of a query is based on the assumed row width. The assumed row width is not based on reality - it's based on the declared...
November 7, 2018 at 2:12 am
October 31, 2018 at 10:37 pm
When moving to a new cluster, you will have to transfer the databases, logins, jobs, AGs, etc. to the new cluster and instances. If you plan to use Automatic Seeding...
October 26, 2018 at 7:09 pm
Look at the Remote Object name in the Remote Scan. It's an object called 'IndexAnalysis'. It's not an actual table, but a chunk of memory.
You're using a DMF...
October 24, 2018 at 11:41 am
Viewing 15 posts - 166 through 180 (of 710 total)