Have you considered using a tool to simulate requests?  Some DBA's are cynical about performance claims.  Sometimes vendor examples are designed to support the solution being offered by salesmen.  I've...

You could row multiply and summarize across large sequences using a tally function and it wouldn't matter which db instance.  These peg the cpu at 100%.  If you'd like it...

Thanks for the advice, Ill look into that.

We have a caching issue with our site which can make it extremely slow at times, but I think the main issue...

Is Zoho slow or is your site slow or are both slow?  One way to gain some traction over the situation could be to recreate the data flow without the...

The sample data didn't contain any duplicates so I added a few.

DROP TABLE if exists #mytable;
go
CREATE TABLE #mytable(

Id INTEGER NULL

,Empid INTEGER NULL

,CatId INTEGER NULL

,age NUMERIC(5,2) NULL

,Type VARCHAR(5)...

The alternate way to pass structured data to a stored procedure is json.   Imo json is the way to go.

Well, you could use Visual Studio.  In System.Web.Helpers there's something called WebGrid.  You could put one of those on each page.

The type of the object (in C#) assigned to the SqlParameter is DataTable.  The SqlDbType is SqlDbType.Structured.

SqlParameter lts = SqlCmd.Parameters.Add("@logged_times", SqlDbType.Structured);
lts.Direction = ParameterDirection.Input;
lts.Value = DataTableConverter.ToDataTable(model.Values);

I don't think the OP has explained very precisely what the problem is. Why do they only want ProductId 101? Why does this take presidency over ProductId 102? Why does...

Is it really necessary to use a merge statement?  Why not something like this?

DROP TABLE IF EXISTS Test_Products;
DROP TABLE IF EXISTS Test_UpdatedProducts;
GO
CREATE TABLE Test_Products(ProductIDint, ProductName varchar(10), Rate...

So this...

if @x=1
begin
return 'xyz';
end
else
begin
return 'abc';
end

...is preferable to?

            
December 13, 2019 at 10:27 pm
            
#3707801

            
            
                                                
        

These are temporal tables?  When you look at the table name in SSMS it says "TableName (System-Versioned)"?

Is id the primary key of jobs?

Is siteid the primary key of SiteAddresses?

To get the columns from both tables onto a single row you could use CROSS JOIN.  It works...

Is this the documentation you're looking for?

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine?view=sql-server-2017

It's possible to pass a user defined table type to a stored procedure as a readonly parameter.  This code defines a table type called test_type1.  The procedure dbo.test_proc1 declares a...