Viewing 15 posts - 16,291 through 16,305 (of 49,552 total)
Honestly, you shouldn't be using your backup plans to monitor for drive space. There should be existing alerts and the DBA should have known long before a log backup would...
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
October 4, 2012 at 9:57 am
No, you won't see anything wrong with that query. The cause of the problem is that the nonclustered index is missing a row
Drop the nonclustered index idx_AssignmentRoot_RepName and then recreate...
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
October 4, 2012 at 9:53 am
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Run it and post the results. Doesn't sound serious.
Run the same on SQL 2000, see if that returns any consistency errors.
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
October 4, 2012 at 6:29 am
As soon as snapshot isolation is allowed (alter database ... allow snapshot isolation), row versions get stored regardless whether any queries are running in snapshot isolation or not.
With snapshot...
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
October 4, 2012 at 6:22 am
There are simple examples in Books Online.
Seriously though, for the security of your data, please spend some time reading up on hashes, salted hashes and how to properly secure passwords.
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
October 4, 2012 at 4:16 am
Ok, first thing...
Passwords should never be stored using reversible encryption. They should be stored using a salted cryptographic hash. In SQL, the hash function is HASH_BYTES. You may need 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
October 4, 2012 at 3:40 am
You may be able to script out logins first (with hashed passwords and SIDs), linked servers, server-level permissions. Some stuff might fail (we have no idea what the corruption actually...
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
October 4, 2012 at 3:37 am
dwain.c (10/3/2012)
Let's make that link a little easier to access:http://www.simple-talk.com/sql/database-administration/handling-deadlocks-in-sql-server/
Too bad it seems to be dead for me.
That's because you put the [/url] on a new line.
http://www.simple-talk.com/sql/database-administration/handling-deadlocks-in-sql-server/
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
October 4, 2012 at 3:12 am
70-433 has not been retired yet. It's going to be retired next July
http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-433&locale=en-us
Book it online via the Prometric website
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
October 4, 2012 at 3:08 am
Good to hear. Take a backup, restore that to SQL 2008 and run CheckDB there, make sure that comes out clean as well. It's just a test-restore, not your planned...
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
October 3, 2012 at 1:42 pm
It's worth noting this is much more difficult to fix on SQL 2008, so you want to fix it and get a clean CheckCatalog before upgrading.
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
October 3, 2012 at 11:42 am
It shouldn't, I've never heard of it happening before. If it has, it's a bug and needs to be reported to CSS, preferably with a reproduction.
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
October 3, 2012 at 9:33 am
Nice, that's exactly the thing you want to find before the upgrade, that's easy to fix on SQL 2000, very very hard on SQL 2008.
What is object 544525519 ? (check...
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
October 3, 2012 at 9:00 am
Alexander-449406 (10/3/2012)
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
October 3, 2012 at 8:52 am
PiMané (10/3/2012)
CREATE NONCLUSTERED INDEX ind1 ON T (id)...
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
October 3, 2012 at 7:15 am
Viewing 15 posts - 16,291 through 16,305 (of 49,552 total)