Viewing 15 posts - 5,506 through 5,520 (of 22,219 total)
Went back to the train wreck... uh, I mean Jet discussion.
I just keep hearing "MongoDB is web scale" over and over.
And if anyone searches that up, fair warning, the video...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 23, 2015 at 4:47 pm
Since we seem to be largely Godwin-free on The Thread, I thought I'd point out this really cool article about using data to test Godwin's Law (short version, the law...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 23, 2015 at 12:41 pm
Assuming there's a naming standard based on date & time, that's one way to check. Another is to use PowerShell, then you can look at the date on the file.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 23, 2015 at 11:31 am
But, if it's already dropping this single log backup (and please, note my concerns above), what more are you looking for?
You just have to reference the location and get the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 23, 2015 at 8:55 am
WayneS (9/23/2015)
Grant Fritchey (9/23/2015)
Good gosh. I went back and read through what I've missed. This guy is a classic troll. He's been fed so much I'm surprised he doesn't pop....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 23, 2015 at 7:57 am
Ed Wagner (9/23/2015)
Eirikur Eiriksson (9/23/2015)
Lynn Pettis (9/23/2015)
Steve Jones - SSC Editor (9/22/2015)
jasona.work (9/22/2015)
I keep going back to the "Jet" topic, it's like watching a train...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 23, 2015 at 7:19 am
Also, remember that if the load process is doing UPDATE/DELETE in addition to INSERT, that the indexes, especially any primary keys, may be very necessary to assist in finding the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 23, 2015 at 6:59 am
I'm with Anthony, why not just use log shipping. It's built into the product and will do what you want.
However, a couple of suggestions. First, check the msdb database. There...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 23, 2015 at 6:57 am
CREATE PROCEDURE, and nothing else, should not be placing locks on tables. Further, CREATE PROCEDURE, and nothing else, should complete on most systems in an extremely fast fashion.
Are you certain...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 23, 2015 at 6:50 am
That totally varies by company.
My last employer had four levels: Junior, DBA, Senior, Principal
We were part of the overall IT organization, under a VP responsible for Server Administration, SAN Administration...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 22, 2015 at 4:05 pm
If it's only a small chunk of the overall database, you might look into building an Integrations Services (SSIS) package to do the move. Otherwise, for a subset, it's probably...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 22, 2015 at 4:02 pm
jasona.work (9/22/2015)
I keep going back to the "Jet" topic, it's like watching a train wreck and I can't stop...
Absolutely NO intention of posting and feeding...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 22, 2015 at 12:41 pm
Alina.Sotnikova (9/22/2015)
Please, help me with this question.
Give an example of a business use case where the knowledge you need to store would be best stored in an SQL database....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 22, 2015 at 7:55 am
BL0B_EATER (9/22/2015)
Interesting, thanks for sharing your experiences. Deciphering the licensing document(s) is tough.
Yep. Pretty sure that's intentional.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 22, 2015 at 7:47 am
BL0B_EATER (9/22/2015)
Grant with your SA can you leave your production server up and running during a DR test (and bring up your SQL Server over at your DR site too)?
We...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 22, 2015 at 7:00 am
Viewing 15 posts - 5,506 through 5,520 (of 22,219 total)