Viewing 15 posts - 8,326 through 8,340 (of 22,224 total)
A copy of the database just exports the scripts to define the tables. It's not going to export any other settings such as the current identity. You can use DBCC...
"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 29, 2014 at 6:26 am
First, please, for clarity's sake, rename that index. Anytime I open a server and see _dta at the start of an index, I almost want to cry.
I would suggest 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 29, 2014 at 6:24 am
You've just defined what stored procedures are used for. You give access to insert data through a stored procedure, but not through the table directly. That way you can control,...
"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 29, 2014 at 6:14 am
The thing is, I think the technology is amazing, but, it's really all about the ability to collect data and feed data out at high speed in an OLTP environment....
"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 29, 2014 at 6:11 am
There's no real way to dynamically capture statement times within the execution unless you output to a variable before and after a statement starts & stops. Otherwise, to capture statement...
"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 10:50 am
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
Viewing 15 posts - 8,326 through 8,340 (of 22,224 total)