Viewing 15 posts - 76 through 90 (of 105 total)
Thank for the link. Auto growth was 10% every few second it was increasing the log. After i chnaged it to few mb the perfeomce has improved.
i have following code...
April 9, 2013 at 10:50 am
thanks for the link it was realy informative. I changed the setting after reading the artical.
My log fie is increasing a lot. 10MB every 8-9 seconds. What may be the...
April 8, 2013 at 8:11 am
if my table is customer having column col1,col2 ...
in the select query i want all the developners to access it in the query as
select customercode, customername
from mycstomer
instead of
select col1, col2
from...
April 8, 2013 at 7:31 am
In that case we need to create views for all the tables. Is there any other way?
April 8, 2013 at 4:00 am
Yes. I have installed Server is on my laptop and doing some testing
April 8, 2013 at 3:27 am
I have run folloing query from the site mention
WITH [Waits] AS
(SELECT
[wait_type],
...
April 7, 2013 at 4:33 am
I am not creating the temp tables. but i still see few created automatically. Hence wahanted to know from where are they getting created
April 4, 2013 at 5:30 am
Tbale is having many columns which are not referd in the query. Hence i had used these column names which specify what datatype they have in the table.
March 31, 2013 at 12:58 am
now when tried to test the command given by you, I ran the same quires mentione by me in my first post and it come out on its own...
March 13, 2013 at 9:29 am
Thanks for u quick reply.
I would like to know how do i find if system is blocking? Is there a query by which i can find out that blocking is...
March 13, 2013 at 9:10 am
Thanks. That what i have done,
Select coumn list fom table into newtable where ....
March 5, 2013 at 4:36 am
I have acheved it using a new table instead of view
Is there any better way?
March 5, 2013 at 1:46 am
I have aded index on child but still it takes long time and in execution plan it shows index seek.
February 20, 2013 at 9:27 pm
Viewing 15 posts - 76 through 90 (of 105 total)