Viewing 15 posts - 41,101 through 41,115 (of 49,552 total)
Krishna (2/11/2009)
Set the DB on single user mode :alter database msdb set multi_user with rollback immediate
Don't you mean set single_user with rollback immediate
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 11, 2009 at 5:00 am
How many rows are those deletes going to affect?
You're running that in a transaction, but there's no error handling at all. The commit is always going to fire, regardless of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 11, 2009 at 4:57 am
I think you may have to contact Customer support on this one.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 11, 2009 at 4:53 am
Eswin (2/11/2009)
can you please tell me more on statistics and how to use it for improving performance.
http://sqlinthewild.co.za/index.php/2008/11/04/what-are-statistics-and-why-do-we-need-them/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 11, 2009 at 4:11 am
If you're really feeling brave, open the mdf in a hex editor and look for the version stamp in the database header page. You're on your own for figuring out...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 11, 2009 at 4:09 am
What's blocking the query?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 11, 2009 at 4:06 am
Andrew Reilly (2/11/2009)
Is it me or are these posts getting random ?
I've been noticing the same kinda thing. There's really weird stuff getting asked at the moment.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 11, 2009 at 4:05 am
tendayit (2/10/2009)
What is the limit on the number of records sql 2005 table accommodate?
How many rows can you fit in 500 000 terabytes?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 11, 2009 at 4:02 am
Can you post the full error message please. Also check the SQL errorlog and the SQL Agent errorlog and see if there's anything more?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 11, 2009 at 4:01 am
What showed 4 logical reads?
set statistics io on
go
select * from t where id<='00001'
Results:
Table 't'. Scan count 1, logical reads 2, physical reads 0, read-ahead reads 0, lob logical reads 0,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 11, 2009 at 4:00 am
jabba (2/11/2009)
This was run at 2 in the morning where database activity should be minimal and no other jobs are being run.
Was SQL Agent running? If so, that's what had...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 11, 2009 at 3:36 am
ashy4blue (2/10/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 10, 2009 at 11:26 pm
Adonia Delavigne (2/10/2009)
Since then I have been getting error messages when I try to access maintenance plans , agents, alerts and so on.
What errors?
Does have SPs installed make any...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 10, 2009 at 11:22 pm
viduvs (2/10/2009)
But in case if it is possible to reduce excution time significantly by executing it directly on the server, so we were looking for this solution.
Tricks like that might...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 10, 2009 at 11:18 pm
guptaajay1985 (2/10/2009)
Why we use NDF file...
Have a read through of Books online, all sections on files or filegroups.
No need to repost after 30 min. This is a forum, not a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 10, 2009 at 11:08 pm
Viewing 15 posts - 41,101 through 41,115 (of 49,552 total)