There is a massive space between columns in the results tab, I had to reduce the zoom to 50% to get two columns in the screen at once. Please help me in eliminating this space. RakhalM Try using "Results to Grid" instead of what you have now, which is "Results ...
Can I create a SSIS package to get only row 12 to row 123 from an excel sheet..?? Can I have multiple instances of SSIS on a server? Can I preserve carriage returns in a string variable from SQL Server? Can I query SQL Server Agent Job Step Configuration Parameters Can I Reference ...
A "tail -f" equivalent command in Powershell to show real time logging A call to SSPI failed A connection to the directory on which to process the request was unavailable. This is likely a transient condition. A fast way to remove duplicated lines from an unsorted text file? a lot of c...
In this article we will see how we can remove partitions from a table in a database in SQL server. In my previous post i had demonstrated how we can partition a table via T-SQL. Lets now remove the partitions and merge the data in a single partition. I will start from where we lef...
In order to stripe disks in Windows, you simply add the number of disks you would like to the VM, and then create a pool using Storage Spaces in Windows. Don't configure any redundancy for your pool (which would limit your performance) as the redun...
This is our primary site and we have only one Win 2019 server hosting everything including the SQL server. I might also need to expand other drives later but I'm totally lost now:( Any help would be really appreciated. Thanks a lot for your assistance in...
NOTE:Running a program in a separate memory space uses additional memory. However, you’ll usually find that the program is more responsive. Another added benefit is that you are able to run multiple instances of the program—as long as all the instances are running in separate memory spaces...
LTRIM and RTRIM does not remove spaces. making sql server database read -write from read only Making the INSERT script Re-runnable many ways to calculate the first day of the year in T-SQL master.sys.xp_DirTree Max number of elements allowed in an IN clause. max value fo...
Use the following sample scripts to install, update, or remove SQL Server 2005 components from the command prompt. The scripts provide command prompt syntax to install SQL Server 2005 in typical user scenarios. Test and modify samples to meet the needs of your organization....
How to copy files to and from Nano Server (Windows) Backgrounds and Borders (Windows) HRESENUM structure (Windows) Remove method of the MSCluster_StorageEnclosure class (Preliminary) C-C++ Code Example: Creating a Queue C-C++ Code Example: Sending a Message Using an MS DTC External Transaction...