User Profile
Simple_Balayeur
Brass Contributor
Joined Jun 05, 2020
User Widgets
Recent Discussions
Re: Input error: -2146893008
Hello Sir. My first guess was network protocols. I've read an article and it goes the same way. I'm not a network specialist, but I'v encounter similar problems in the past. Check from the station, from where your running the commands, that the enabled protocols works. https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-client-protocols?view=sql-server-ver16 Thanks Hope this helps. rodgerkong333Views0likes0CommentsRe: update the records
Hello here is an example: UPDATE top (1) MyTable SET emp_Id = '123456' WHERE emp_id = 1; Yes you need to have a unique primary keys (A way to identifiy a row uniquely). Also I'v notice that you have a unique phone...Not ideal primary key for an Employee but you could update your columns by specifying Update mytable set emp_id='123456' where phone='9000000000' Hope this helps;)1.5KViews0likes0CommentsRe: update the records
Hello here is an example: UPDATE top (1) MyTable SET emp_Id = '123456' WHERE emp_id = 1; Yes you need to have a unique primary keys (A way to identifiy a row uniquely). Also I'v notice that you have a unique phone...Not ideal primary key for an Employee but you could update your columns by specifying Update mytable set emp_id='123456' where phone='9000000000' Hope this helps;)1.5KViews0likes0CommentsRe: Windows 11
Rajendra Singh You have to meet system requirements for hardware: Processor 1 gigahertz (GHz) or faster with 2 or more cores on a http://aka.ms/CPUlist or System on a Chip (SoC). RAM 4 gigabyte (GB). Storage 64 GB or larger storage device Note: See below under “More information on storage space to keep Windows 11 up-to-date” for more details. System firmware UEFI, Secure Boot capable. Check https://support.microsoft.com/topic/a8ff1202-c0d9-42f5-940f-843abef64fad for information on how your PC might be able to meet this requirement. TPM https://docs.microsoft.com/en-ca/windows/security/information-protection/tpm/trusted-platform-module-overview version 2.0. https://support.microsoft.com/windows/1fd5a332-360d-4f46-a1e7-ae6b0c90645c for instructions on how your PC might be enabled to meet this requirement. Graphics card Compatible with DirectX 12 or later with WDDM 2.0 driver. Display High definition (720p) display that is greater than 9” diagonally, 8 bits per color channel. Internet connection and Microsoft account Windows 11 Home edition requires internet connectivity and a https://account.microsoft.com/account. Switching a device out of Windows 11 Home in S mode also requires internet connectivity. https://support.microsoft.com/help/4020089/windows-10-in-s-mode-faq. For all Windows 11 editions, internet access is required to perform updates and to download and take advantage of some features. A Microsoft account is required for some features.1.7KViews0likes0Comments- 777Views1like3Comments
Re: SSMA for Oracle - Conversion report errors
sumitkumardhar Hi and good day to you! First congratulation on going for Microsoft technologies (I dont like Oracle p-sql language) 1)I heard about all kind of data, app migration while I was a consultant in IT. 2)They must be planned carefully...data maps, could require manual data migration (in my time also used dts package to implement data code (super data flow agent with code) 3)Last scenario is using raw low level data transfer agent Hope this helps...congratulations again for opting for Microsoft.1.8KViews0likes0CommentsRe: How to increase SQL query performance of a view?
kevinconseil Hi Kevin I1)f you want to use a view (slow) then you can put indexes on the view on the columns which are used in the join clauses. 3)You can also create indexes on the columns of the tables of the view, that are used in the join clauses 4)Stores procedures are usually faster then views because they are compiled article: https://www.techrepublic.com/article/see-performance-gains-by-using-indexed-views-in-sql-server/ Hope this helps, Bye54KViews0likes2CommentsRe: transform data (ssis)
Hi and good day:) 1)When I first read the original post: I saw some 'confusion' which you where helped for. 2)When I read the last post about derived column it made sense 3)Still there is a 2% chance of error. 4)Maybe you should reformulate question with new data points (2) Have a great day1.5KViews0likes0Comments
Recent Blog Articles
No content to show