Viewing 15 posts - 8,311 through 8,325 (of 49,552 total)
salomon.frid (7/31/2014)
Truth be told, is part of what I am trying to find out as well 🙂
Go and ask them. They're the ones making the claim, the burden of proof...
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
July 31, 2014 at 3:21 pm
salomon.frid (7/31/2014)
I am aware of that one, just some people in my shop have told me that is not the preferred way of doing this ...
So according to your local...
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
July 31, 2014 at 3:20 pm
If you want to wait, that's WAITFOR with either delay or 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
July 31, 2014 at 3:02 pm
Back up databases
Script logins (with SIDs and passwords)
Script any linked servers
Script any jobs
Copy backups, restore on new server, run the scripts you created.
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
July 31, 2014 at 12:10 pm
SQLRNNR (7/30/2014)
Try these guys...
If your company is paying, this. If your company is not paying, this (it's that good)
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
July 31, 2014 at 11:32 am
Roland C (7/30/2014)
autoexcrement (7/30/2014)
UPDATE GLAMFSET Activesw = 0
WHERE ACCTID NOT IN
(SELECT ACCTID from GLPOST)
:exclamation: This query will work fine is GLPOST is not empty. But if it is empty, 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
July 31, 2014 at 8:18 am
Use Ola's scripts. No point in redoing all the work he's done.
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
July 31, 2014 at 8:03 am
Please remember that the point of in-memory is to improve *massively concurrent* inserts, not single inserts of large numbers of rows. If you don't have massive numbers of concurrent inserts...
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
July 31, 2014 at 8:02 am
Lynn Pettis (7/31/2014)
Okay, he has the memory;Size of the table: 195 GB
Number of Indexes: 90
220GB memory is allocated only for the sql server....out of total 260 GB Server memory
No way...
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
July 31, 2014 at 6:34 am
That's one of the points in my DB corruption presentation. Don't assume everything's OK. Don't assume that the backups are succeeding just because you're not getting backup failure messages.
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
July 31, 2014 at 6:32 am
Alvin Ramard (7/30/2014)
WAIT!!!! What kind of database MUST be repaired regularly???? :w00t:
MS Access ones.
That actually is correct advice, for an MS Access database (as in Access tables) used...
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
July 31, 2014 at 6:30 am
Koen Verbeeck (7/31/2014)
Lynn Pettis (7/30/2014)
Really?? Let's put a 500 million row table into an in-memory table.I'd rather use a clustered columnstore index.
Depending on how heavily read/modified it is...
Clustered columnstore and...
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
July 31, 2014 at 6:28 am
lescobar (7/30/2014)
Hello everyoneI have two sql servers
It is setup as a mirror databases
1) database 1(principle, synchronized)
2) database 2 (Mirror, Synchronized / Restoring)
Nothing wrong there. That looks like a mirroring...
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
July 31, 2014 at 6:25 am
It would probably help if we had table definitions. I can't quite figure out what comes from what table.
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
July 31, 2014 at 6:24 am
GrassHopper (7/30/2014)
that did not work. Running a recovery application on the file and it is recovering the db. It must be corrupt.
No. Corrupt databases do not give 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
July 30, 2014 at 12:25 pm
Viewing 15 posts - 8,311 through 8,325 (of 49,552 total)