We have installed a load of new Windows 8 machines over the weekend, and the VB6/ SQL Server apps that ran fine before are running really slowly now.
My laptop is also windows 8 and the applications run fine from there.
They are currently located on a share on the server, but even copying them locally has no effect.
My own thought is that it is the link to the SQL Server which is causing the problem. but I may be wrong.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…