Viewing 15 posts - 271 through 285 (of 285 total)
Jason, am not really getting the link by Michelle Ufford.
Could you please post the link related the topic.
December 21, 2010 at 9:48 pm
ofcourse, if sql server thinks which ever is best, it will choose.
December 21, 2010 at 10:22 am
Basically, in OLTP system, parallelism is not a good thing. The fact is that, the overhead on the parallelism and sometimes, one thread has to wait for the other to...
December 21, 2010 at 10:00 am
Here we are getting the seeks, scans and lookups that been occured for the index. However, I am looking for something different like to list the procedure names using the...
December 21, 2010 at 9:53 am
I just wanted to share the below path too related the topic:
http://www.simple-talk.com/sql/performance/sql-server-statistics-problems-and-solutions/
December 21, 2010 at 6:12 am
This looks like very odd. Why do you need to convert datetime to numeric?
December 21, 2010 at 6:09 am
some of your data been inserting has more characters than the column can occupy.
Use try catch block and get the data.
December 21, 2010 at 5:10 am
Again no rule of thumb here. however, changing the recovery model to bulklogged would help you a lot
December 17, 2010 at 9:39 pm
I should thank you to route me to the right place.
So the point is that should not try the parameters to a variable in a procedure until we see a...
December 17, 2010 at 7:19 pm
Yes, I too guess so....
I was trying to explain the following:
Say, i have a procedure proc
Create proc proc(@param bigint)
AS
declare @param1 bigint
...
December 17, 2010 at 8:23 am
Adding few more....
If the two databases are in different servers, use linked server.
Import/Export Wizard is another option.
December 17, 2010 at 2:31 am
Try to configure the mail in Service account and check.
December 17, 2010 at 2:28 am
As per my experience , the answer is depends. Please do all the options like Exists, in and join and find out the best plan suits your query.
December 15, 2010 at 6:31 am
I read the following statement out from my googling...
"The regions within the memory pool are also highly dynamic. The SQL Server code constantly adjusts the amounts of the memory pool...
December 15, 2010 at 5:51 am
Hi Bhuvanesh,
Thanks for attending the question. I do not have any memory pressure in my server as the server has 120GB ram. However I can...
December 14, 2010 at 11:36 pm
Viewing 15 posts - 271 through 285 (of 285 total)