Viewing 15 posts - 166 through 180 (of 1,409 total)
I think if you determine the number of changed pages, you'll have the amount of data being sent over. Paul Randall has written an article to determine how much is...
October 26, 2016 at 8:07 am
Luis Cazares (10/26/2016)
You can achieve the result without having all that data stored. It's just a waste of storage when a...
October 26, 2016 at 7:42 am
It isn't clear to me what you actually want. Can you provide some sample data (as INSERT statements, preferrably with an initial CREATE TABLE statement) and how this sample data...
October 26, 2016 at 7:08 am
Jeff Moden (10/26/2016)
jasona.work (10/26/2016)
First, shrinking the logs will fragment indexes, so you'll need to plan for some index operations afterwards.
Careful, now. Shrinking the logs has no effect on fragmentation...
October 26, 2016 at 7:00 am
jasona.work (10/26/2016)
Siberian Khatru (10/26/2016)
October 26, 2016 at 6:59 am
Siberian Khatru (10/26/2016)
October 26, 2016 at 6:56 am
BLOB_EATER (10/26/2016)
Lynn Pettis (10/25/2016)
Spammers are getting better, now even the topics they post look legit.I liked Eric's response - "get a job you bum".
The problem is that they probably respond...
October 26, 2016 at 5:23 am
It's a wild guess, but did you execute it with administrator privileges? ("run as administrator" or from an "administrator command prompt")
If no logging at all it could indicate too little...
October 26, 2016 at 5:12 am
Brandie Tarvin (10/26/2016)[hrOn the other hand, he did figure it out before he sent the code to me... But now I wonder what other code he's been writing that is...
October 26, 2016 at 5:07 am
On http://www.simple-talk.com are some nice articles that will get you started.
See how to document and configure sql server instance settings[/url] for settings on instance level and see database properties health...
October 26, 2016 at 1:39 am
Chris Harshman (10/25/2016)
HanShi (10/24/2016)
...WHERE x.evntTime > cast(GETDATE()-1 as date)
since evntTime seems to be DATETIME datatype, wouldn't that leave an implicit conversion in the execution to compare it to the calculated...
October 25, 2016 at 7:46 am
Mark Dalley (10/25/2016)
HanShi (10/25/2016)
October 25, 2016 at 5:31 am
harikumar.mindi (10/25/2016)
But is there a way we can find out why the replica went out of sync ?
Out of the blue it is impossible to tell. Start by looking in...
October 25, 2016 at 5:23 am
Imke Cronje (10/25/2016)
BACKUP DATABASE successfully processed 849077049 pages in 35673.692 seconds (185.946 MB/sec).
You only post information about one single backup run (is this the slow or an average one?). With...
October 25, 2016 at 5:04 am
You have defined the "TemplateName" column as the first in the composite key (clustered index), so the clustered index will be used if you use the "TemplateName" in the WHERE...
October 25, 2016 at 4:32 am
Viewing 15 posts - 166 through 180 (of 1,409 total)