I been performance tuning an OLTP system which is built with Visual Basic Front end, Microsoft Components middle tier and SQL Server back-end for DBMS.
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect - Engineering
Unable to Delete Records in using API Cursors
I am not very familer with the internals of API Cursors; so this was an annoying problem to solve. I was working with web guy,
SQL 2000 Reporting Server Issue with Print Control
Just finished configuring SQL 2000 Reporting Server in Dev/Test/Production environment with issues with printing. But when users tried to print they got the following error:
SQL Server Integration Services Issue (Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum))
TITLE: Microsoft SQL Server Management Studio —————————— Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 —————————— ADDITIONAL INFORMATION: The SQL server
Adding new disk resource to cluster
My current configuration includes two node cluster with active-passive configuration. I had requested the Storage team to add a new LUN to the Cluster so
Error 191: Some part of your SQL statement is nested too deeply.
When inserting string into SQL Server table using the INSERT predicate that uses string concatenation there seems to be an issue with in SQL Server
SQL Canada (SQLCAN) 