I think this falls under an "it depends" window. What problem are you trying to solve?  Is a single customer complaining about performance?  are multiple clients? are all clients?  are...

While I do agree with you, I've seen strange behavior like that before.  I cannot think of or provide a case where it happened, but I've seen where performance improves...

Hello keneangbu,

My first piece of advice would be remove the cursor.  Cursors are inherently slow.  In your sample piece of code, I do not see a nice way to kill...

Just because it works in 1 browser doesn't mean it is not a configuration issue.  Each browser may interpret the redirect differently or may even be ignoring it.  I've been...

Error 5 is access is denied.  My first step would be to check what user the SQL Server service is running under and make sure that account has permissions.

If this...

Going over to scdecade's solution and doing a bit of tweaking to it, would this not work:

DROP TABLE IF EXISTS test_table;
GO
CREATE TABLE [test_table]
(
    [projectid]...

When I am installing SQL Server on a server, I usually copy the contents of the DVD to the machine.  This allows me to install new instances quickly and easily...

I believe powershell can handle that, but most setup applications have silent options so powershell may be overkill for it.

That being said, I would be more concerned about why your...

If you are wanting to do it manually, I believe this query should help (may want to tweak it a bit to suit your specific needs):

SELECT
 ...

Sorry for the delayed response, but that is the method I would use.  Basically exactly the code you have.

Then before you do the delete, do a quick check to make...

You would need the same logic in your delete.  Your insert and delete logic should be the same or you will either insert data that isn't deleted (resulting in duplicate...

Can you have duplicate OperatorID's in the Transaction table?

try running the following query on the Transaction table:

WITH duplicateCheck AS
(
SELECT OperatorID, count(OperatorID) OVER (PARTITION BY OperatorID) AS OperatorCount
FROM...

I still see that link taking me to an article about Data Compression Double Take which seems different than SQL and T-SQL for Beginners or is that where it is...

• This reply was modified 6 years, 5 months ago by Mr. Brian Gale.

With the sample hourly rate being 10,000, I was just trying to make sure I picked a value that was substantially large enough to cover almost everything possible in the...

Do you need this to be "real time" data or can you load the data into some system (Hadoop, SQL Server, Oracle, etc) on a nightly basis?

I am not the...