Viewing 15 posts - 13,711 through 13,725 (of 49,552 total)
Hitatchi Replicator? Are you doing a geo-dispersed cluster with non-shared storage or something? Or SAN replication to a failover SAN/DR site?
March 26, 2013 at 9:59 am
I've done a failover cluster with an instance that had 1 600GB database and 1 1TB database. No storage problems (well, other than a badly designed very slow SAN)
The size...
March 26, 2013 at 9:49 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1435580-391-1.aspx
March 26, 2013 at 9:46 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1435580-391-1.aspx
March 26, 2013 at 9:46 am
If the DB is in full recovery, it needs regularly scheduled log backups to run all the time, not just when you run them manually.
March 26, 2013 at 9:18 am
There will always be at least one row with a status of 2.
What George is asking is whether the last row in the output has a status of 2.
March 26, 2013 at 9:14 am
Erin Ramsay (3/26/2013)
Row level compression? Page level compression? Breaking the fingers of whoever wrote the select *? I know that would make ME feel better.. lol
Row compression should help without...
March 26, 2013 at 9:11 am
Erin Ramsay (3/26/2013)
Oh sorry, Gail, I forgot to mention that there are no where conditions.. this is pulling the entire table back.
Ow, ow, ow!
Primary key and clustered index them. Primary...
March 26, 2013 at 9:08 am
Then the active portion of the log is at the end of the file. Wait a while, let more log backups run, try again to shrink later.
March 26, 2013 at 8:15 am
Maybe.
Depends whether you make the index covering (ie duplicate the table) which you probably don't want to do, depends what % of the rows of the table are returned by...
March 26, 2013 at 8:14 am
Not a known issue in that there's a kb and a pile of documentation. I've seen it in person once, seen it on the forums since 3 or 4 times...
March 26, 2013 at 7:13 am
What recovery model is the database in?
March 26, 2013 at 5:02 am
abitguru (3/26/2013)
SELECT * FROM Reque_pa WITH (UPDLOCK) WHERE EMPRE=1 AND CEREQ = 1UPDATE Reque_pa SET Proximo=107918, Pendiente=0 WHERE EMPRE=1 AND CEREQ=1
You're selecting, then updating the table with a fixed...
March 26, 2013 at 4:56 am
abitguru (3/26/2013)
I can't understand why I don't need to lock reque_pa with this implementation.
Because the select and the update are a single atomic operation and hence the locks SQL takes...
March 26, 2013 at 4:53 am
I would strongly recommend if you want an auto-incrementing column, use the identity property. If gaps are such a big problem (which they shouldn't be, the identity is a meaningless...
March 26, 2013 at 4:46 am
Viewing 15 posts - 13,711 through 13,725 (of 49,552 total)