Viewing 15 posts - 871 through 885 (of 3,232 total)
SQL Server will grab up all of the memory available to it. The performance of the database platform relies heavily on using the memory buffers for caching data, execution...
November 19, 2009 at 9:51 am
Just curious, what is the business reason behind this? Why would you want to do this?
November 17, 2009 at 3:40 pm
I've always forced our guys to define all temp tables at the beginning of the stored procedure. Interleaving DDL with DML causes the SPs to recompile. I was...
November 17, 2009 at 3:38 pm
There are many, many different ways to solve concurrency problems. You may consider looking into using a combination of Query Notifications and client code or using snapshot isolation. ...
November 16, 2009 at 4:56 pm
Edwin-376531 (11/16/2009)
I have three year of data with time stamp (2009-07-01 03:55.07.678) on it.
I wanted to split those data into a month per year.
How can I do that? ...
November 16, 2009 at 4:44 pm
Another thing. Since this has to do with a slowdown during a batch run, I'd also suggest running a Windows Performance Monitor session during the batch to see what...
November 16, 2009 at 3:47 pm
I have used sql profiler and created indexes but no use ,and statistics are on.
Now would it be helpful to post each table definitions used for the queries.
A couple of...
November 16, 2009 at 3:43 pm
There is not enough information here to help you. If you want good help on this, please read this article and post the necessary information to help you.
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Also, use...
November 16, 2009 at 12:18 pm
Yes, but the connection provider you choose may depend on the task type you want to use in SSIS. I use an ODBC connection when working with ExecuteSQL task...
November 16, 2009 at 9:32 am
That may be a better option depending on how many rows your SP is dealing with. The main difference between table variables and temp tables is that temp tables...
November 13, 2009 at 9:41 am
I believe so. Were there any errors or abnormal messages around the last time your server hung?
November 11, 2009 at 9:04 am
Have you checked into using Package Configurations? If not, search SSC for answers on that and you'll get a bunch of results. There are a few really good...
November 11, 2009 at 6:58 am
Does it call a nested SP or return different result sets based off of logic in the SP?
Can you post the SP code?
November 11, 2009 at 6:53 am
This has something to do with database mail. Can you check your database mail log and see if there are errors, especially near the times when you have the...
November 11, 2009 at 6:49 am
What do you get when you run this:
SELECT * FROM sys.service_queues
November 10, 2009 at 2:05 pm
Viewing 15 posts - 871 through 885 (of 3,232 total)