Viewing 15 posts - 8,326 through 8,340 (of 22,219 total)
Chowdary's (4/28/2014)
Thank you so much Grant..Now am very much clear on that.
Still i am Expecting the Replies from Other Experts...
Thanks In Adv...
They may or may not respond. Gail provided you...
"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
April 28, 2014 at 7:28 am
Chowdary's (4/28/2014)
Because if we want to recover the Data Point_In_Time ,its not possible in that Simple Recovery Model.
If suppose Daily...
"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
April 28, 2014 at 7:09 am
TomThomson (4/25/2014)
Steve Jones - SSC Editor (4/24/2014)
rodjkidd (4/23/2014)
Hope the op and recovery go well. You gotta make it over for SQL Bits.Rodders...
On the shed-dyule for Bits, and planning on it....
"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
April 28, 2014 at 6:07 am
Lynn Pettis (4/27/2014)
"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
April 28, 2014 at 6:04 am
You have other issues going on. Make sure that you have, at minimum, automatic creation and maintenance of statistics enabled. You'll probably need to manually update them as well, but...
"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
April 28, 2014 at 6:02 am
Chowdary's (4/28/2014)
From your replies i came to know 2 main things to clear the Log File those are below
1> Need to take the Log Backup Frequently...
"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
April 28, 2014 at 5:54 am
There's also the distributed replay tool that came out with SQL SErver 2012. That's worth checking out.
"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
April 28, 2014 at 4:55 am
I'd have a separate telephone table. That way you can have more than one phone number for any given person AND you can assign a phone number to more than...
"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
April 28, 2014 at 4:34 am
Not seeing your code or how you're accessing stuff, it's hard to say, but, you could read up on Jonathan Kehayias' blog. He's pretty much the best resource out 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
April 28, 2014 at 4:29 am
Here, read this about the log [/url]to understand why it's always growing.
You need to either set your database to simple recovery, or get log backups in place.
"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
April 28, 2014 at 4:25 am
Since it's a dev box, I'd just do an in-place upgrade. I recently did one for my 2012 system to move it to 2014. It just worked. You do have...
"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
April 28, 2014 at 4:22 am
Excellent! Happy to share.
"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
April 25, 2014 at 6:57 am
They may be saying that, but you can't store data in the proc cache. You can't. It's an internal system memory space completely managed by SQL Server. It's not something...
"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
April 24, 2014 at 2:16 pm
Good to hear you have it all figured out. When operating with two different databases like that, another thing to keep an eye on is the statistics.
"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
April 24, 2014 at 2:12 pm
One of the best resources I've found on getting started with the in-memory databases. Tons of links to good articles.
"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
April 24, 2014 at 2:10 pm
Viewing 15 posts - 8,326 through 8,340 (of 22,219 total)