(Jennifer McCown) I like to know what’s on the drives that are supposed to be dedicated to data and log files. So I run a quick check of sys.master_files:

(Rajesh Kumar Chekuri) A cursor is a temporary work area it will create in memory when a SQL statement is executed. A cursor holds a set of records accessed based on a select statement. This temporary work area is used to store the data retrieved from the database, and manipulate/process this data r

People feel the need to help-out when managers ask them to. They feel that they are being a team player or good-soldier, even if the task is beneath their rank or level. This is fine for a very short and contained duration. But if the majority of your assignments are this way — it is detrimental to

(Derek Colley) This article is ideally suited to SQL Server developers and those data professionals wishing to know more about SQL Server functions, and wanting to get a greater understanding of which functions are available and how they can help improve the efficiency and facility of SQL routines.

(Venkatesan Prabu) The expansion of the Internet has made web applications become a part of everyday life. As a result the numbers of incidents which exploit web application vulnerabilities are increasing. A large percentage of these incidents are SQL Injection attacks which are a serious security t

(Jahith) If you encounter an error database state “Recovery Pending” don’t panic you’re not alone. This is because SQL server has encountered improper shutdown or not mounted properly. Possible reason insufficient permission to the DB file folder may prevent the recovery.

(Pinal Dave) In a previous article, I wrote about scale-up vs. scale-out architectures using SQL Server and NuoDB as examples. NuoDB recently announced the general availability of their latest product release, 1.1, and it looks like they’ve made significant progress in improving their Microsoft sup

(Piyush Bajaj) I am sure that all of you would be aware about the role of Identity column in a table, i.e., it is column which keeps on incrementing without supplying the value explicitly during insertion.

(Mangesh Mharolkar) Often times when implementing data integration projects – we come across a need to implement a row/key based lookup and based on the found/not-found condition update or insert a row.

(Dallas Snider) Beginning to learn and comprehend SQL Server Analysis Services (SSAS) MDX queries can be difficult after one has spent years writing queries in T-SQL. When trying to write SQL Server MDX queries, oftentimes I would think to myself, “How would I write this query in T-SQL?”