Viewing 15 posts - 41,131 through 41,145 (of 49,552 total)
Turn AutoShrink OFF!
Shrinking a database regularly is a terrible thing to do. It just has to grow again and that growth is going to slow things down. Repeated shrinks and...
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
February 10, 2009 at 9:34 am
Do you have a backup?
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
February 10, 2009 at 9:28 am
That's not a SQL error. That looks like something IIS will throw.
Are you the developer?
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
February 10, 2009 at 9:21 am
The path to the tran log is irrelevant, though it's set when you create a database. The log is part of the database and if queried is as part of...
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
February 10, 2009 at 9:12 am
amarbreddy21 (2/10/2009)
Clustering does not guarantee a complete absence of downtime(Power failures)
It can if there's a failover SAN and the nodes are in different server rooms (different buildings). Plus for complete...
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
February 10, 2009 at 9:08 am
Grant Fritchey (2/10/2009)
I "corrected" the wrong thing and then recorrected the wrong thing only to realize I had the first view definition correct... I give up.
Lol. More coffee needed.
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
February 10, 2009 at 8:51 am
Grant Fritchey (2/10/2009)
Wait, no I didn't. More coffee, that's the answer.
More coffee is an acceptable answer to many problems. I didn't read your post in detail, so I don't know...
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
February 10, 2009 at 8:43 am
High availability, total server failover, hardware redundancy.
So what are all the disadvantages of clustering and what do you suggest as a replacement?
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
February 10, 2009 at 8:39 am
tran008 (2/10/2009)
so if I put the order by in the view...both select statement in general perform the same?
If you put just an order by on a select in a...
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
February 10, 2009 at 8:24 am
noeld (2/9/2009)
IF you are running this from stored procedure you can use "WITH RECOMPILE"
Recompile won't help where there are variables. Recompile is for when the plan is not optimal because...
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
February 10, 2009 at 8:21 am
samsql (2/9/2009)
..PAGEIOLATCH_SH 6:1:332096
PAGEIOLATCH_EX ...
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
February 10, 2009 at 8:16 am
GSquared (2/10/2009)
Bruce W Cassidy (2/9/2009)
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
February 10, 2009 at 8:15 am
viduvs (2/8/2009)
This stored procedure uses cursor to perform this data migration.
That's possibly one of the reasons for the slowness. Why a cursor?
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
February 9, 2009 at 1:28 pm
Gunjan (2/9/2009)
Yes. That's what I have used to consume WCF service.
Why?
SQL is a database engine, not an application server. Why is the database calling WCF services?
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
February 9, 2009 at 1:25 pm
Vijaya Kadiyala (2/9/2009)
What if the table already exists, so in this case we have to use Update Statement right!!
Why?
Alter Table Add .... and add the computed column to the...
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
February 9, 2009 at 1:21 pm
Viewing 15 posts - 41,131 through 41,145 (of 49,552 total)