Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers.
SQL SERVER – 64 bit Architecture and White Paper
In supportability, manageability, scalability, performance, interoperability, and business intelligence, SQL Server 2005 provides far richer 64-bit support than its predecessor. This paper describes these enhancements. Read the original paper here. Following abstract is taken from the same paper. Another interesting article on 64-bit Computing with SQL Server 2005 is here.…
Read MoreSQL SERVER – CASE Statement/Expression Examples and Explanation
CASE expressions can be used in SQL anywhere an expression can be used. Example of where CASE expressions can be used include in the SELECT list, WHERE clauses, HAVING clauses, IN lists, DELETE and UPDATE statements, and inside of built-in functions. Two basic formulations for CASE expression 1) Simple CASE…
Read MoreSQL SERVER – Fix : Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection.
Some errors never got old. I have seen many new DBA or Developers struggling with this errors. Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection. Fix/Solution/Workaround: Change the Authentication Mode of the SQL server from “Windows Authentication Mode (Windows Authentication)”…
Read MoreSQL SERVER – Stored Procedures Advantages and Best Advantage
There are many advantages of Stored Procedures. I was once asked what do I think is the most important feature of Stored Procedure? I have to pick only ONE. It is tough question. I answered : Execution Plan Retention and Reuse (SP are compiled and their execution plan is cached…
Read MoreSQL SERVER – Script to Find SQL Server on Network
I manage lots of SQL Servers. Many times I forget how many server I have and what are their names. New servers are added frequently and old servers are replaced with powerful servers. I run following script to check if server is properly set up and announcing itself. This script…
Read MoreSQL SERVER – 2005 – Disable Triggers – Drop Triggers
There are two ways to prevent trigger from firing. 1) Drop Trigger Example: DROP TRIGGER TriggerName GO 2) Disable Trigger DML trigger can be disabled two ways. Using ALETER TABLE statement or use DISABLE TRIGGER. I prefer DISABLE TRIGGER statement. Syntax: DISABLE TRIGGER { [ schema . ] trigger_name […
Read MoreSQL SERVER – Fix : Error 1702 CREATE TABLE failed because column in table exceeds the maximum of columns
Error Received: Error 1702 CREATE TABLE failed because column in table exceeds the maximum of columns SQL Server 2000 supports table with maximum 1024 columns. This errors happens when we try to create table with 1024 columns or try to add columns to table which exceeds more than 1024. Fix/Solution/WorkAround:…
Read MoreSQL SERVER – Fix : Error: 3902, Severity: 16; State: 1 : The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
SQL Server Integration Services Error : The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. (Microsoft OLE DB Provider for SQL Server) Fix/Workaround/Solution: Option 1: To work around this problem, do not call the stored procedure by using ODBC Call syntax. You can call the stored procedure in may ways…
Read More
SQL SERVER – Running 64 bit SQL SERVER 2005 on 32 bit Operating System
Few days ago, I have received email from users asking question :How to run 64 bit SQL SERVER 2005 on 32 bit operating system?