Have you stepped through your C# code to see when your procedure is called and what parameters are being passed to it? Can you run the stored procedure in SSMS...

Your best bet would be to restore a copy of your database to a test server and then run your tests on it and time them as you do them.

The maintenance jobs will run using the SQL Agent account. So if your maintenance plan is dealing with network resources (e.g. saving backups to a remote server) then make sure...

Offhand, it sounds like you either have an open transaction running somewhere or you have a maintenance plan that is trying to do maintenace of your database in the background...

If you change the linked server "LINK" to connect to your Oracle DB as ORACLEUSER2 are you able to run the following query successfully?

select * from LINK..ORACLEUSER2.TABLE2

If so, then I...

Assuming that permissions are not an issue when accessing the "ORACLEUSER2" schema, all you have to do is create another synonym:

CREATE SYNONYM table2@link FOR LINK..ORACLEUSER2.TABLE2

I used to support a database that was used globally and ran into a similar situation where people from the other sites would leave the company and I wouldn't be...

Dan, If you create the temp table first, your dynamic SQL statement will be able put records into it and you will be able to access them after the statement...

halifaxdal, I believe you could also create the start of the temp table outside of the dynamic sql stmt with just the DocId column. Then change your dynamic sql stmt...

thanks for the article John! To ironzenberg's point, you could cut down the number of calculations by adding a where b.ticker > a.ticker to the join.

Umar, to schedule a SSIS package, simply create a new job in SQL Server and select Integrated Services Package as the type of code to run (vs the default TSQL)....

Hi Rajat,

Depending on your needs, you could add the new column as nullable. This will allow the column to be added very quickly to the table. Then update the values...

Anytime you specify a static value in a SELECT clause, you do not include it in your GROUP BY clause. I hope that helps you out.

All you have to do is remove tipo_mon from the group by clause in the first case when you specified 0 for its value.

We have been using RedGate's SQL Backup here at work for a few years now and have had no problems with it. On average, we see around 70% compression on...