Viewing 15 posts - 6,781 through 6,795 (of 49,552 total)
Grant Fritchey (1/14/2015)
Maybe I'm in a weird head-space at the moment, but it seems like the questions have gotten... not worse, but weirder. Sort of off the wall, no?
I'm with...
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
January 15, 2015 at 2:49 am
Bear in mind that it's not going to match the size of the log backups exactly and if you're compressing the log backups it's not going to match at all.
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
January 15, 2015 at 2:49 am
ramana3327 (1/7/2015)
In general how often we can shrink the logs.
'Never' is a good frequency for shrinking 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
January 15, 2015 at 1:46 am
If your DB is in full recovery and you're not doing log backups, either put the DB into simple recovery model or start taking log backups. If you don't do...
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
January 14, 2015 at 1:24 pm
Giova (1/14/2015)
I hate Oracle because of complexity, but in certain cases I hate sql server because of stupidity.
There's nothing stupid about it.
In simple recovery model you're telling SQL...
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
January 14, 2015 at 1:16 pm
It's critical in TempDB to spread out the allocation of tables across the files and hence reduce the contention on the first set of allocation pages in the file. If...
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
January 14, 2015 at 1:07 pm
Grade IN ('A','B','c','D','E','F','G')
etc
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
January 14, 2015 at 1:00 pm
No, you can't use fn_dblog as in simple recovery model the log is truncated on every checkpoint, so every couple minutes.
Best thing, prior to implementing log shipping, switch the DBs...
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
January 14, 2015 at 8:45 am
Ok, that's pretty big.
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
January 14, 2015 at 7:46 am
If it wasn't January, I'd be wondering if this was a mis-scheduled April Fools joke. Seriously, whoever crafted those 'recommendations' should probably not be allowed anywhere near a database server,
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
January 14, 2015 at 6:50 am
Page IO latch is indicative of IO activity, as Grant mentioned but PageLatch isn't. Depending on what kind and what resource it could, if high enough, be indicating allocation contention...
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
January 14, 2015 at 6:42 am
sivakumar.thangavel (1/14/2015)
any scripts available or not?
http://www.urbandictionary.com/define.php?term=polite
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
January 14, 2015 at 4:43 am
JarJar (1/14/2015)
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
January 14, 2015 at 4:11 am
It's TempDB where the files MUST be the same size. For user databases isn't not particuarly critical.
It is a bit odd to see 8 files in the primary filegroup though....
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
January 14, 2015 at 3:17 am
What?
Your example above created a column with identity, so why are you asking how to create a column with identity?
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
January 14, 2015 at 2:47 am
Viewing 15 posts - 6,781 through 6,795 (of 49,552 total)