Viewing 15 posts - 45,466 through 45,480 (of 49,571 total)
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic540764-364-1.aspx
July 25, 2008 at 3:41 am
Mike Baria (7/24/2008)
I'm embarassed to ask, but here-goes:
Don't be embarassed. We all had to start somewhere. The only stupid question is the one that's not asked.
July 25, 2008 at 1:13 am
Don't worry too much about using these on a dev server (that's assuming you have enough rights to use them in the first place)
Slow running queries won't hurt the...
July 25, 2008 at 1:11 am
MrBaseball34 (7/24/2008)
I guess I could if I knew *what* to tell them.
🙂 Basically, that form of query has no single optimal plan and it tends to confuse the query optimiser....
July 25, 2008 at 12:59 am
sharon.bender (7/24/2008)
July 25, 2008 at 12:23 am
DKG (7/24/2008)
As its a part of replication, some times the transactions which is already replicated doesn't get clear from transaction log.In that case it would get clear by::
sp_repldone
True, for the...
July 25, 2008 at 12:17 am
ALIF (7/24/2008)
this database is a subcriber, will it affect the replication. if we change it to simple recovery mode.
No. Just be sure you're happy with the recovery implications
July 24, 2008 at 11:22 am
Does table1 have a clustered index in either environment? If not, please run the following and check the value of Forwarded records.
DBCC ShowContig ('t1',0) WITH TableRESULTS
July 24, 2008 at 11:18 am
What recovery mode are you using?
Do you have regular transaction log backups?
Is the database published for replication
What does the following query return for the offending database?
select name, recovery_model_desc, log_reuse_wait_desc from...
July 24, 2008 at 11:12 am
MrBaseball34 (7/24/2008)
GilaMonster (7/24/2008)
For structures like that, WITH RECOMPILE may be...
July 24, 2008 at 11:11 am
ALIF (7/24/2008)
shrink tempdb,or
detach the file and attach with a new one with 0 bytes
Shrinking a file that's full isn't going to achieve anything. It has no free space in it,...
July 24, 2008 at 10:59 am
onlyanji4u (7/24/2008)
if your tempdb is full, try to change wherever places you use temporary tables with table variable.like DECLARE @temptb TABLE(id int,name char(10))
That's a common fallacy.
Table variables, like temp tables...
July 24, 2008 at 10:55 am
An 823 error is often indicative of hardware problems, especially considering the suspect database you had last week. 823 means that the OS issued a read on a page and...
July 24, 2008 at 10:36 am
Identical hardware?
July 24, 2008 at 10:23 am
MrBaseball34 (7/24/2008)
There are 946000 records in the table and it take 30+ seconds to return results. I'm pretty sure that I need an index.
Probably. The problem is with the multiple...
July 24, 2008 at 8:10 am
Viewing 15 posts - 45,466 through 45,480 (of 49,571 total)