Viewing 15 posts - 106 through 120 (of 315 total)
reorganizing an index is written to the transaction log and is a transaction which means until it finishes with the REORGANIZE (or it's being killed) taking transaction log backups will...
October 23, 2019 at 10:32 am
I'm right now migrating SQL Server from 2012 / 2014 to 2017 and I wish I could go for 2019 right away (I'd love to have all the csv files...
October 22, 2019 at 12:35 pm
I have no keyboard issues - shift is 3 keys wide and numbers are not directly above qwerty - , but throughout my research in replacing my own current P51...
October 21, 2019 at 7:25 am
I have been using the Lenovo ThinkPad W510 for a long time with 32 GB RAM, afterwards I went with the ThinkPad P51 and 64 GB RAM. Didn't take long...
October 18, 2019 at 12:08 pm
You can query
[SSISDB].[internal].[executable_statistics]
and get some runtimes, you will be able to see how long a DFT from beginning to end will take but not for steps within...
October 17, 2019 at 1:40 pm
have a look at Set-ClusterOwnerNode you should be able to set the order to s1, s2, s3 thus those cluster Services should attempt to Failover to s2...
October 17, 2019 at 12:16 pm
Maybe that question is rather something for Informatica forums? From SQL Server side only thing to do would be start a SQL Server trace, let the Dev connect and see...
October 16, 2019 at 11:19 am
You can define the Flat File Source to have a fixed width Input rather than delimited Rows
October 10, 2019 at 2:35 pm
October 10, 2019 at 2:28 pm
Well if it's only for DR purposes you can configure Database Mirroring for High-Availability but if you cannot change the application IP then you can't change the application port either...
October 9, 2019 at 2:11 pm
So, is everything fine according to WSFC? All Nodes online and in the cluster? Have you tried this?
October 9, 2019 at 1:54 pm
Page / Table Fragmentation, Statistics last updated?
October 9, 2019 at 7:42 am
There is a lot of places to look actually. Controller Selection and -Layout for the Disks matters as much as seeing that the VM can pass QD > 1 to...
October 8, 2019 at 2:45 pm
"Work tables could be used to store temporary results for query spool, lob variables, XML variables, and cursors. Worktables are used for queries that use various spools (table spool, index...
October 2, 2019 at 4:02 pm
I actually would love to play around with Machine Learning but not on Azure - unless it's about training very big models - as this would rather make me poor...
October 2, 2019 at 3:29 pm
Viewing 15 posts - 106 through 120 (of 315 total)