Viewing 15 posts - 34,666 through 34,680 (of 49,552 total)
I had one of those earlier in the week.
OP: Why is my database still Restoring... almost a day later?
Me: Because you ran the restore WITH NORECOVERY
OP: Oh.
I mentioned it on...
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
January 16, 2010 at 1:33 am
crainlee2 (1/15/2010)
In answer to your "Why?" question, it's because this particular programmer has no concept of the need for efficiency.
Nor appropriate data types, I would assume.
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
January 16, 2010 at 1:15 am
Get a copy of the database on a server that you do have access to and run upgrade advisor. Fix everything it complains about. Upgrade your test server to SQL...
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
January 16, 2010 at 1:13 am
mstjean (1/15/2010)
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
January 16, 2010 at 1:01 am
There should be something in the SQL error log on why the backup failed. Check and see.
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
January 15, 2010 at 11:34 am
andy 21711 (1/15/2010)
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
January 15, 2010 at 11:29 am
That will check every page in the database for corruption, check the schema, check the allocation information. If there's any form of corruption in the database it'll pick it up...
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
January 15, 2010 at 9:52 am
SELECT name as TableName, ObjectProperty(object_id, 'TableHasPrimaryKey') AS HasPrimaryKey
FROM sys.tables
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
January 15, 2010 at 9:47 am
You cannot create an index that has a varchar(max) as a key column.
CREATE TABLE Test (
id INT,
StringCol VARCHAR(MAX)
)
CREATE INDEX idx_wontwork ON Test (StringCol)
Msg 1919, Level 16, State 1, Line...
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
January 15, 2010 at 9:46 am
Logged as in written to the transaction log?
If so, yes. All operations are logged and there's no way to turn logging off.
If your database is in Bulk-logged recovery, the bcp...
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
January 15, 2010 at 9:39 am
tosscrosby-60625 (1/15/2010)
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
January 15, 2010 at 9:36 am
Run this on all databases that were on the SAN
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
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
January 15, 2010 at 9:36 am
kingscriber (1/15/2010)
As for the isolation level access to that table as serializable, there is no real reason why. I am not even sure why it determined that.
SQL doesn't decide on...
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
January 15, 2010 at 9:34 am
We can't help you with your fight with an interviewer. If you have problems with the questions, take it up with the interviewer if you can.
Transactional replication is configured exactly...
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
January 15, 2010 at 8:52 am
I'm going to stick this in the queue to be looked at over the weekend, cause deadlocks take time to work out.
As for the resources involved in the deadlock:
SPID 62:...
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
January 15, 2010 at 8:49 am
Viewing 15 posts - 34,666 through 34,680 (of 49,552 total)