Viewing 15 posts - 11,671 through 11,685 (of 49,562 total)
rockstar283 (9/17/2013)
from the moment when you realize that the table is going to be that big..one should immediately think about partitioning it.
No.
September 17, 2013 at 2:48 pm
If I was asked that in an interview, my immediate reaction would be to ask 'for what purpose?' Depending on why those rows need to be moved, I could probably...
September 17, 2013 at 2:46 pm
The problem is in the definition of 'stale'
Old stats aren't necessarily stale. If the table hasn't had a data modification in 6 months, then 6 month old stats are fine....
September 17, 2013 at 2:34 pm
homebrew01 (9/17/2013)
Can a default SQL instance be renamed ??
A default instance is just the server's name, so see above about changing a windows server name.
I forgot about the DNS alias....
September 17, 2013 at 2:30 pm
You can rename the server by changing its name in Windows. You can't rename a named instance.
Honestly though, not a good idea. Changing machine names can break all sorts of...
September 17, 2013 at 2:21 pm
Start by backing the log up more frequently. See the article I referenced about how often and why you back logs up. If you don't need to back the logs...
September 17, 2013 at 2:12 pm
The checkpoint didn't clear the active transactions. It can't do that.
log_reuse is not updated the instant that something changes. Sometimes you need to do something like a checkpoint to see...
September 17, 2013 at 10:58 am
Take a read through this: http://www.sqlservercentral.com/articles/Administration/64582/
September 17, 2013 at 10:52 am
Execution plan shows you how the query runs, not its performance characteristics.
But execution plan shows that 2nd query is performing 80% better then 1st query.
No it doesn't. It shows that...
September 17, 2013 at 10:48 am
Erland Sommarskog (9/16/2013)
However, I believe you will get an error saying that the database cannot be accessed, because you are sandboxed.
You don't. Every time I've implemented login triggers I've used...
September 17, 2013 at 3:21 am
kalczynski (9/16/2013)
Can I make shrink transaction log, when database is in mirroring mode ?
Yes.
Don't shrink to 0. Shrink the log to a sensible size based on activity.
September 17, 2013 at 3:15 am
Just shrink it. None of the other steps are necessary (though you probably should take a full backup first). Make sure you've got your log maintenance implemented correctly.
September 16, 2013 at 10:16 am
Yes. You're appending the log backups all to the same file. Hence each time you take a log backup, the file gets bigger by the size of the log backup...
September 16, 2013 at 10:10 am
kapil_kk (9/16/2013)
GilaMonster (9/16/2013)
Post the exact code, we can't tell...
September 16, 2013 at 10:08 am
No WITH options?
September 16, 2013 at 7:14 am
Viewing 15 posts - 11,671 through 11,685 (of 49,562 total)