Tag Archives: SQL Tips

SQL Server: Incorrect PFS free space information for page (1:xxxx) in object ID xxxxxx:

SQL Server: Incorrect PFS free space information for page (1:xxxx) in object ID xxxxxx:   “Incorrect PFS free space information for page (1:233791) in object ID 367392428, index ID 1, partition ID 72057594180730880, alloc unit ID 72057594222018560 (type LOB data). … Continue reading

Posted in SQL Server DBA | Tagged , , , , , , , , , , | 3 Comments

How to Delete Duplicate Records in SQL Server

How to Delete Duplicate Records in SQL Server Usually on daily basis we usually need to perform removing duplicate records from a table. This post can help you to understand “How to Delete Duplicate Records in SQL Server”. Here consider … Continue reading

Posted in SQL Development, SQL Scripts | Tagged , , , , , , , , | Leave a comment

How to split a string in sql server

 How to split a string in sql server We have a requirement to capture the list of key words in the given list of statements. In the below example will see How to split a string in sql server There … Continue reading

Posted in SQL Development | Tagged , , , , , , , , , , | Leave a comment