Network Redeisgn
Hi, I am serving as a system admin for an organization. We have ISA 2004 network, with Exchange 2003 Standard edition server, 2 Microsoft SQL server 2005 Standard edition for database projects, Windows 2003 domain controller in two sites A and B using active directory services. These two sites are VPN tunneled between ISA 2004 [...]

Answer Question   |  July 2, 2008  11:23 AM
Cisco 1700, Exchange 2003, ISA Server 2004, Network design, Network performance, Networking, PePLink 300, SonicWALL, SonicWALL TZ 170, SQL Server 2005, VPN, Windows Server 2003

Archiving and Purging Data
We deal with a very large database that grows at an avrage of 50GB a month. The current database size is 700 GB. All the transaction tables are horizontally partitioned to seperate filegroups assigned to a individual data files holding each months data. What would be the best strategy to retain another archive server that [...]

Answer Question   |  November 1, 2011  10:24 AM
SQL Server administration, SQL Server archiving

Slowdown of the SAN due to overusage of temporary tables
We make use of temporary tables when we develop stored procedures, but they also become very slow when there is a heavy workload. We have an ISCSI SAN running RAID 10, and our database, logs and tempdb (15 GB) are on the SAN. We think the SAN is overworked; the SQL Server shows no CPU. [...]

Answer Question   |  July 30, 2008  8:23 PM
iSCSI, RAID 10, SAN, SQL stored procedures, Stored Procedures, TempDBs

Finding the total size of databases on SQL Server 2000 and SQL Server 2005
Is there a quick way to find the total size of each database on SQL Server 2000 and SQL Server 2005? I have tried running “sp_spaceused”, but I do not want to run it manually for each database. Do you have any ideas?

Answer Question   |  July 1, 2008  8:09 PM
Database, SQL Server 2000, SQL Server 2005

Sorting hierachy data alphabetically in SQL Server 2005
I have a follow-up question to the article Navigate hierarchies using recursive common table expressions. I have an employee hierarchy that follows a similar pattern to the article, but I need to be able to sort my data alphabetically within each level. Do you have any advice on how to accomplish this?

Answer Question   |  September 9, 2008  8:02 PM
Hierarchy data, Sorting, SQL Server 2005

Error messages in Business Intelligence Development Studio on SQL Server Integration Sevices
I am new to SQL Server Integration Services (SSIS). When I went into Business Intelligence Development Studio (BIDS) and tried to create a new project, I received this error message: “Could not load or assembly ‘Microsoft.DataTransformationServices.Wizards’ or one of its dependencies. The system could not find the file specified.” I searched on my computer for [...]

Answer Question   |  September 20, 2008  3:35 PM
Business Intelligence, SQL error messages, SQL Server, SSIS

Migrating data from Oracle 9i Database to SQL Server 2005
I would like to migrate the data from all used-defined tables in Oracle 9i Database to SQL Server 2005. I know of options like Linked Server, SSIS, SSMA for Oracle and BCP. Which amongst these is the best way to achieve data migration?

Answer Question   |  July 30, 2008  3:29 PM
Data migration, Oracle 9i, SQL Server 2005, SSIS, SSMA

Exporting stored procedure results into an XML file in SQL Server
I need to export the result from a stored procedure into an XML file directly in SQL Server. How would I go about doing this?

Answer Question   |  July 2, 2008  3:25 PM
SQL Server, Stored Procedures, XML

Unable to Restore Backup in SQL Server 2005
I am unable to RESTORE Backup through code in SQL Server 2005 from VB.Net, even though that code is running fine in SQL Server 2000. The code is: “restore database [” + databasename + “] from disk =’” + Me.lblSource.Text + “‘ with move ‘” & dfile & “‘ to ‘” + Me.lbldatafile.Text + “‘,” [...]

Answer Question   |  September 20, 2008  7:35 PM
SQL Server 2000, SQL Server 2005, SQL Server backup, VB.NET

Dealing with a hyperactive SQL Server
On occassion, our SQL Server goes hyper – 100% disk activity with I/O queues. It happens only once a year, lasts for a couple of days and then stops. We have our database administration staff look at it, but we have no real idea what the cause is. Can you suggest a direction or idea?

Answer Question   |  July 2, 2008  7:31 PM
SQL Server, SQL Server errors, SQL Server performance

Code differentiating between SQL Server 2000 and SQL Server 2005
If SQL Server 2000 and SQL Server 2005 run on the same server, how can your code differentiate which database to use? Can you give the new instance of SQL a different name?

Answer Question   |  July 2, 2008  7:28 PM
SQL Database, SQL Server 2000, SQL Server 2005

.Bak file to convert Sqlserver 7.0
hai i am using Sqlserver 7.0 version only but currently i download .bak file ,how to open this file and how to convert into Sqlserver 7.0,its very urgent pls help me……………….. thank U

Answer Question   |  June 30, 2008  12:56 PM
BAK, SQL Server 7.x

How do I create a web based application in SQL Server?
Is it necessary to know C#, .NET or VB.NET to create a web-based application in Microsoft SQL Server 2005?

Answer Question   |  July 1, 2008  9:09 PM
.NET, C#, SQL Server 2005, VB.NET

Managing a sytem with both SQL Server 2000 and SQL Server 2005
I am the systems administrator on a system that has both SQL Server 2000 and SQL Server 2005 running on it. When they are starting up, the system works fine, but when we reboot the server, the 2 SQL Servers appear to fight each other for resources and the system crashes. This does not occur [...]

Answer Question   |  June 30, 2008  6:42 PM
SQL Server 2000, SQL Server 2005, SQL Server errors, SQL Server synchronization

Migrating from SQL Server 2000 to SQL Server 2005 on a failover cluster environment
I am planning to migrate my SQL Server 2000 databases to SQL Server 2005 on a failover cluster environment. What is the simplest strategy you could recommend to fulfill this goal?

Answer Question   |  June 30, 2008  6:36 PM
Migration, SQL Server 2000, SQL Server 2005, SQL Server migration

Spawning additional stored procedures in SQL Server 2000
Is it possible in SQL Server 2000 for a stored procedure to spawn a second stored procedure which will not interfere or slow down the processing of the original? I need the original procedure to finish and return its output variables to the calling program before the second (whose function is to audit the activity [...]

Answer Question   |  June 30, 2008  6:31 PM
Auditing, SQL Server 2000, Stored Procedures

Ability to spawn (or fork) a sproc in SQL Server 2000
Is it possible in SQL Server 2000 for a sproc to call another sproc and then return it’s output variables and close before (or while) the nested sproc processes? Goal is to nest a sproc that willl perform auditing on the called sproc without slowing it down waiting for the auditing.

Answer Question   |  June 30, 2008  5:32 PM
SQL Server 2000, Stored Procedures

Retrieving data from two tables in SQL Server 2005 Expree Edition using C#
how to Retrieve data from two tables in SQL Server 2005 Expree Edition using C#.

Answer Question   |  June 30, 2008  4:55 AM
C#, SQL Server 2005, SQL Server Express

Storing text documents in tables in SQL Server 2005
I have a table in SQL Server 2005 which is used to store text/word documents, and I have enabled full-text search on the column and included a corresponding document type for the document. The problem is when I upload a real NotePad Text/MS Word document saved from the NotePad/MS Word application. At first, I was [...]

Answer Question   |  September 20, 2008  8:08 PM
Microsoft Word, Notepad, SQL Server 2005, Storage

TaskPad view in SQL Server 2005?
Is there a way to get the TaskPad view from SQL Server 2000 for use in SQL Server 2005?

Answer Question   |  June 27, 2008  8:01 PM
SQL Server 2000, SQL Server 2005, TaskPad