Viewing 15 posts - 8,311 through 8,325 (of 49,571 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...
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...
July 31, 2014 at 3:20 pm
If you want to wait, that's WAITFOR with either delay or time.
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.
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)
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...
July 31, 2014 at 8:18 am
Use Ola's scripts. No point in redoing all the work he's done.
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...
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...
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.
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...
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...
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...
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.
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...
July 30, 2014 at 12:25 pm
Viewing 15 posts - 8,311 through 8,325 (of 49,571 total)