MarkusB (9/27/2013)

---

:w00t: That doesn't look good.

Your backup file is definetly not ok. Could it be that the backup was taken on a different version of SQL Server than your...

BackupNameBackupDescriptionBackupTypeExpirationDateCompressedPositionDeviceTypeUserNameServerNameDatabaseNameDatabaseVersionDatabaseCreationDateBackupSizeFirstLSNLastLSNCheckpointLSNDatabaseBackupLSNBackupStartDateBackupFinishDateSortOrderCodePageUnicodeLocaleIdUnicodeComparisonStyleCompatibilityLevelSoftwareVendorIdSoftwareVersionMajorSoftwareVersionMinorSoftwareVersionBuildMachineNameFlagsBindingIDRecoveryForkIDCollationFamilyGUIDHasBulkLoggedDataIsSnapshotIsReadOnlyIsSingleUserHasBackupChecksumsIsDamagedBeginsLogChainHasIncompleteMetaDataIsForceOfflineIsCopyOnlyFirstRecoveryForkIDForkPointLSNRecoveryModelDifferentialBaseLSNDifferentialBaseGUIDBackupTypeDescriptionBackupSetGUIDCompressedBackupSize

*** INCOMPLETE ***NULLNULLNULLNULL1NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL

Yes I'm able to do it

Hi,

It's easy with extended events (XE) in sql server 2012 by help of its GUI. It should be possible with XE 2008 R2, but you'll have to write some code...

The...

You're right! It cannot be different from SIMPLE....

Very nice article!

I believe that every developer with 2+ years experience has passed through all the mentioned rules.

Thanks.

Hi,

What is the recovery model of your TempDB? Default is SIMPLE, and it should be. Autogrowth of 10% is not the best option.

Citing Erland:

Do you have any databases that...

Hi,

According to your info, you should not shrink the database's files.

If you do that, then do not forget...

Nice and interesting article. I didn't know it.

Thanks

IgorMi

Nice question.

Results are very obvious.

It needs

DECLARE @i TABLE( mychar VARCHAR(11));

SQL_Kills (9/8/2013)

---

Hi,

I don't want to alter any table, I want this done by a sql select statement only? Plus this would not work as only want it to appear as...

Hi

This code should do your job:

alter table salesOrders

add OrderMatched varchar(3) null

update salesOrders

set OrderMatched = 'yes'

from salesOrders s join ProductList p on s.ProductID = p.ProductID

update salesOrders

set OrderMatched = 'no'

where OrderMatched is...

eobiki10 (9/8/2013)

---

Hi All,

I have this error message; Violation of Primary key Constraint. Cannot insert duplicate primary key in object. The value that is causing this error is (128503).

I have queried...

Very nice question!

Thanks