TSQL to know if database mirroring is setup for both PRimary and secondary server...
Read MoreError: "Must declare the scalar variable" for insert statements in multiple database...
Read MoreAlter a SQL server function to accept new optional parameter...
Read MoreHow to fetch the nth highest salary from a table without using TOP and sub-query?...
Read MoreConverting JDE Julian date to Gregorian...
Read MoreUse bcp to import csv file to sql 2005 or 2008...
Read MoreExecute a stored procedure as another user...
Read MoreTSQL - Querying a table column to pull out popular words for a tag cloud...
Read MoreError creating a table : "There is already an object named ... in the database", but not o...
Read MoreCan't get sql server compact 3.5 / 4 to work with ASP .NET MVC 2...
Read MoreFacing error of "The default schema does not exist." when executing runtime query inside s...
Read MoreHow to get the max row number per group/partition in SQL Server?...
Read MoreUsing sqlsrv_connect on Platforms other than Windows...
Read MoreSQL Server 2005 - Error_Message() not showing full message...
Read MoreSpecifying schema for temporary tables...
Read MoreHow to pass parameter values to a T-SQL query...
Read MoreHow to use alias column name in where clause in SQL Server...
Read MoreBy using single CTE with multiple statements in it. can I perform mathematical operations on CTE out...
Read MoreSQL Server : DATEDIFF not accurate...
Read MoreWhen should I create database indexes?...
Read MoreSQL Server 2005, how to copy a Database Diagram to another server...
Read MoreHow to get the Sum of all column values in the last row of a resultset?...
Read MoreHow do I list all non-system stored procedures?...
Read MoreCan I create a One-Time-Use Function in a Script or Stored Procedure?...
Read MoreWhy isn't database version control considered as important as application version control?...
Read More