Viewing 15 posts - 271 through 285 (of 405 total)
Set up a trace and identify any query that hurts performance
December 9, 2009 at 2:57 am
Did you execute CheckDB as Gail suggested?
December 7, 2009 at 2:23 am
Does it open in management studio? are being able to execute the script?
December 4, 2009 at 7:05 am
binu
May be your account does not have appropriate permission.
Also can be a corrupt installation.
Create a .sql file using notepad and try double click it to open. Are you able to...
December 4, 2009 at 6:49 am
Micheal,
Do you see any additional message in the error log?
How do you take backup? Gui/T SQL? Local or network?
December 4, 2009 at 6:10 am
webrunner (12/3/2009)
What is strange is that the database backup files are in their correct locations. So it looks like the backups completed successfully. Yet the error has me uneasy that...
December 4, 2009 at 12:38 am
Tim Wilson-Brown (12/3/2009)
The big question is - what happens when there are 5 salespeople?
Tim, what you suggested will work for 5 people also, I think.
Declare @rank_test table
(
id int identity(1,1),
data...
December 3, 2009 at 10:37 pm
500000 records is not a big table.
1) What is your configuration.
2) Please post the query and its execution plan to see if any indexes can help
December 2, 2009 at 11:01 pm
This may not be optimal, but might help you
Declare @rank_test table
(
id int identity(1,1),
data varchar(250),
sales_man int null
)
insert into @rank_test(data)
select top 60 name from syscolumns
-- For the first salesman
update @rank_test...
November 30, 2009 at 12:42 am
What about the table that the procedure reads from? Does it change frequently? Some times when data changes enormously, the statistics becomes stale, the execution plan also becomes less suitable.
November 27, 2009 at 4:29 am
I copying is the problem, you can take a striped backup. Though its not advisable for regular backup plans (I corrupt file make whole set useless),
you can use this for...
November 25, 2009 at 5:39 am
Log backups will not reduce the size of the log file. It will only clear the file so that it can be reused
Run DBCC SQLPERF('LOGSPACE')
You will see the percentage used
November 25, 2009 at 5:02 am
Ajay,
What others are telling is right. If you are just looking at the possibility its fine. But you have plan to do it right out on a production database, I...
November 25, 2009 at 4:47 am
November 25, 2009 at 4:35 am
Viewing 15 posts - 271 through 285 (of 405 total)