web analytics

Category: Databases

Retrieve permissions on SQL Server database 0

Retrieve permissions on SQL Server database

Reading Time: 1 minuteSQL Server permissions can be granted to on an object level (schema, database, database objects). In newer versions of SQL Server permissions can be given to user at a more granular level.

How to Improve I/O performance for SQL Server 0

How to Improve I/O performance for SQL Server

Reading Time: 2 minutes  If underline I/O architecture system is working properly then every time SQL Server do some transaction (Read/Write) it can do it without waiting. But if load on the system is up, then SQL...

Import CSV file in SQL Server 0

Import CSV file in SQL Server

Reading Time: 1 minuteImporting a CSV(Comma Separated File) in SQL server is a very common task, and most of us use the Import /Export feature of SQL server to do this. Import/Export feature has SSIS (SQL Server...

0x8002801D Library not Registered.. Cannot create any BI project. 0

0x8002801D Library not Registered.. Cannot create any BI project.

Reading Time: 1 minute  An annoying error coming up while creating any Business Intelligence project from SQL studio. Error says that it cannot open a specific temp file. I have deleted all my BI settings but not...

Removing Duplicates through SQL Query 1

Removing Duplicates through SQL Query

Reading Time: 1 minuteSuppose we have a table in SQL Server, that has duplicates in it. CREATE TABLE T1 ( ProductName varchar(50) ) INSERT INTO T1 VALUES (‘Computer’), (‘Computer’), (‘Printer’), (‘Printer’), (‘Printer’), (‘Scanner’), (‘Scanner’), (‘Scanner’), (‘Scanner’), (‘Camera’),...

Calculating difference of dates in Oracle 0

Calculating difference of dates in Oracle

Reading Time: 1 minuteHow to calculate difference between two dates in oracle, as subtraction of dates returns numeric value as difference. With some slight changes/enhancements we can track back the subtraction values to some readable date formats:...

ORA-38029 : object statistics are locked Recently 0

ORA-38029 : object statistics are locked Recently

Reading Time: 1 minuteThis error comes when analyzing tables in oracle. Basic issue in this error is  when you import table without data i.e structure/schema only, oracle will lock table statistics. You can view all the locked...

SqlBulkCopy – Bulk Insertion in SQL Server from .NET 0

SqlBulkCopy – Bulk Insertion in SQL Server from .NET

Reading Time: 1 minuteMany a times there come a scenario when you have to insert large number of records in sql server. There are number of ways to implement this scenario: through looping techniques to call insert...

Write a Custom SQL Scripter (Generating bulk insert, update statements) 1

Write a Custom SQL Scripter (Generating bulk insert, update statements)

Reading Time: 1 minuteThere are always some static tables in our database that needs to always have some default values in them, for our custom application development. Usually a huge amount of data resides in these tables...

Creating Table dynamically in Oracle Procedure 1

Creating Table dynamically in Oracle Procedure

Reading Time: 1 minuteHow can we create a table inside an Oracle procedure. "CREATE TABLE tableName AS". We cannot execute this statement in procedures because upon creation of procedure it would give syntax error. We can implement...