Hi, I have around 13 million records in a table on Server A. I need to port this data to Server B over the network (LAN). Would it be better for me to BCP out the tables first in Server A and then zip and copy it to Server B and then BULK INSERT it, or would it be better to run the DTS i...more >>

Hello We are trying to enhance the performance of our server. We recently noticed that despite having 4Gb of RAM in the server, sqlserver.exe was only using 1.7Gb. There are 4 databases on the server, one of which is at 9Gb and in constant use (by around 50 people). We had thought that...more >>

Hi, All! I have some tables and partitioned view. Tables defined as required, with PK and check constraint CREATE VIEW MyView AS SELECT * FROM Table1 UNION ALL SELECT * FROM Table2 UNION ALL SELECT * FROM Table3 If I select something [in Query Analyzer] using constant SELECT * FRO...more >>

Hi, I have a stored proc intented to search a table on different fields, depending on the search type. Up until now, I have implemented 3 options, which is by kanji, kana and english. I'll add many others, like strokes count, radical # and so on. Here it is, with the 3 options (it may see...more >>

I work for a small analytical laboratory. I'm mostly the net admin guy, but I do the db stuff (poorly) and other things. Last night right before closing my users started experiencing bigtime slowdown. This morning it was magically better for a short duration. As the day went on the problems g...more >>

How can I get a DTS ask a parameter to use it in the where clause of the query before it runs?...more >>

I am using SQL Server 7, 2000 and 2005. I want to create a stored procedure for my query. My query is as follows: select column1, column2, column3, column4 from table where date1 >= 'Jan 1, 2006' and date1 M 'Jan 2, 2006' and id1 in ('1', '343', 'ABC') The trouble I have is the dynami...more >>

The previous thread died so I'm sorry for the repost. I am working on making my application inherit the workstation login user information so that users aren't presented with multiple logins. Does anyone have any experience linking internal application user management (ie: USERS table) with ...more >>

Our current SAN capacity has just hit the wall and I need some advice. The SAN stores our current production SQL db and the backups on another volume. The volume that the backups for TL's and the database is on is completely full. Can backups be sent to any server with capacity on the network ...more >>

I am seeing high CPU. My disk counters are normal and memory is in good shape. I have reindexed and DBCC ShowContig has all indexes greater than 90% scan density and logical fragmentation is all down near zero. I have approximately 100 reads for every write. My FillFactor is set at 90%. ...more >>

We have a couple of Bill of Material tables in our SQL 2000 database and I need to extract information. The first table is the master table and the only relevant field is fpartno. Table two is the child table, and it contains all of the parts that make up the fpartno in the master table. Th...more >>

1. If I do not drop a temp table after being used in a stored procedure, how can that cause TempDB to grow? 2. If I do not drop a temp table after being used in a stored procedure, will truncating the temp table serve as good a purpose as dropping the temp table? -- Message posted via SQLM...more >>

I am trying to DTS some data from delimited source and some of the dates have the value 99999999. This naturally makes the DTS job fail. Is there a method to make it ignore these values and append only those with acceptable date formats?: 20060810 Thanks for any suggestions. RBollinger ...more >>

I use transactional replication on several very "wide" table. One has 254 columns. After finding that was my limit for replication to work I removed an unused columns and added a new needed column. Since the COLID in the SYSCOLUMNS did not reset replication failed. I'm down to renaming columns n...more >>

When trying to start SQL 2000 from dos prompt. I changed the start up locations -D -L -E for my server from EM server properties, Moved the Data and log files (MDF and LDFs), then tried to restart the server and it failed. I duplicated all files to their original locations, and again tried ...more >>

We make changes on our dev server and test them. Then we move those changes over to production. The largest real change is we've added some c#/dll to the database (mainly for string manipulation). A search that takes 3.XX minutes on the dev server takes over 56.XX minutes on the prod se...more >>

What kind of warning, critical, errors messages are stored within SQL Server error log? ...more >>

Two years ago, when I upgraded all my SQL Servers in our various branch offices, I apparently took the wrong CD with me and installed Enterprise edition when I meant to install Stanard. Is there a procedure to downgrade an existing production SQL Server from Enterprise Edition to Standard...more >>

All Anyone know what is truly recommended for the NIC settings for SQL 2005 when installed on Windows 2003? Microsoft SQL MVP and SQL author: Mark L. states that the NIC should be set to: "Maximize date throughput for file sharing." However, MSDN article states that the setting shoul...more >>

Looking to obtain website links to Microsoft SQL Server Support Sites? Thanks, ...more >>

Hi, I need to recover a 2 GB database wich is in read only state, it doesn't allow to change the state ( error with the data file name ...) but the data is readable, doing some querys it seems ok. I couldn't create a backup from control panel, so I'm trying to find another way to move the d...more >>

Hello, Just finished running SQLIO and SQLIOstress to test my SQL server hardware in a RAID 5 and RAID 10 configuration. I question what exactly is the best criteria to key off of for performance. Do I look at the IOS, MB/sec, or Latency to get the best feel of performance? Also, the t...more >>

On one box Enterprise Manager is indicating a second instance “ . (Windows NT)” , in addition to the default instance, “ (local) (Windows NT)”. This second instance was not installed, It just appeared. The MSSQL directory indicates the presence of only one instance. Databases, and s...more >>

When I unplug my server from the network, I lose connection to SQL Server. I don't understand why it is happening. All my applications have to be closed and reopened to talk to the database again. Can anyone please let me know why this is happening? I am using SQL Server 2005 SP1 and Window...more >>

Hi, It is possible to open a file dialog directly from another pc (windows 2000 server sp4, msde sp3) like enterprise manager do when you try to restaure a database? I don't want to share folder on my server, and I want to select the backup file (located on my server) from my application (run ...more >>

Hello , I was going through an article that talks about the CLR stored procs. If a stored proc wouldn't have built as an extended stored proce and we don't need write CLR stored proc. Please some one take a moment to explain what is an extended stored proc. Thanks -Learner ...more >>

hi all, i want to change the sa password from my C# code. i'm using SQL server 2000, win XP, .NET 2003 and need to develop a simple application that changes the sa password from the code and not the enterprise manager i'll be logged in as an sa. thanx for ur help and time ...more >>

I am trying to create an alert to monitor deadlocks with following specification. Name = "Deadlock(s) detected . . ." Type = "SQL Server performance condition alert. Object = "SQL Server:Locks" Counter = "Number of Deadlocks/sec" Instance = "Database" Alert if counter = "becomes equal ...more >>

Is there a materials such as the following for an Oracle DBA who would like to learn MS SQL(e.g. 2005) - Training courses - Web sites/ebooks - MS articles - etc SQL Server features and compare it with Oracle. So, it should be something of learning method for a person with DBA knowledge(i...more >>

Hi, I'm trying to connect to a SQL 2005 server using Managment Stuidio Express. I can conenct to the server using it's IP address but can't when I specify the machine name. I can telnet to the machine's sql server port using the machine name and the IP address. Has anone else had this pro...more >>

Hi, After noticing that one of our databases was growing at alarming rate we discovered a 'bug' in the vendors application and ran a truncate table (at vendor request) to remove the excess data. This changed the used space in the db from 17gb to 4gb which is great :-) however when we try to...more >>

I'm in the process of running a set of tests on SQL Server 2005 (multiple instances). For the scenarios that I want to test – require 4-5 sample databases (in addition to the AdventureWorks provided by Microsoft). Can someone point me to a location from where I can download sample databases...more >>

When running a query in SQL Server 2000, I got "Timeout expired" error. How can I increase the timeout time ? Thanks. ...more >>

Dear all, Is there any way can I insert a new field between existing fields = through TSQL or other means, without using Enterprise Manager? Thanks a lot. Regards, Alex AU...more >>

Hi All, I have a client doing a backup and then trying to restore the backup. When they do, they get the following error: An internal consistency error occured. Contact Technical Support for assistance. RESTORE DATABASE is terminating abnormally. This does not happen to all backups only...more >>