Viewing 15 posts - 18,736 through 18,750 (of 49,552 total)
I second the use of SQLCompare. It will likely work out cheaper to buy a license than to develop in-house.
If you absolutely must do custom dev, maybe a C#/VB app...
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
April 27, 2012 at 12:43 pm
Usually a dramatic increase in duration indicates that there is some form of corruption and that CheckDB ahs to go back and run more checks to identify exactly what is...
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
April 27, 2012 at 10:29 am
Lynn, take care in the 'Accidental DBA' thread, check the OP's history.
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
April 27, 2012 at 10:23 am
That doesn't answer the question.
Why do you need to insert one row at a time rather than inserting all the rows in one operation?
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
April 27, 2012 at 9:43 am
Start by reading the Books Online entry for bcp... Take special note of what kind of command it is (ie where it runs)
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
April 27, 2012 at 9:38 am
Grant Fritchey (4/27/2012)
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
April 27, 2012 at 7:55 am
ESAT ERKEC (4/27/2012)
and the this query is the most execute in the production server i want to improve performance....
The query executes in 0ms with ~20 reads. You are wasting your...
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
April 27, 2012 at 7:52 am
vinu512 (4/27/2012)
What does Scan Count represent then?
Nothing useful. I'd just ignore it.
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
April 27, 2012 at 6:43 am
vinu512 (4/27/2012)
ESAT ERKEC (4/27/2012)
perf1: Scan count 0, logical reads 23, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical...
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
April 27, 2012 at 6:15 am
15 or 23 reads, the difference is insignificant, and the times show that (0ms).
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
April 27, 2012 at 6:13 am
Maybe this: http://sqlinthewild.co.za/index.php/2011/03/22/statistics-row-estimations-and-the-ascending-date-column/
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
April 27, 2012 at 5:45 am
There are no DBCC commands to script tables out.
Scripting out data is fairly easy, just query the table and build insert statements. That said, if you're over a few...
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
April 27, 2012 at 4:36 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1291362-1063-1.aspx
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
April 27, 2012 at 4:14 am
Can you post the entire deadlock graph please? Just knowing the resources involved isn't very useful.
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
April 27, 2012 at 3:32 am
capn.hector (4/26/2012)
i wonder why the switch.
Because they don't have to pay license fees for MySQL? Seen that disaster more than once.
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
April 26, 2012 at 5:55 pm
Viewing 15 posts - 18,736 through 18,750 (of 49,552 total)