Viewing 15 posts - 166 through 180 (of 708 total)
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
If you partition the table on the @@SPID value, then you don't need any of that lock-checking mess; everything gets its own partition. (You'll need to align your indexes for...
October 23, 2018 at 8:10 pm
October 19, 2018 at 1:58 pm
Viewing 15 posts - 166 through 180 (of 708 total)