Viewing 15 posts - 3,421 through 3,435 (of 49,571 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...
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...
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...
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...
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...
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...
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...
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,...
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...
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...
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.
March 16, 2016 at 8:15 am
szejiekoh (3/16/2016)
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.
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.
March 16, 2016 at 4:44 am
SteveD SQL (3/16/2016)
March 16, 2016 at 4:11 am
Viewing 15 posts - 3,421 through 3,435 (of 49,571 total)