MS SQL Server 2005 Support - MS SQL Server 2005 Help from MS SQL Server 2005 Experts

Multi-tenant Database: Shared Database Separ…

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenan...

485 Views

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted? Many believe this is the cas...

470 Views

INTRODUCTION:

While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual ...

391 Views

When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL ...

1005 Views

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data.

I would l...

880 Views

Date	Title	Author
02/11/12	Cannot connect to SQLServer -->php, iis	SiemensSEN
02/11/12	SQL CTE	vikas_nm
02/10/12	MDX - Percentile Function	elwayisgod
02/11/12	Loop, execute sp from loop values?	IntercareSupport
02/10/12	Assistance with a SQL Query	JeffSturgeon2002
02/11/12	Running SQL Backups with other credentials	jimpen
02/10/12	XML Document has multiple roots error	dpicco
02/10/12	DBCC commands not captured in memory buffer?	25112
02/11/12	can you see the blocking process on a shrink on TempDB	25112
02/10/12	dm_io_virtual_file_stats and backupset co-relation	25112
02/10/12	Return Bit field based on code existance in Two Tables	EaswaranP
02/11/12	sql stored procedure with c#	R8VI
02/10/12	Scheduled SSIS Package - Managing the Excel Output File	mjs082969
02/10/12	New case query proble	ac_davis2002
02/10/12	SQL Recommendation for making queries from a large table run faster	rmitwiz

Date

Title

Author

02/11/12

Date	Title	Author
02/11/12	Is it possible to install sql server management studio express 2008 on wi…	jazz__man
02/10/12	error in using temp variable in a select st	25112
02/10/12	Date Query that filters from original DATEOPENED field	allenkent
02/10/12	SQL Query Help - Can unique IDs be created based on the ordering of an O…	sl8rz
02/10/12	Case in where clause using in	YVR33
02/10/12	SQL Agent jobs - what happens if they were due to run while the server …	Grffster
02/10/12	Copy database on same server	leonstryker
02/11/12	How can I prevent a certain text string from being entered in a SQL Server d…	keimpe
02/10/12	SQL CASE STATEMENT	ac_davis2002
02/10/12	Shrink Database on a linked server	jimpen
02/10/12	How to execute a Storedprocedure from a storedprocedure which is writte…	chokka
02/09/12	Use of Relationships in Microsoft SQL 2008 R2	jondevito
02/10/12	After migrating SQL 2008 DB to SQL 2005 I have lost all keys constrai…	plug1
02/09/12	count instances per id err	Tagom
02/09/12	SQL 2008	Wass_QA

Date	Title	Author
10/19/11	Multi-tenant Database: Shared Database Separate Schema in SQL Server	Rita
02/03/12	Does SELECT retrieve rows in the order they are inserted ( Back to Basics …	anoospillai
06/23/11	Lightweight SQL source control using a single stored procedure	ryanmccauley
09/26/11	Running queries on remote databases from SQL Server	angelIII
10/29/10	SQL Insert Generator Round 1	BrandonGalderisi
09/16/10	Remove XML Empty Nodes with MSSQL Recursive Stored Procedure	aromanocohen
12/22/10	Delete Duplicate Rows Without a Primary Key in Microsoft SQL 2005	tedbilly
10/19/11	Failing SQL 2005 Cluster Installation Caused by Core Count Issues	sstad
03/09/11	Read Excel data from SQL Server 2005	pankaj_3425
10/19/11	Moving Database files by Offline method in SQL 2005	prabhakaranbk
10/19/11	Date of the n-th Day in a Month	mwvisa1
11/04/10	Jobs deleted are still running in SQL Server 2005	JagdishDevaku
08/30/11	Managing the Transaction Log for the Accidental DBA	mark_wills
12/31/11	Dynamic Pivot Procedure for SQL Server	mark_wills
03/29/11	Making Sense of Index DMV's in SQL Server	mark_wills