Viewing 15 posts - 3,421 through 3,435 (of 49,552 total)
jacksonandrew321 (3/18/2016)
TRUNCATEONLY affects both the LOG and the DATA files in SQL Server.
No it doesn't. From the very blog post you referenced:
NOTE: The NOTRUNCATE and TRUNCATEONLY arguments are only...
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
March 18, 2016 at 2:46 am
Don't send alerts on success. It's just noise that people will ignore. Alerts should be when something has gone wrong.
Set up a job to test-restore your database backups (just having...
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
March 18, 2016 at 2:41 am
szejiekoh (3/17/2016)
Thanks for your reply and the wonderful link!
Same way we roll back any transaction. [Smile]
Log records needed for open transactions cannot be truncated. In your example, T1 (the...
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
March 17, 2016 at 7:22 am
sunny.tjk (3/16/2016)
I'm thinking we are having a high MAXDOP value of 8( MSFT recommends 3) due to which we are seeing high CXPacket waittypes.
Nope!
Oh, and CXPacket isn't a problem. 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
March 17, 2016 at 3:29 am
bsmith 63193 (3/16/2016)
Would it be recommended to use decimal over numeric because it is a wider held standard?
No. In SQL they are identical data types, there's no reason to chose...
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
March 17, 2016 at 3:22 am
If you specify the rebuild without specifying the partition, then you're getting a full index rebuild. It's not done one partition at a time, it's done as one operation on...
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
March 17, 2016 at 3:18 am
Steve Jones - SSC Editor (3/16/2016)
Replication is more flexible, but it can be brittle. If it breaks, it can be a pain to reset up. Not hard, but painful
Agreed.And when...
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
March 17, 2016 at 3:13 am
No, because it's pointless.
If there's space in the data file, SQL will use that and hence won't complain that the drive is full.
If you shrink and remove the free space,...
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
March 16, 2016 at 9:31 am
It doesn't cause fragmentation, but it only reduces the file size if the free space is at the end of the file. It's still not something you should be doing...
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
March 16, 2016 at 9:21 am
Casper101 (3/16/2016)
Would you advise I run DBCC FREESYSTEMCACHE('SQL Plans') to clear these adhoc plans?
No.
I'd advise that the code be changed so that parameterised queries (which generate reusable plans) are...
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
March 16, 2016 at 8:32 am
No, because IN doesn't work like that.
Column IN (@Var) is equivalent to Column = @var
You need dynamic SQL, a string split function or a different design.
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
March 16, 2016 at 8:15 am
szejiekoh (3/16/2016)
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
March 16, 2016 at 7:22 am
Add the indexes to the primary and keep a 'revert index changes.sql' around for when the vendor wants to make an update.
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
March 16, 2016 at 5:13 am
Ok, so you are talking about availability group replicas. Yes you can read from them. They are read-only and are identical to the primary (read-write) replica.
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
March 16, 2016 at 4:44 am
SteveD SQL (3/16/2016)
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
March 16, 2016 at 4:11 am
Viewing 15 posts - 3,421 through 3,435 (of 49,552 total)