|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
SQL 2005 LazyWriter performance problem
David Beaver -
30 Sep 2006 11:32 PM - 2 messages
I'm posting this so maybe it will help others. Our SQL 2005 server, within 18-24 hours after reboot, would start to slow down. Queries that normally took 1 second would take 3 or 4. Task manager ...
Simple Recovery vs Full Recovery
Dodo Lurker -
30 Sep 2006 9:30 PM - 4 messages
I know the difference between the two. If I take production database that's in Full Recovery and move it to a test server, would changing the recovery model to Simple affect any performance tests I run? The ldf ...
Cannot create index, timeout expires (SQL Server Express 2005)
sdragolov -
30 Sep 2006 6:05 PM - 5 messages
I am having trouble creating a primary key on a large table (6 mil rows)... on a SQL Server Express 2005 database... After I make the changes to the table and Save, the operation starts but times out after about 30 seconds, saying that the timeout has ...
Maintenance Wizard
S -
30 Sep 2006 5:04 PM - 2 messages
Hi After running maintenance wizard, I getting a backup file that is the same size like the DB but with .bak. Is there a way to compress this file automaticly? The original size is 11GB after compress the size is 700MB. ...
Questions about transaction log
Antony -
30 Sep 2006 3:19 PM - 2 messages
The company I am working with use Small Bussiness Server 2003. I think it came with SQL 2000. We got a large transaction log file. It is 15G last week and the database file is about 5G. I did try BACKUP DATABASE, BACKUP LOG, ...
Checking to see if SQL Server on machine is up and running
simon whale -
30 Sep 2006 2:33 PM - 2 messages
Hi All, i have a doos script that downloads from an ftp site and extracts data from zip files before running a DTS Package. my question is; is there a way to check to see if SQL is running and if not ...
SQLAgent never stop a backup job and consume CPU (SQL2000)
Jeje -
30 Sep 2006 1:43 PM - 2 messages
Hi, on an SQL 2000 server I'm using the maintenance plan to manage my backups etc... in the last year, no problem. but in the last weeks I see that the job never ends!!!! the SQL Agent consume 38% of my CPU and the never stops. ...
run sql script on sql server2000
santosh -
30 Sep 2006 9:10 AM - 17 messages
dear all i am using ASP.net ,c# and SQL server 2000. i have create all table, stored procedure .views in my application which is running well in localhost but now i want to deploy it on server. for that pupose i ...
Free space in a filegroup.
Sezgin Rafet -
30 Sep 2006 8:54 AM - 3 messages
Hi everyone, I need to write a SP to check the available free space in a certain database filegroup(SQL Server 2000 database). Any help will be appreciated. Best Regards, ...
Need help getting this .sql file into my SQL Server
MattD -
30 Sep 2006 7:35 AM - 2 messages
I was working originally with what turned out to be a very unreliable Offshore IT firm in India. I had to finally sever our working relationship with them. They were about 70% complete even though they demanded 100% payment upfront. WON'T EVER DO THAT AGAIN! ...
DTS Help
timber -
30 Sep 2006 6:59 AM - 5 messages
Hello Everyone, Im a bit stumped in doing DTS. I really have basic knowledge on it. anyway, here's my issue. Im trying to import data and my source is a text (.txt) file. The information in the text file was cut and pasted from Excel. This is ...
Select Into V/s bcp and bulk insert
Rishi -
30 Sep 2006 6:38 AM - 10 messages
Which is a better option to transfer data between two sql servers: 1. Over a linked server: SELECT * INTO <table name> FROM <server.database.dbo.table> with (nolock) 2. bcp "SELECT * FROM <database.dbo.table>" queryout "temp.txt" -N -k ...
Check version of SQL 2000 w/ select @@version
frizzzdog -
30 Sep 2006 3:47 AM - 13 messages
Can anybody tell me when i complete the sp4 upgrade to my sql server 2000 why when I type "select @@version" under sql query analyzer it doesn't releft latest upgrade to sevice pack 4? ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug ...
2000 QA against 2005 Server
Hassan -
30 Sep 2006 1:50 AM - 3 messages
Can you use the 2000 Query analyser to connect to SQL 2K5 ? ...
Copy database roles between databases sql server 2005
manganb@gmail.com -
29 Sep 2006 8:47 PM - 2 messages
Hi There, This is vexing to say the least. Setup: Single SQL 2005 standard server: 2 databases, with the same table structure and query structure. Table Count: 78 Query Count: 3 Database A has 8 customized security roles, with different permissions ...
unused space
brogers5884 -
29 Sep 2006 7:56 PM - 6 messages
When we run the "EXEC SP_SPACEUSED" command it is reporting 22GB of unused space yet every day that unused space grows by about 1GB. The data size and index is only roughly 11GB. So my question is why is there so much unused ...
Database loading..
Lina -
29 Sep 2006 7:26 PM - 8 messages
Hello, We did a restore of a database to a test database, however after the restore the database is still showing as loading. I was not present during the restore but it looks like the norecovery option was not used. We tried the ...
Linked server (DB2)
Mike -
29 Sep 2006 6:21 PM - 2 messages
Hello, I'm trying to create a linked server for the last week and it's still not working. I'm using "Microsoft OLE DB Provider for DB2". Here is the error that i have: Msg 64, Level 20, State 0, Line 0 ...
Error doing manual backup
ricky252525 -
29 Sep 2006 4:38 PM - 5 messages
I'm sitting at the server itself (SQL 2005 Standard), logged in as admin and get an error trying to backup to a local drive: Cannot verify the existence of the backup file location. I read how this usually refers to backing up to a network share or ...
VS2005 and Reports for SQL2000
Jean Paul Mertens -
29 Sep 2006 3:29 PM - 4 messages
Hello, Is there a way to migrate my Reportserver project for SQL 2000 Report services developed with VS2003 so that I can use and modify them in VS 2005 or have I realy to install VS 2003 on my new machine? ...
Get SQL 2005 Server Licence Info
ShrimpBoy -
29 Sep 2006 3:16 PM - 6 messages
Hi! I'm looking for a way to retrieve Licence Info from SQL 2005 Server with VBScript From a remote location I connect to the server and grab those info with my administrative rights, but I'm not accessing the DB with a SA account... ...
Database Tuning Advisor
Bryan Aldrich -
29 Sep 2006 3:04 PM - 5 messages
I am trying to run through a trace log to improve one of our databases here, however, the calls originate inside a read only database, goto another database on the same server before they finally end up in the destination ...
lock manager question
Dodo Lurker -
29 Sep 2006 2:43 PM - 3 messages
i have a query that deletes a large range of rows but the where clause is not indexes delete from instructor where lastteachdate < '2005-01-01' lastteachdate does not have an index and the instructor table has 100,000 ...
Number of columns for all tables in a database
JoelBarish -
29 Sep 2006 2:13 PM - 6 messages
Hi - I apologize in advance for the newbie question... I have been asked to gather some db statistics. We have 11 dbs and some have 70 or more tables. I need to gather is number of fields for each table in the database. ...
The performance of a stored proc turns bad overnight
Paul T. -
29 Sep 2006 1:57 PM - 12 messages
Hi, I have a weird issue happening lately on our new SQL Server 2005 standard box. Each night we run a maintenance plan that checks integrity, rebuilds indexes, updates statistics, cleans up history, and backs databases up in that order. Then each morning we notice this one ...
Restore SQL Server to default SQL data directory
Gianluca Dho -
29 Sep 2006 1:06 PM - 2 messages
Hi, I need to prepare an Installshield project that restore a database on my target machine. No problem with script RESTORE DATABASE BIGStudio FROM DISK=MyDir\MyBackup.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10, MOVE 'DB_dat' TO ...
Will auto updates overwrite a full scan
Massa Batheli -
29 Sep 2006 12:46 PM - 2 messages
Anyone tested this? Does auto update stats when it kicks in overwrite a full scan? A full scan is run every night and update updates/creates are turned on. Puzzle A table has 200000 rows and with auto updates the sample rowcount is ...
What is the SQL Server 2005 CTP
karenmiddleol -
29 Sep 2006 8:20 AM - 4 messages
I have a MSDN SQL Server 2005 Developer edition disk called as SQL Server 2005 CTP what is this CD ? is it the 2005 beta CD please confirm. Is it OK to install from this disk. Thanks Karen ...
How to copy user in master database to new server?
Mesak -
29 Sep 2006 7:32 AM - 6 messages
I just install new server for testing only. I have problem about user in master database. How to copy all user from production server to testing server? ...
table design
thomson -
29 Sep 2006 6:23 AM - 2 messages
Hi All, I have a requirement in which some of the text fields are customizable by the super admin for eg: Dropdown options, Chek box options, Can any one tell me how best we can do the table design ...
physical disk counters missing
Hassan -
29 Sep 2006 6:13 AM - 2 messages
So on the source system say ServerA, I can see the physical and logical disk counters using perfmon But when i go to another machine say ServerB or ServerC and use perfmon to connect to ServerA, I cannot see the counters from there. ...
Intermittent connection dramas: "Cannot open user default database..."
Alex Craven -
29 Sep 2006 5:31 AM - 6 messages
Hi, I've been experiencing some very strange, intermittent failures connecting to an MS SQL database... basically at seemingly random times the server decides that it can't open the requested database (reporting error 4062: "Cannot open user default database. Using master database instead"). I've ...
Any scripts that will create maintenance plans in SQL 2005
Raji Arulambalam -
29 Sep 2006 5:22 AM - 2 messages
Hi Using SQL Server 2005 SP1 Are ther any way to create scripts that will recreate the maintenance plans that are on the server? We need to rebuild the server with a different collation, so the master, msdb and model will get recreated. ...
Using CL command in SQL 2000
Sphenix -
29 Sep 2006 4:00 AM - 2 messages
Is it possible to CL command in "Execute SQL Task" by using ODBC connection Btw I'm using "SQL 2000/8.0" (e.g. CL: CPYF FROMFILE(LibraryA/TableA) TOFILE(LibraryB/TableB) CRTFILE(*YES)) ...
Training question-please advise
Rob -
29 Sep 2006 2:15 AM - 2 messages
Hi, I am looking to update my SQL 2005 knowledge to be a DBA, does anyone know any good CD based or online training or any other quick resource. I have basic SQL admin knowledge of SQL 2000. thanks-Rob ...
Configure performance of SQL Server
Don -
29 Sep 2006 1:44 AM - 2 messages
Two of my clients have their databases setup on one of my Servers ( SQL Server 2005). I.e. both Databases are sitting on the one SQL Server. Queries executed by Client A takes a very long time and hence effects the ...
is this an attack ?
Mancha -
29 Sep 2006 1:11 AM - 3 messages
Last night we made the backup as usual, in the morning a table is completely all nulls except for the elements of the key. We thought there was some error or accident, so we copy that table from the backup, 30 min later we saw another table with the same problem, ...
Excessive SQL Compilations
Frank Rizzo -
28 Sep 2006 11:41 PM - 2 messages
Hello, my sql server 2000 box is doing excessive compilations. There is no ad-hoc SQL on the system, just stored procedures. In particular there is really only 5-6 sprocs that run day and night. Still perfmon reports ...
2005 grows
Microsoft -
28 Sep 2006 10:30 PM - 8 messages
Hi, I have a server running 2005. I have a SP that dumps data into a table. When it runs, it adds 100K records (200Mb?) but the database grows to 19GB! but 18.5 is just space. When I shrink the DB I goes back down to 500mb? ...
Change Owner in Database Maintenance Plan
Joe K. -
28 Sep 2006 9:38 PM - 2 messages
Who do you change the database owner in Database Maintenance Plan that was created with SQL Server 2005? Thank You, ...
Why the client cannot see the new columns?
bing -
28 Sep 2006 9:37 PM - 3 messages
Hi, Per a request from a client, I added a few new columns to one of their tables. In both the table and column permissions, I don't see these new columns have any different permissions than other existing columns. But the ...
Database being set to SIMPLE Recovery (no MSDB)
info -
28 Sep 2006 9:04 PM - 2 messages
My production seems to, either upon admin rebooting it for updates, or for someother reason set the Recovermy Mode FROM Full TO Simple??? Weird. How can I track down what is doing this? its SQL 2000 SP4. Thanks ...
Null values not returns when "Not in List" used on column
Paul -
28 Sep 2006 8:58 PM - 5 messages
Greetings, I am running MS SQL 2000 here. We've just found that queries with "not in list" where clauses do not return the rows that have NULL values in the column that the "not in list" clause pertains to. ...
Performance Degrading - Help
magkip -
28 Sep 2006 8:53 PM - 3 messages
I have a SQL Server 2005 database that has been having problems since monday. There have been no database changes for about a month, so this strange behavior is recent. Unfortunately, our Test box is not a ...
SQL Server 2005 Query Optimizer
Lijun Zhang -
28 Sep 2006 8:40 PM - 3 messages
We are planning to upgrade our SQL Server from 2000 to 2005. We have just started testing the performance on 2005 and found that 2005 query optimizer choose wrong query plan over several queries so far. We can force the query ...
Best Practice Database Owner 'sa' SQL Server 2005
Joe P. -
28 Sep 2006 8:21 PM - 4 messages
I known in SQL Server 2000 it's MS best practice to create database owner as 'sa'. Is this still the case using SQL Server 2005? ...
SQL 2000
Rod -
28 Sep 2006 8:05 PM - 3 messages
I have a database on SQL 2000 that is causing me problems.. I have it setup to do a full backup at 5am then incrementals every hour after. I can restore the database to a certain point where it is functional again. However i am ...
Unable to SQL Server 2005 Job
Joe K. -
28 Sep 2006 7:55 PM - 2 messages
I am trying to delete a SQL Server 2005 maintenance job that I created several days ago. I received the following error when trying to delete the job. Please help me resolve this error message. Thank You, Error Message: Drop failed for 'Maintenance Plan' ...
user activity
Carly -
28 Sep 2006 7:51 PM - 2 messages
Hi everyone, Is there any way I can create a stored procedure/function that will show the number of hours the sql 2005 server users have been logged in? Thanks, Carly ...
SQL Server 2005 installation
rseedle -
28 Sep 2006 6:45 PM - 6 messages
I have been trying to get SQL Server 2005 to install on a Windows XP Home Edition PC. I start the install from the splash.html file. The install menu displays. I try to start the server components install and I get the messege: ...
Full self join problem
Matt S -
28 Sep 2006 6:37 PM - 3 messages
Hi I have the following table CREATE TABLE [Sales] ( [StoreID] [int] NOT NULL , [CatName] [varchar] (100) COLLATE Latin1_General_CI_AS NOT NULL , [WEDate] [smalldatetime] NOT NULL , [Best_Sales] [real] NOT NULL , ...
SQL 2005 Replication email notifications not working
LehrSJ -
28 Sep 2006 5:28 PM - 2 messages
I have SQL 2005 Enterprise with SP1 installed. This is the 64bit version. Database mail has been setup and works fine. There is no problem sending email for SLQ jobs. However, the email is not being sent for replication ...
Sp for 7.0
Rockitman -
28 Sep 2006 4:53 PM - 4 messages
How and where do I find which service pack is installed on my SQL Server 7.0? ...
HELP - need to kill big transaction that's taking too long to rollback
robh1999atgmail -
28 Sep 2006 4:26 PM - 2 messages
Hi all, I have a big transaction running on a table that I had to kill and rollback. Unfortunately, the transaction has been rolling back for 1.5 hours and is supposedly only 6% done rolling back. I need to stop this ...
Using xp_sendmail without SQL Mail
John Oberlin -
28 Sep 2006 3:58 PM - 2 messages
I support an application, Microsoft Dynamics GP, that emails Business Alert notifications from within the app. I have this installed on a new SQL 2005 server and the customer was all happy that I didn't have to install Outlook ...
SQL Server 2005 Database Mail
Joe K. -
28 Sep 2006 3:44 PM - 2 messages
What is needed to set up Database Mail on a SQL Server 2005 database server with Windows 2003 server? What are the steps needed to set up Database Mail on this server? ...
DBCC LOGINFO question
Michael MacGregor -
28 Sep 2006 3:16 PM - 6 messages
The undocumented command DBCC LOGINFO, on SQL 2005 returns a resultset that includes a column entitled CreateLSN, does anybody know what this is and what it means? I've tried to find what it is but met with no success so far. ...
Checkpoint - Not running?
lameduck1000 -
28 Sep 2006 2:51 PM - 3 messages
Hi folks. I have a SQL cluster running 2000. My databases are set to simple recovery. The recovery interval on the server is set to zero. My logfiles are continually growing on the servers in the cluster - including the one in tempdb. I do not have long-running transactions, ...
Dropping Extended Stored Proc
John Oberlin -
28 Sep 2006 2:27 PM - 8 messages
How do you delete a extended stored procedure in SQL 2005? ...
query two tables to get data
peashoe -
28 Sep 2006 2:23 PM - 3 messages
Does anyone know how to query two tables to get data? I need something like this select * from registrations where regstatus='R' and select * from classtop where ClassID equals the value of the first select statement. So for exmaple: The first select Statement will give me from registration: ...
How to "UNION" horizontally?
ibiza -
28 Sep 2006 2:21 PM - 3 messages
Hi all, I have a table "Models" which has a column name (field) "model_islive". Table contains models about "titles" that are either archived (model_islive = 0) or live (model_islive = 1) I managed to build a query that get the price field of the most recent ...
Lock Monitoring
Michael Jervis -
28 Sep 2006 2:08 PM - 3 messages
Hi, We're trying to investigate a performance issue with our application which uses SQL Server 2000 as the backend. The performance has become an issue in a live customer environment and we are trying to determine what is acquiring and holding locks for a "long" time. ...
determine db last access date?
jason -
28 Sep 2006 2:07 PM - 5 messages
Is there a way to tell the last time a database was accessed? ...
SqlServer2005 with Win2k workstations running Access 2003
CyberDwarf -
28 Sep 2006 12:23 PM - 5 messages
Hi Has anyone out there had any problems running Win2k (SP4) workstations/Access 2003/SqlServer 2005 in combination? I have a client reporting connection dropout when loading our shrink-wrapped Access ADE app, preceded by an error message saying 'class not registered'. ...
SQL 2005 Mail
Jon Bird -
28 Sep 2006 11:54 AM - 3 messages
I have an issue with SQL mail on SQL 2005, if i set up the server to listen on port 1433 all is fine, however, once i configure the server to listen on another port mail does not get delivered. If I then reset the port number to ...
docs for 2003 enterprise cluster
Scott -
28 Sep 2006 11:32 AM - 2 messages
Im looking for documentation that explains how to install SQL 2000 Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im running an install of Sage MMS 3.5 for SQL 2000 Server. ---------------------------------------- [link] ...
SQL Connection is not closing
vinu thomas -
28 Sep 2006 11:21 AM - 6 messages
Hi, I am using my own SP to backup our database. This Sp runs every day at 1 AM. Recently I have noticed that it is not closing the connection even after completing the job successfully. I can see this SP ...
Floating point precision
MarkusJNZ -
28 Sep 2006 11:05 AM - 5 messages
Hi, I have a SP which adds a bunch of the same number together 365 times The base number is 0.0575342465753425 I am storing this as a float but when I view it in the first iteration it appears as ...
Variable Case Sensitivity within Stored Procedures
Gav -
28 Sep 2006 10:57 AM - 2 messages
What determins that variable names are case sensitive within SQL Server 2000? Does it come under the collation setting or is it a seperate setting? Gav ...
SQL Server consuming lost of physical memoery
vinu thomas -
28 Sep 2006 9:03 AM - 2 messages
Hi On our production server we have 2 instance of sql server running, one is msde and the other is sql std. one of these sql instance is using around 1 gb of system memory. how do i find out which is that instance, and what causing ...
SQL Server 2005 Edition - Enterprise or Standard ?
Sezgin Rafet -
28 Sep 2006 8:00 AM - 2 messages
Hi everyone, We have a Virtual SQL Server 2000 Enterprise Ed. SP3a Server hosting a production database currently about 1.3 GB in size,each month growing with about 150-200 MB(2 Node Active/Passive Cluster,Servers have 2 CPU's each) . ...
Database restore.
Sezgin Rafet -
28 Sep 2006 7:32 AM - 4 messages
Hi everyone, We have a SQL Server 2000 Enterprise Ed. SP3a Server hosting a busy database. When Restoring I have trouble,because while I am killing current user connections new connections are established and I cannot restore because the database is in use. ...
Substring T-SQL
Jack -
28 Sep 2006 7:26 AM - 7 messages
Hi All, i've table name Commet with one column, names "Description" the values in table is in the following convention" INSERT INTO Comments (Description) VALUES('Feedback::Alert:very bad !!!!!') INSERT INTO Comments (Description) VALUES('Feedback::Possitive:test test test ') ...
Exception handling in stored procedure in sql server 2000.
trialproduct2004 -
28 Sep 2006 6:40 AM - 11 messages
Hi all, I am writing one stored procedure wherein i want to do something like try-catch. I am inserting data into one table. So what i want to do is to catch exception if error occured during insertion. I want to display generic message if insert query fails. ...
Transaction job failure
praneethacb05 -
28 Sep 2006 5:25 AM - 3 messages
The error msg is: Executed by user: NT AUTHORITY\SYSTEM.sqlmaint.exe failed [SQLSTATE 42000] [Error 22029] The step failed. ...
Help interpreting deadlock trace
Roshan N.A. Jayalath -
28 Sep 2006 5:08 AM - 2 messages
Hi All, Our servers are getting frequent deadlocks and this is one trace which we got to troubleshoot the deadlock. But I cant understand this trace file and particulary the facts that the two selects which involve in the deadlock are for two seperate tables. ...
netstat doesnt show me 1433 port LISTENING
ing.edmundo -
28 Sep 2006 2:31 AM - 2 messages
Sometimes when I setup ms SQL Server 2000 in a machine and i run "netstat -na" doesnt show me 1433 port listening, and sometimes it does. why is that? thanke ...
Query question
Julio Delgado -
28 Sep 2006 12:54 AM - 2 messages
Hi, I am logging process data every 5 min, every record has a datetime field in addition to the process data one of the requierements of the application is to avg the data every 3 hours. is there any simple way to accomplish this ...
Measuring CPU usage to compile Ad-hoc TSQL
raidken -
28 Sep 2006 12:38 AM - 4 messages
SQL Sever gurus, Is there a way to measure the CPU utilization to compiling Ad-Hoc SQL statements? ...
Importing Text File With DTS
b_bussoloti -
27 Sep 2006 9:07 PM - 3 messages
Hello, i'm trying to import a text file using DTS... I check the 'delimited' checkbox to do it because the guy that sent me this file didn't padronized very well the file. It´s a large file, it has about to 70 columns to be imported, and thousands ...
Finding duplicate records
TRD -
27 Sep 2006 9:02 PM - 2 messages
I want to clean out our database. We have alot of duplicate records. I want to run a query on email address to find all the remove all but one of the duplicate records. I am only working with one table. Can someone help? ...
SQl Server Management Studio - fails to install
Mary Murphy -
27 Sep 2006 7:59 PM - 2 messages
MS SQL Server 2005 Developer edition (DVD version). HELP WITH INSTALL needed HELP - I'm in a 5-week BI class and it's week 2 and I still don't have this product installed. Initially the college mailed me the wrong CD ...
2005 TRY-CATCH BLOCKS - QUESTION
tootsuite -
27 Sep 2006 7:20 PM - 7 messages
Hi, I have some questions about the new TRY-CATCH block syntax in SQL Server 2005. Not all errors can be trapped by a TRY/CATCH block. The first types of errors that are not trapped are compile errors, like a syntax error ...
can i run alter "database rename logical file" on live production server?
Matt Landis -
27 Sep 2006 7:18 PM - 2 messages
Just wondering if i can do this on a live database? Matt ...
Running SQL 7 and 2000 side-by-side
DianeA -
27 Sep 2006 5:31 PM - 2 messages
I have two application to be installed on one machine. One requires SQL7 and the other SQL 2000. Eventually we will get to SQL 2000 for both but not today. Is there any problems I need to be aware of with this scenario? ...
Limiting traces in Profiler
Marco Shaw -
27 Sep 2006 4:19 PM - 2 messages
I've opened a trace in Profile, and now want to limit the results based on the TextData field. I've setup a filter for "textdata not like exec some_existing_sp" and that worked fine. How is a "or" added here, if possible? ...
Memory Issue
stjoe5373 -
27 Sep 2006 3:43 PM - 3 messages
Hello, I don't have a lot of experience with SQL 2000(I'm not positive on the version), I'm running SBS 2003, I have 2GB of memory and SQL is using about 1.5 GB of it and then I begin to ...
performance problems after upgrade to sql server 2005 sp1
sam.m.gardiner -
27 Sep 2006 3:10 PM - 7 messages
we have simultaneously upgraded our server hardware and changed from sql server 2000 to sql server 2005 and found that we have some performance problems. The database is of medium size (about 10Gb) and is a mix of reporting and business transaction processing. We use a mix of 2-tier and 3-tier ...
SQL 2005 Eval
Maurice -
27 Sep 2006 2:16 PM - 10 messages
I have downloaded the evaluation copy of SQL2005 to see if our DB currently running under SQL 2000 will operate in the new environment. I have installed the software but there does not appear to be the equivalent of the 'SQL Enterprise Manage' as there was in SQL2000. So how am I to ...
Create View based on User-Defined Function
Josh -
27 Sep 2006 2:13 PM - 11 messages
I would like to create a View in SQL Server 2000, based on a user-defined function. However when I try it, the "Functions" tab is empty. There are no functions to choose from. I can select tables and other views. ...
ran out of space
Rodo -
27 Sep 2006 1:56 PM - 3 messages
the drive where my dbs and log files reside ran out of space last night during maintenance plan backups. i have since solved the problem and it shouldn't happen again but i'm concerned about the health of the server. ...
History Limit
John Holt -
27 Sep 2006 1:16 PM - 3 messages
I use SQL Server Management Studio and when I View History for a Job there seem to be a 100 line limit. Some of my jobs have more than 100 steps so some don't show. Is there a place you can increase that limit a bit? ...
Creating a Bottleneck.
SQLCatz -
27 Sep 2006 11:34 AM - 3 messages
I’m using Benchmark factory (TPC-C) on a server that has 3 instances of SQL Server. Each instance has between 1-3 databases on it. Have set min and max server memory to 512MB. What I want: ...
Database size for SQL Server 2000 Personal Edition ?
Peter -
27 Sep 2006 10:55 AM - 3 messages
Is there any database size limit for SQL Server 2000 Personal Edition ? Is it 2GB ? Also, is there any database size limit for SQL Server 2005 Express ? From end user point of view, is there any difference between SQL Server 2000 ...
Backup and Restore best practices
Mark Broadbent -
27 Sep 2006 10:29 AM - 4 messages
I have recently been asked to produce a document recommending backup and restore best practices in a new company. They current use a very large backup script in a stored procedure (with parameters) which is used across all servers that automates things to a large ...
SQL 2005 serious memory leak above 21 cores on Unisys ES7000
Richard Yeo -
27 Sep 2006 9:45 AM - 10 messages
We are in process of migrating from Sybase ASE 12.5.3 to SQL Server 2005 Enterprise SP1 x64. We have just purchased a Unisys ES7000 One with 96GB RAM and 24 processor cores (not including Hyper Threading which we have turned off). ...
Recompiling Triggers Failing
Ravjeet -
27 Sep 2006 9:35 AM - 5 messages
I need to know how can I recompile Triggers in SQL Server 2005. I have tried using SP_RECOMPILE. This works fine with Stored Procedures but fails when in case of Triggers. I error I am getting is Invalid Object <TrigName> OR you do not have ...
alter 10 tables at the same time
Jason Huang -
27 Sep 2006 8:45 AM - 6 messages
Hi, In my SQL Server 2000, I have 10 tables which all have the same structure, the only exception is that they have different table names, e.g., CompanyA, CompanyB, ..., CompanyJ. Now I need to add one column in all Company table, is it possible to do it ...
Indexed view fatal exception problem
Jimmy Carlsson -
27 Sep 2006 8:13 AM - 4 messages
Hi! I've created two tables and a view. Then added an index to the view. Works fine but when I try to update a value on one of the tables I get an exception: Process 71 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION ...
Need help on UPDATE FROM
jcvoon -
27 Sep 2006 3:46 AM - 3 messages
Hi: How to update from sub set of result set from the same table ? In english Update Test Set Field1 to Field1 retrieve from "ThisResultSet" where Field2='456' where ThisResultSet is "select Field1 from Test where Field2='123'" In TSQL ...
|
|||||||||||||||||||||||