Lengh of LOB data to be replicated exceeds configured maximum 65536 (sqltrends.blogspot.com)

submitted by sagitariusmzi(123) 24 days, 15 hours ago

Whenever we try to replicate data from a database that saves the images(filestream) in the database, and you have included those images in your replication, then you might get this error Length of LOB data (583669) to be replicated exceeds configured maximum 65536 Solution: There are two solutions for this problem using TSQL sp_configure 'max text repl size', '2147483647' GO RECONFIGURE using SQL Server Manager Studio In Object Explorer, Right click on your server name and select properties Click the Advanced node Under Miscellaneous option, change Max Text Replication Size to the desired value. read more...

add a comment |category: SQL |Views: 4

tags: SQL another

Attached failed, Unable to open physical file, operating system error (www.sqltrends.blogspot.com)

submitted by sagitariusmzi(123) 1 month, 24 days ago

Whenever user try to attache the database files, he might get this error Attached failed, Unable to open physical file, operating system error read more...

add a comment |category: Database |Views: 4

tags: Database another

A table with FILESTREAM column(s) must have a non-NULL unique ROWGUID (sqltrends.blogspot.com)

submitted by sagitariusmzi(123) 8 months ago

when you try to add filestream column to store images in database, you might this problem A table with FILESTREAM column(s) must have a non-NULL unique ROWGUID column read more...

add a comment |category: SQL |Views: 3

tags: SQL another

An easy way to get the Definition of an Object (sqltrends.blogspot.com)

submitted by sagitariusmzi(123) 1 year, 1 month ago

I was using the sp_helptext very frequently to get the definition of an object. Here is another easy way to get the definition of an object read more...

add a comment |category: Database |Views: 1

tags: Database another

Difference between NEWID() and NEWSEQUENTIALID()(sqltrends.blogspot.com)

submitted by sagitariusmzi(123) 1 year, 1 month ago

In this article, we will be looking at the Difference between NEWSEQUENTIALID() and NEWID() and How NEWSEQUENTIALID() is generated. NEWSEQUENTIALID() generates the unique identifier values sequentially. Whereas NEWID() generates the unique identifier values randomly. read more...

add a comment |category: Database |Views: 18

tags: Database another

Find Created date and Modified date of Database objects (sqltrends.blogspot.com)

submitted by sagitariusmzi(123) 1 year, 2 months ago

This script will return the objects with respect to their created or modified date read more...

add a comment |category: Database |Views: 0

tags: Database another

Using newsequentialid() in SQL SERVER(sqltrends.blogspot.com)

submitted by sagitariusmzi(123) 1 year, 2 months ago

The newsequentialid() built-in function can only be used in a DEFAULT expression for a column of type 'uniqueidentifier' in a CREATE TABLE or ALTER TABLE statement. It cannot be combined with other operators to form a complex scalar expression. read more...

add a comment |category: Database |Views: 12

tags: Database another

SQL Server Interview Questions(sqltrends.blogspot.com)

submitted by sagitariusmzi(123) 1 year, 2 months ago

Few days back, i went for an interview , following questions were asked * How to Performance Tune a Stored Procedure? * Type of Triggers? * How to get the old value of a field from a trigger when updating a table? * What is the difference between horizontal partition and vertical partition? read more...

add a comment |category: Database |Views: 17

tags: Database another

How to Load Test a SQL SERVER Database(sqltrends.blogspot.com)

submitted by sagitariusmzi(123) 1 year, 3 months ago

A really nice to to Load test a SQL SERVER Database. read more...

add a comment |category: Database |Views: 4

tags: Database another

How to enable TSQL Debugging in SQL SERVER(sqltrends.blogspot.com)

submitted by sagitariusmzi(123) 1 year, 3 months ago

Unable to start T-SQL Debugging. Could not attach to SQL Server Process read more...

add a comment |category: Database |Views: 17

tags: Database another

SQL Server Performance Killers(sqltrends.blogspot.com)

submitted by sagitariusmzi(123) 1 year, 4 months ago

There might be several individual factors that can kill the performance of your database. If you aware of the main performance killers in SQL Server in advance, you will be able to focus your tuning efforts on the likely causes. You also need to look the hardware, operating and SQL Server settings read more...

add a comment |category: Database |Views: 5

tags: Database another

How to Attach Database in SQL SERVER (sqltrends.blogspot.com)

submitted by sagitariusmzi(123) 1 year, 5 months ago

This is a step by step walkthrough to attach the Database in SQL SERRVER, if you have data file (.mdf) only and you don’t have log file (.ldf) I had tried to simplify the steps with the help of screen shots read more...

add a comment |category: Database |Views: 1

tags: Database another

Sample Database for SQL Server 2011 Denali CTP1(sqltrends.blogspot.com)

submitted by sagitariusmzi(123) 1 year, 5 months ago

Download Sample Database AdventureWorks for SQL Server Denali CTP1 read more...

add a comment |category: Database |Views: 15

tags: Database another

How to Install SQL SERVER 2011(sqltrends.blogspot.com)

submitted by sagitariusmzi(123) 1 year, 5 months ago

This is step by step Walkthrough installation guide with images for SQL SERVER 2011 The installation of SQL SERVER 2011 is very much similar to SQL SERVER 2008, If you have already installed SQL SERVER 2008, You might not face any problem. Microsoft has launched SQL SERVER 2011 "Denali"; I have downloaded MICROSOFT SQL SERVER "Denali" from read more...

add a comment |category: Database |Views: 7

tags: Database another

The Operating System on this computer does not meet the minimum req.(sqltrends.blogspot.com)

submitted by sagitariusmzi(123) 1 year, 5 months ago

The Operating System on this computer does not meet the minimum requirements for SQL SERVER "Denali" When installing SQL Server 2011 Denal , you might get the following error, if you are installing on Windows XP operating System , because Windows XP is not supported for SQL Server 2011. read more...

add a comment |category: Database |Views: 4

tags: Database another

SQL Server Interview Questions(sqltrends.blogspot.com)

submitted by sagitariusmzi(123) 2 years, 9 months ago

How to implement many-to-many relationships? What's the difference between a primary key and a unique key? What is user defined datatypes and when to use them? Define candidate key, alternate key, and composite key? Is there a column to which a default value can't be bound? What are ACID properties? Explain different isolation levels? What is MOLAP, ROLAP and HOLAP? Types of constraints? What are the types of indexes ? What are the type of the NonClustered Indexes ? In which situation NonClustered is more fast then clustered index? What is the difference between deadlock , live lock and blocking ? And How to resolve them? What are the Query Hints? read more...

add a comment |category: Database |Views: 71

tags: Database another