Viewing 15 posts - 44,011 through 44,025 (of 49,552 total)
I'll add one more to the list.
Disaster recovery
- Know how to fix corruption
- Know what to do when someone drops a table (though if you've done the security...
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 6, 2008 at 7:13 am
No.
You can detache and reattach the DB and it may get a different database ID, but no way to set which one it gets.
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 6, 2008 at 7:10 am
No, because datalength already takes unicode/non-unicode into account.
SELECT DATALENGTH('abc') returns 3
SELECT DATALENGTH(N'abc') returns 6, because it's a unicode string and hence requires 2 bytes/character
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 6, 2008 at 7:07 am
The problem with express is that it doesn't have SQL Agent and hence cannot run any of the replication jobs. I don't know if it's possible to run all 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
October 6, 2008 at 7:01 am
Somehow I don't think indexes are going to help. From what I can see, none of the conditions that may be in the where clause are sargable. All of 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
October 6, 2008 at 6:54 am
The recommended way to fix corruption is to restore a clean backup. Repair should be a last resort when there is no good backup available.
p.s. Rebuild your indexes after 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
October 6, 2008 at 6:47 am
As far as I know, only two of the TS exams are currently available (432 and 448) The third of the TS exams (433) is in beta. I think that...
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 6, 2008 at 6:45 am
DECLARE @MaxID INT
SELECT @MaxID = Max(ID) FROM Customer
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 6, 2008 at 6:35 am
Does the script you posted here (http://www.sqlservercentral.com/Forums/Topic581019-146-1.aspx) not work?
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 6, 2008 at 6:34 am
Replace sys.databases with sysdatabases. Replace sys.server_principals with syslogins and replace sys.database_principals with sysusers
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 6, 2008 at 6:30 am
Looks like the took the 'don't use distinct' to heart too. Guess they didn't realise that a group by with no aggregations does exactly the same thing
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 6, 2008 at 6:22 am
Very quick first glance.
There are two places with very bad estimates:
The clustered index scan of Inv_AeX_AC_Client_Agent, which estimates 1901 rows and gets over 6000. It may be that...
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, 2008 at 1:59 pm
Cool. I'll take a look and get back to you tomorrow or monday. It's late here.
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, 2008 at 1:39 pm
That's odd, because merge replication doesn't use the transaction log. Transactional replication does to track changes from the publisher. According to the opentran output you posted earlier, there are definitly...
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, 2008 at 2:03 am
Security checks: Do any of the fixed database or server roles have members that they shouldn't? Are a large number of unexplained login failures occurring?
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, 2008 at 2:12 pm
Viewing 15 posts - 44,011 through 44,025 (of 49,552 total)