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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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