Viewing 15 posts - 41,146 through 41,160 (of 49,571 total)
Grant Fritchey (2/10/2009)
You shouldn't have to do anything to clean out a transaction log that is in simple recovery. It will happen automatically.
Indeed. If the log space is not...
February 10, 2009 at 1:08 pm
gupta1282 (2/8/2009)
now I want to start my carrier as a sql server dba.
Why do you want to be a DBA? What is it about that career that attracts you?
February 10, 2009 at 9:49 am
I would recommend that you restore the entire database. If you don't have a filegroup backup (and log backups from the time of the full), it's going to be hard...
February 10, 2009 at 9:47 am
Can you post the table and index definitions and the execution plan (saved as a .sqlplan file, zipped and attached)?
February 10, 2009 at 9:35 am
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...
February 10, 2009 at 9:34 am
Do you have a backup?
February 10, 2009 at 9:28 am
That's not a SQL error. That looks like something IIS will throw.
Are you the developer?
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...
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...
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.
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...
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?
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...
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...
February 10, 2009 at 8:21 am
samsql (2/9/2009)
..PAGEIOLATCH_SH 6:1:332096
PAGEIOLATCH_EX ...
February 10, 2009 at 8:16 am
Viewing 15 posts - 41,146 through 41,160 (of 49,571 total)