Viewing 15 posts - 44,446 through 44,460 (of 49,552 total)
As I said above, I'd do checkDB first, as there's little point in trying to rebuild indexes of a database with corruption. Also, it's very likely that the index rebuild...
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
September 17, 2008 at 7:05 am
The equality/inequality refers to how the columns are used in the query that resulted in the missing index entry.
Generally, if you are going to use the missing index stats DMV...
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
September 17, 2008 at 6:35 am
It's not a SQL 2005-specific problem. The error (specifically the state) is saying that the database requested by the login isn't available, either because it's not there, is offline or...
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
September 17, 2008 at 6:34 am
What Brad is saying is that in active/active, you are running two difference instances, one on each node. It's not possible to run one instance on both nodes at 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
September 17, 2008 at 2:11 am
They'll have to have different names. Both instances are installed on both nodes, although they're only active on one at a time.
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
September 17, 2008 at 1:40 am
It's not unusual (in SP4 of SQL 2000) to see self-blocking. It's usually nothing to worry about. It may indicate parallelism or just that part of the query execution is...
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
September 17, 2008 at 1:32 am
Christopher Stobbs (9/16/2008)
Hi Gila,I'm South African, but not currently in SA, would I be of any help to your 🙂
Thanks
Chris
Would you be willing to do a presentation via Live Meeting...
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
September 17, 2008 at 1:32 am
I know someone in that area. I'll drop him a note, see if he's interested.
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
September 17, 2008 at 1:28 am
Terri .K Wei (9/16/2008)
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
September 17, 2008 at 1:20 am
I'd run it before. There's not much point in doing expensive maintenance on a database that's corrupt. If there's any corruption present, the reindex would probably throw errors anyway.
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
September 17, 2008 at 12:58 am
No impact other than that you will no longer be able to take log backup and hence will not be able to restore to a point-in-time after switching to simple....
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
September 17, 2008 at 12:57 am
Good to hear.
Yeah, replication can be a pain sometimes. Glad you came right.
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
September 17, 2008 at 12:52 am
I'll give it a try, but it won't be in the next couple of days. I've got *real work* that needs doing :crying:
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
September 16, 2008 at 11:23 am
It's as easy as changing the properties of the server, no hacks necessary. A restart of the SQL instance is required for the change to take effect
All SQL logins will...
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
September 16, 2008 at 11:21 am
I wouldn't call 200000 rows small. 🙂
Check the number of pages in the table. Don't worry too much about tables with < 100 pages.
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
September 16, 2008 at 11:15 am
Viewing 15 posts - 44,446 through 44,460 (of 49,552 total)