DevSocial Blogs · SQL Server blogs

How to handle SqlServer Error in SqlServer2005 or higher version..?

Rahul Kumar SaxenaJun 2, 20104,797250

Improving Stored Procedure performance - Checklist gives you simple tips to improve your stored procedure performance. Very helpful for entry level programmers or DB developers.

Keyur ChauhanMay 6, 201059,541250

A database snapshot is a read-only, static view of a database (called the source database). Each database snapshot is transactionally consistent with the source database at the moment of the snapshot's creation. When you create a database snapshot, the source database will typically have open transactions. Before the snapshot becomes available, the open transactions are rolled back to make the database snapshot transactionally consistent.

Rajshree MittalApr 26, 20106,254250

New to SQL Server 2005, is The XML data type, which lets you store XML documents and fragments in a SQL Server database. An XML fragment is an XML instance that is missing a single top-level element. You can create columns and variables of the XML type and store XML instances in them. Note that the stored representation of XML data type instances cannot exceed 2 GB.

Rajshree MittalApr 26, 20106,955250

SQL Server 2005 has a ROW_NUMBER Function that can help with paging records for you database applications. ROW_NUMBER returns a sequential number, starting at 1, for each row returned in a resultset.

Rajshree MittalApr 26, 20107,022250

SQL SERVER Interview Questions contains 1 General Questions of SQL SERVER...…………………… 2 Common Questions Asked……………………………………… 3 Questions of SQL SERVER 2008……………………………

To protect your application from SQL injection, perform the following steps: * Step 1. Constrain input. * Step 2. Use parameters with stored procedures. * Step 3. Use parameters with dynamic SQL.

Gumblar appears to be a combination of exploit scripts and malware. The scripts are embedded in .html, .js and .php files using obfuscated Javascript. They load malware content from Third Party sites without the user’s knowledge, while also stealing FTP credentials from the victim’s computer, which then allows it to spread and infect additional sites. Therefore, when someone visits such an infected site they get infected; if they have FTP credentials for a website on their machine then those sites get infected too. This explains the exponential growth of the exploit in such a short space of time.

SQL Server 2008 provides new datatypes to work with date and time values easily.

Sateesh ArvetiApr 16, 201024,305250

We can use IDENTITY_INSERT for inserting values explicitly into a identity column.

Sateesh ArvetiApr 13, 20107,360250

Table-valued functions are used to return TABLE datatype.

Sateesh ArvetiApr 5, 20106,803250

This blog show the SQL query ready to be inserted in a table and contains Countries list.

Nikhil KumarFeb 5, 201010,661250

Welcome to the EXPLORATION OF C #

To delete the duplicate records(same records in one more time) from SQL Server Data base table,use this query.

Karthika PalaniswamyNov 18, 20098,468250

when you install SQL server 2008 and if you get SQL Server Express problem then here is solution.

Rahul Kumar SaxenaNov 11, 20096,165250