The table I had mentioned is just for an example.
It shows the functionalities that you get if you wish to script a table might be for testing on local...

Yes the plans are different and with select count(1) I do not see other columns being pulled up.
That is my question, whether the execution of the query underlying cte...

Again bringing out the same issue.
There are 2 ec2 instances with Sql server installed, one is prod and other is staging, they both have same machine configurations and same...

Yesterday, we ran a batch of 3000.
And enabled the profiler to capture the sql query, time taken, cpu, reads etc.

All 2999 inputs ran as expected, however the...

Hi Gail,
Posting the code might not be possible.
However, when I am running the same code for any one input, the code is taking usual time and nothing looks...

I use to call this powershell script via batch file.

Here is the code for the batch file

@echo off

powershell -executionpolicy bypass -File C:\Users\mayank\Documents\Powershell\SqlMisc.ps1

pause

Just change the path for the powershell script

This assembly is required to call filesave and folderdialog box via powershell.

Do you latest .net framework installed on your machine ?

Thanks !!

If you do an update and something goes bad in the back end before the update is committed, you still need the old data. This would make rolling back...

With a fill factor of 0, the page would be full and hence the update will cause page to split. That is understood

Now when I delete the row and re-insert...

Ohh, I didn't mean to sound rude.

My bad, if my words expressed a different meaning.

I was doing some code runs with different scenarios and I guess I came around some...

Expecting some replies here

It is 0

However I can see some free 4096 bytes on the page before making the update

I guess my explanation was not succinct. The problem that i have occurs when a query takes longer than usual to execute due to an issue that results from...