Viewing 15 posts - 39,271 through 39,285 (of 49,552 total)
sumanta.roy52 (5/6/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
May 6, 2009 at 6:42 am
ajitkumarng (5/6/2009)
Try shrinking database
Bad idea. Lots of side effects and, besides, if the log is full it won't do anything other than fragment indexes.
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
May 6, 2009 at 6:38 am
SQL Server doesn't have versions 4.01 or 5.01. Are you sure it's Microsoft SQL Server that you're working with and not MySQL? Your comment about studying PHP and MySQL suggests...
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
May 6, 2009 at 6:27 am
ALZDBA (5/6/2009)
I've tested in on SQL2008 SP1. (10.0.2531.0 (Intel X86) )
It gets even worse if you explicitly use the ID column in the filtered index...
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
May 6, 2009 at 6:18 am
SQL-KV (5/6/2009)
But i received only this : (after running the command - which you have given.)Command(s) completed successfully.
That means there's no corruption, which is a good thing.
But i wish i...
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
May 6, 2009 at 6:17 am
If you have database mirroring, the recovery model cannot be changed from full. The only way you can achieve what you want is to completely drop the mirroring, switch the...
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
May 6, 2009 at 2:48 am
No worries Jeff. By digging up proof for you I learned some stuff about filtered indexes too. 😀
Sheng, I chatted with some friends about this. It appears (though I haven't...
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
May 6, 2009 at 2:11 am
Please run a full checkDB on that database. By leaving out the indexes you may be missing corruption, especially since the error says that it's possible index corruption.
DBCC CHECKDB (<...
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
May 6, 2009 at 2:04 am
Does the login you are using have rights on that DB?
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
May 6, 2009 at 2:03 am
juan_wiski (5/5/2009)
When you use several views that each one of then has several tables plus Cumulative queries. That's how!
Ouch. That's just asking for performance issues, from the compiling if nothing...
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
May 6, 2009 at 1:57 am
Steve Jones - Editor (5/5/2009)
Well here's a nice April Sat morning in Denver:http://lh3.ggpht.com/_8hTidvPiTuU/SgCqmUxlXLI/AAAAAAAAAiI/pxf8WYs9zH0/s512/Apr_snow_a.jpg
And here's lunchtime:
http://lh5.ggpht.com/_8hTidvPiTuU/SgCqmB_QA8I/AAAAAAAAAiA/VMCiDCZDEa0/apr_snow3.jpg
And here's late afternoon:
http://lh3.ggpht.com/_8hTidvPiTuU/SgCqlzeT1vI/AAAAAAAAAh4/XmnjzlFDV0w/apr_snow2.jpg
It was gone by Monday.
Cold, cold, cold.
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
May 5, 2009 at 3:27 pm
steve smith (5/5/2009)
Nice pix - is that YOUR car, Gail?
No. That's not my blog I linked to.
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
May 5, 2009 at 3:24 pm
This is what snow in Johannesburg looks like
http://dotnet.org.za/codingsanity/archive/2007/06/27/snow-in-johannesburg.aspx
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
May 5, 2009 at 1:54 pm
It snowed here two years ago, for the first time in almost 26 years.
There was this light sprinkling of white powder over grass, plants and other surfaces which melted as...
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
May 5, 2009 at 1:48 pm
tdunbar (5/5/2009)
My post is indicative of how desperate I am to learn what others provide their management.
Maybe you should ask your manager what information he needs to see. It...
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
May 5, 2009 at 1:18 pm
Viewing 15 posts - 39,271 through 39,285 (of 49,552 total)
