Viewing 15 posts - 11,671 through 11,685 (of 49,552 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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 17, 2013 at 10:58 am
Take a read through this: http://www.sqlservercentral.com/articles/Administration/64582/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 16, 2013 at 10:10 am
kapil_kk (9/16/2013)
GilaMonster (9/16/2013)
Post the exact code, we can't tell...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 16, 2013 at 10:08 am
No WITH options?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 16, 2013 at 7:14 am
Viewing 15 posts - 11,671 through 11,685 (of 49,552 total)