Viewing 15 posts - 8,956 through 8,970 (of 49,571 total)
Hmmm... guessing.... The log file and the backup files are on the same drive?
May 22, 2014 at 6:26 am
Please post table definitions, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
The view definitions will also be of great help
May 22, 2014 at 6:21 am
Disadvantage: Expensive, time consuming operation
Disadvantage: Done excessively will just force the database to re-grow, wasting more resources
Disadvantage: Massively fragments all indexes.
May 22, 2014 at 6:10 am
Yup.
Doesn't matter whether there is a subscriber. Doesn't matter if there are ten suppliers and half of them are offline. The log reader agent reads the publisher's transaction log and...
May 22, 2014 at 6:01 am
Please note: 4 year old thread, and repair allow data loss should never be the first suggestion and should never be suggested without an explanation of the effects.
May 22, 2014 at 5:01 am
Please note: 4 year old thread, and repair allow data loss should never be the first suggestion and should never be suggested without an explanation of the effects.
May 22, 2014 at 5:00 am
DentalDBA (5/21/2014)
We are wondering what will be the fallout. I assume the distribution database will grow while the DB is offline.
Probably not even that. Replication has a...
May 22, 2014 at 4:18 am
NickBalaam (5/22/2014)
May 22, 2014 at 4:16 am
Read from the table, insert into the index. It's just how an index creation shows up.
May 22, 2014 at 4:13 am
Yeah, it's a plug-in, but all it does it provide a GUI, it's not required to use Extended Events. The underlying feature is there without that, just has to be...
May 22, 2014 at 3:12 am
Until the ghost cleanup runs (which will be almost immediately, in the background)
If you're impatient, rebuild the clustered index
May 22, 2014 at 2:47 am
Is the column defined as an identity column?
May 22, 2014 at 2:45 am
isuckatsql (5/21/2014)
In my original post, i said:"I have a dynamic SQL query"
I also gave datatypes:
"@date is an integer."
"begindate is datetime format."
Neither of which suggests that there's any conversions...
May 22, 2014 at 2:43 am
isuckatsql (5/21/2014)
"The data types varchar(max) and date are incompatible in the add operator."Since it is within a dynamic sql query, i get the above error msg.
Shouldn't be if you properly...
May 22, 2014 at 2:34 am
Was the snapshot online when they dropped it?
What's the exact command(s) they used?
May 22, 2014 at 2:21 am
Viewing 15 posts - 8,956 through 8,970 (of 49,571 total)