|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
L2/ L3 proc caching and SQL Server
Hassan -
24 Dec 2005 11:10 PM - 2 messages
Trying to understand the high caching on the chips that they talk about with L2 and L3 and what role does that play with SQL Server Can someone let me know ? Whats stored on those caches and if i have more, ...
BI Development Studio is missing ?
odeddror -
24 Dec 2005 9:12 PM - 2 messages
Hi there, After installation of SQL Server 2005 Developer with no errors My development studio is missing. How do I reinstall this part again ? Thanks an advanced Oded Dror ...
Migrate SQL 2000 to SQL 2005
Peter Lawton -
24 Dec 2005 11:01 AM - 3 messages
We want to migrate some x64 servers from 32bit SQL 2000 to 64bit SQL 2005 I know that upgrading SQL 2000 to x64 SQL 2005 isn't possible and I expect upgrading x32 SQL2005 to x64 SQL2005 isn't possible either. ...
SQL Server 2005 64 bit memory question
imarchenko -
24 Dec 2005 2:06 AM - 15 messages
Hello! I just installed 64 bit SQL Server 2005 on Windows 2003 SP1 64 bit. I am puzzled because Total Server Memory (KB) counter shows much higher value than Total Server memory (KB). I have got 4 GB of RAM installed. My ...
SQL 2005 Upgrade Advisor
imarchenko -
24 Dec 2005 12:54 AM - 2 messages
Hello! I was trying to use SQL 2005 Upgrade Advisor to analyze our SQL 2000 databases to detect any code incompatible with SQL Server 2005. Unfortunately, it came back with some very minor changes after analyzing SQL ...
Upgrading SQL 2000 databases to SQL 2005
imarchenko -
24 Dec 2005 12:06 AM - 5 messages
Hello! We have got a multi-terabyte database that we would like to move to SQL Server 2005 64 bit server. Given the size of database, I was wondering what would be the most efficient way of converting our database into SQL 2005 ...
Restoring a database with a different name in the same server
Jack -
23 Dec 2005 8:26 PM - 3 messages
Hi, What I have done is made a backup of pubs database. I named this file as pubs_bak. Now I want to restore this file as a new database i.e. pubstest database. While trying to restore this file with a new database name, it does ...
Shrink Transactin Log
Rustom -
23 Dec 2005 7:43 PM - 3 messages
I am running into issues when trying to shrink a transaction log file with query analyzer on SQL 2000. I am getting this error message Cannot shrink log file 2 because all logical log files are in use. Thanks ...
Unable to Copy Databases using CDW
Faybert -
23 Dec 2005 6:59 PM - 2 messages
I've run into a problem, where I run the wizard on the screen where you select which databases to copy/move, ability to check the copy and move boxes associated with the databases simply isn't available for any of ...
How to update price from excel file ?
msnews.microsoft.com -
23 Dec 2005 5:53 PM - 2 messages
I dont know which group will be appropriate for this question so I am posting to all the above groups. I am running sql2k. Our company changes the prices every quarter. Accounts department works on some figures and finally they set a new price each parts ...
View all tables in a database
Javier -
23 Dec 2005 5:29 PM - 5 messages
I'm new to SQL 2000 and I'm wondering if there is a way to view the name of all the tables in a particular database as well as the name off all the columns via Query Analyzer? Thanks, ...
SQL Server 2005: connection problem
Yuriy -
23 Dec 2005 4:33 PM - 2 messages
I installed SQL 2005 Std Edition on Windows 2000 XP. Run SQL Management Studio and got screen to connect to server and I can not connect providing my Server name. If I try to create ODBC data source then I also can not connect to server or ...
2005 Agent - MSX enlist failed
Cgal -
23 Dec 2005 3:18 PM - 8 messages
I have a server that is running two SQL Server 2005 instances. The MSSQL and AGENT services for both instances are both running with a local domain account on the server. When setting up one instance as a master and the ...
Copying Stored procs in SQL Server 2005
UJ -
23 Dec 2005 3:03 PM - 5 messages
How can I copy stored procs from a 2000 server to a 2005 server? The only thing I see in the SQL SMS is copy the database which I'm having problems with. In Ent Mgr 2000 when you export you could select SPs. I don't see that ...
URGENT...database is marked loading
Me -
23 Dec 2005 2:04 PM - 4 messages
During a restore, I got msg that it lost connectivity so I restarted the restore which ended successfully. HOwever the database was marked with 'loading'. AFter about 1 hour I did the restore again and it was successful. Again is was still marked loading and the db was empty, no ...
String gets truncated in a database column
Seema Kohli -
23 Dec 2005 12:41 PM - 4 messages
I have used a varchar(5000) column in a sql server 2K table. On inserting a large value (less than 5000 chars), the truncated value gets inserted (till about 256 chars). I have changed the column type to text. But that has not helped. ...
Cannot write a small row! Please help...
almurph -
23 Dec 2005 10:46 AM - 4 messages
Hi everyone, This is weird. Please help! I have a long row in the form: WordA WordB WordC WordD etc... ...
Changed Administrator Password
Gareth Sharp -
23 Dec 2005 10:01 AM - 4 messages
Hi There! I have changed the Administrator password on my Windows 2003 SBS server, and now each time I reboot the server, the SQL Server Service fails to start. I have to change the password back to the previous one, manually start the ...
Can I connect to SQL Server via PPPoE?
stevegao2003@163.com -
23 Dec 2005 9:31 AM - 3 messages
I am a fresh guy for networking and here is a question seeking help. If SQL Server was located in internet and i use a PPPoE (ADSL) line to connect to internet, can I connect to SQL Server via PPPoE? ...
Will transaction log affect query speed ?
jcvoon -
23 Dec 2005 9:29 AM - 10 messages
Hi: Someone told me that when the SELECT query perform slow, try to shrink the transaction log, it will improve the query speed. Is this statement correct ? why ? Can someone explain how the transaction log work ? What i understand is ...
Happy Holidays to you all
Hassan -
23 Dec 2005 8:44 AM - 2 messages
Been fun posting on some of these SQL newsgroups and receiving timely responses that made my day. Thanks to all who responded and also thanks to all the ones that ask questions. I only wish i could read the newsgroup postings every day ...
SQL 2005 on Win2K3 and cannot connect to SQL 2K on XP
Hassan -
23 Dec 2005 8:40 AM - 2 messages
I installed SQL 2005 Std Edition on Win2K3 EE And from that box tried to connect to a SQL 2K instance on XP using the SQL Management Studio It does not want to connect stating that it has timed out ...
SQL Server 2005 Error HRESULT: 0x80040110
Oded Dror -
23 Dec 2005 4:21 AM - 3 messages
Hi there, I'm using SQL Server 2005 Dev. with Windows XP Pro. SP2. 50GB free space with 1GB of RAM After I installed SQL Server with no problems. I tried to open a table in AdventureWorks database and I'm getting an error: ...
SQL Server Express Exclusive?
Jeff -
23 Dec 2005 3:07 AM - 3 messages
While developing an application in VS2005-C# I've noticed that if I run the application, and while still in VS2005 I switch over to SSE Management Studio and I get a message that tells me the database is being used by another process. Is it possible that I can open the ...
Error when opening Maintenance Plan in SQL 2000
Lisa Hoffman -
23 Dec 2005 2:30 AM - 5 messages
I've recently installed SQL 2000 on a new server. Migrated production databases and data from old SQL 6.5. Everything checks out OK applications work fine, all data came over no problem. However... when I try to open or create a ...
Query data is very slow
Vensia -
23 Dec 2005 1:56 AM - 5 messages
Dear all, I have SQL Server 2000 installed at the HO server (Pentium 4, memory 512 Mb). The client side (Pentium 4, memory 256 Mb) connect to the server using leased line 128 Kbps. The distance between HO and client side is 10 miles. ...
'Connection terminated' errors in C/S application...
drkc -
23 Dec 2005 1:31 AM - 2 messages
Client workstations getting 'conection terminated' message through the client app. Happens sporadically and we can't seem to make it happen. Sometimes the users get error messages from SQL Srvr and sometimes just the 'con term' message. I've checked the switch, the wire, the patch level, the clients ...
Connection from PHP slower when server is remote
gharmel -
23 Dec 2005 1:13 AM - 4 messages
I'm trying to get some clues on why I get (much) slower responses from my PHP applications when dealing with a remote sql server as opposed to a local sql server. Here's my situation: Server #1 MSSQL 2000 sp4 ...
reorganization percent -- ??
maxzsim via SQLMonster.com -
23 Dec 2005 1:00 AM - 5 messages
Hi All , i am using a 3rd s/w(Idera SQL DM to be exact) to perform diagonistics on my SQL 2000 Server. from the alert log , i got some of the following messages able managed_object (1445580188) in Database Altiris_Incidents (6) has a ...
How to reduce the size of transaction log
Eduardo Sicouret -
22 Dec 2005 10:32 PM - 2 messages
Hello, Please could you send me the neccesary steps to reduce the size of the transaction log in a database, without taking the database offline? Thanks in advance. Eduardo Sicouret ...
Dual processors?
Bob -
22 Dec 2005 10:05 PM - 4 messages
One of my customers just plugged in a second processor on a sql server 2000 running on a dell (dual Xeon at 2G). Does the simple fact of plugging in a second processor increase the speed of sql server standard on that machine? ...
SQl server reported slow
Bob -
22 Dec 2005 9:58 PM - 3 messages
Customers got a SQL server that seems slow. Its a DELL 1600SC with W2000 SP4, Its got 2 Xeon 2G processors and 1 G RAM. Its on a small LAN (40 users) with Gigabit ethernet switches. Its got a database that is a bit samller ...
Deinstall SQL 2000 instance?
nick -
22 Dec 2005 8:53 PM - 6 messages
Plaese help: How to remove SQL 2000 server instance from the server? SQL Installation CD does not give Remove option. Should it be manual remove from Windows services, Programm Files,Registry? Thanks in advance, Nick ...
SQL 2005 samples
John J. Hughes II -
22 Dec 2005 8:32 PM - 4 messages
According to the BOL there are supposed to be samples in this "C:\Program Files\Microsoft SQL Server\90\Samples" directory. Well there not there and I have reinstalled and made sure the doc and sample options was selected to ...
Port advice
Frank Rizzo -
22 Dec 2005 7:14 PM - 6 messages
Hello, this is probably a bit off topic, but maybe someone here has dealt with this situation. I've setup SQL Server at home and want to access it from work. However, they have the 1433 port closed. They do have a bunch of ports open, ...
moving DB from 2005 > 2000 ?
Joe D -
22 Dec 2005 6:54 PM - 5 messages
I've been testing ways of moving a 2005 database to SQL 2000. I've tried to detach and attach but I get some odd error about dbid in sysindexes. I've tried to backup and then restore but I get some odd error about number of ...
SQL LiteSpeed - Native Command Substitution
BATMAN -
22 Dec 2005 6:37 PM - 3 messages
Hi all, I just have a few questions about Native Command Substitution in SQL LiteSpeed... What kind of overhead does this cause for other commands being passed through to the server? Is there any documentation that discusses the ...
Help
melindam -
22 Dec 2005 6:11 PM - 12 messages
I need some help... SELECT 'YEAR' = year(entrydate) ,'MONTH'=month(entrydate) ,'Clients' = adversesurname ,COUNT(adversesurname) AS Numduplicate FROM dbo.atlas_mast where year(entrydate) = '2004' and month(entrydate) = '10' GROUP BY year(entrydate), month(entrydate), adversesurname HAVING ( COUNT (adversesurname) > 1 ) ...
Query that returns record counts based on variable
ViLo -
22 Dec 2005 5:31 PM - 3 messages
Hi all, I have the following table: CREATE TABLE [dbo].[Company]( [CompanyID] [int] IDENTITY(1,1) NOT NULL, [CompanyName] [varchar](100) NOT NULL, [CompanyTypeID] [int] NOT NULL, [Active] [bit] NOT NULL) ...
Delete Cluster Index With PK and FK Constraints
Joe K. -
22 Dec 2005 4:30 PM - 3 messages
I have a SQL Server 2000 database that I would like to delete the Cluster Index with a primary key. This primary key has a foreign key constraint. Please help me create the syntax to delete the Cluster Index on Table A. ...
SQL Server BSOD
Clint -
22 Dec 2005 4:06 PM - 11 messages
Hello, I'm experiencing a odd and troublesome problem. Whenever I attempt to do an attach database through Enterprise Manager, sp_attach_db in Query Analyzer, and a restore backup in Enterprise Manager, our SQL Server blue screens with an error in NTOSKRNL.EXE. ...
Unique Index that don't care about null values
Fabio Cavassini -
22 Dec 2005 3:12 PM - 3 messages
Hi, Is it possible to make an unique restriction on a column, but that it allows repeated null values? I have a table with a column that not always is required, but, when it's required, it must be a unique value. ...
Open db connection, disable Screen Saver??
Courtney R -
22 Dec 2005 3:11 PM - 2 messages
We have a application developed in house, which runs on SQL 2000 server. Some people have reported that there XP desktop screen saver does not run when they are in the application. Can a open db connection disable the screen saver from running? ...
'Suspect Database' SOS
laurenq uantrell -
22 Dec 2005 2:59 PM - 11 messages
I was running an update query on a table containing 6.5 million rows and cancelled the query afrer running more than 14 hours. Now my database reads "SUSPECT" and all the tables etc. do not appear in Enterprise Manager. ...
Beginner Question - SQL Server
r-jones -
22 Dec 2005 2:25 PM - 4 messages
Hi, I am currently learning ASP.net 1.1 using the apress Beginning ASP.NET 1.1 E-Commerce book. I am working my way through but have hit a problem on chapter 3. When I try to start the application i get the following error: ...
SQL 2005 -> 2000
Amos Soma -
22 Dec 2005 1:58 PM - 2 messages
Is there any way I can convert a SQL Server 2005 database to 2000, assuming I have not used any features specific to 2005? Thanks very much. Amos. ...
error code sql server
Djeff -
22 Dec 2005 12:48 PM - 2 messages
Good morning MOM server 2005 prompt this message during the installation Failed to setup database security. Error code: -2147217900 (user, group, or role 'SC DW DTS' already exist in the current database) what can i do in this case ...
reset all identity seed in table
John -
22 Dec 2005 12:00 PM - 7 messages
I mad a clone of my db and delete all info that I don't need. how can I reset all identity seed in tables to the beginning numbers? Tnx in advanced ...
tempdb contention?
Toni -
22 Dec 2005 11:17 AM - 4 messages
I've been seeing a message in the SQL Errorlog the last few days on one of my SQL Server 2000 Enterprise Edition sp4 servers. This is on Win2k3 with my SQL Server having 4 procs (2 physical procs hyper-threaded) and ...
rebuild master problem
soonyu -
22 Dec 2005 11:01 AM - 3 messages
I want to move sql server from server A to server B. 1. path of system database in server A and server B in diffrent 2. I backup master.dat from server A to restore to server B and to something ...
replacing hard disk
gracie -
22 Dec 2005 10:34 AM - 4 messages
I have a server running sql 2000. We recently had to replace a failed drive on a raid 5 array. Subsequent to changing it, the performance of the server has declined considerably and blocking locks are occuring, which we never had ...
200 GB SQL Performance
VishSQL -
22 Dec 2005 8:39 AM - 6 messages
Hi Fnds We have a SQL 2000 database it now sizes 200 GB (ERP applicaiton; around 15000 tables roughly). We have some serious performance problem and felt in the application. How to measure the SQL performance in this situation. While the db was intially created it was 2GB and grow by 10%; Auto Grow ...
connections remote SQLExpress
EWAT -
22 Dec 2005 8:31 AM - 3 messages
how I can connect remotely to SQLExpress?.. I have enabled TCP/IP, but it does not work. error: ..... When connecting to SQL server 2005m this failure may be caused by the fact the under the default settings SQL server does not allow remote ...
restore master problem
soonyu -
22 Dec 2005 6:49 AM - 2 messages
When i try to restore master db with sqlservr -c -m -T4022 ISQL -E , restore database master from device='d:\dump\masterdump.dat' restore fail with message Error: 3151, Severity: 21, State: 0. Error: 9001, Severity: 21, State: 1. and sqlserver terminated.. ...
Select Return TOP . . .
TonyG -
21 Dec 2005 10:13 PM - 12 messages
I'm working with a SQL 2000 database where the RETURN TOP n statement in Query Analyzer returns an error and the menu option is grayed out in Enterprise Manager. Where is this controlled and how do I enable it? Any ...
sql 2k Timeout
mecn -
21 Dec 2005 10:07 PM - 2 messages
I set timeout to 0---unlimited but the app still get following error message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. I don't know why? Thanks, ...
Strange error
KTN -
21 Dec 2005 10:00 PM - 2 messages
I got this strange error message on SQL 7.0 Enterprise (SP3) and Windows 2000 AD (SP4). If you have seen this error message, please help. Thanks! CImageHelper::Init () Failed load of symbol file with path = d:\binn\;.;d:\BINN;C:\WINNT;C:\WINNT\system32 - Not enough storage is ...
Group or Not group
Matt -
21 Dec 2005 9:50 PM - 8 messages
Select FN,LN Group by FN from A Gives me Bob Bob Tom Tom Tom Bill Bill Need to achive output of names not after one another if they are same name Bob Tom Bill Bob Tom Bob Bill Order is not important as long as they dont repaeat same name for next ...
SQL Crashing
lreames -
21 Dec 2005 9:49 PM - 2 messages
Running SQL 2k SP3a & Win 2k Today, all of a sudden, my SQL server started going up and down. In the System Event Log, I received the error Event Type: Error Event Source: Service Control Manager ...
delteing NUll records
Johnfli -
21 Dec 2005 9:22 PM - 2 messages
I know I have asked this before, but I can't sem to find it anywhere. How do I delte records that are all NULL? ...
SQL Express for a Web Based App? Any limitations?
ML -
21 Dec 2005 8:17 PM - 2 messages
We have a client that needs to keep costs down and we want to implement a ..NET 2.0 solution with SQL Server. The client suggested MySQL but we would prefer SQL Server for ease of use with ASP.NET. ...
SQLServer 2000 SP4: c0000005 EXCEPTION_ACCESS_VIOLATIONS
Beppe -
21 Dec 2005 7:52 PM - 3 messages
Hi! I have just upgraded SQL Server 2000 SP3 to SP4 on two machines on Win2003 SP1 configured by Linked server My stored procedures work fine except for a stored containing a remote INSERT based on a SELECT described below. ...
Providing Full Date Format but SQL not happy
g3000 -
21 Dec 2005 6:37 PM - 9 messages
I have the below scalar function CREATE FUNCTION DBO.GetRocksPeriod (@pDate datetime ) RETURNS nvarchar(9) AS BEGIN DECLARE @lmonth nvarchar(2), @lyear nvarchar(4), @monthYear nvarchar(9) set @lmonth = convert(nvarchar(2), datepart(month, @pDate), 121 ) ...
change formating
Johnfli -
21 Dec 2005 6:02 PM - 4 messages
I have a txt file that I import into my SQL2003 server. One of the items is formated as 10/10/2005 13:23. That is the way teh file is sent to me. I would like to be able to have it changed to just the 10/10/2005 format. ...
Absolute path information is required. (mscorlib)
Robert Salazar -
21 Dec 2005 5:20 PM - 4 messages
Installed SQL2005 Advisor on a XP Professional machine. I get this message when I launch the program. Absolute path information is required. (mscorlib) Please help, I need to resolve it. ...
Paging
CLM -
21 Dec 2005 5:01 PM - 3 messages
I've got a four way 2000 server that has a buffer cache hit ratio that is 99 or 100 % all the time. However, I am getting Pages/sec quite often on that server between 20 and 100. Is this a problem? I'm asking because I thought ...
Abend info in SQL Log
vtcs212 -
21 Dec 2005 4:21 PM - 2 messages
Is there a way to get application/sql query abends to appear in the SQL error log? For example, we have an application that executes a SQL query. The application will abend because the query failed (invalid object, Foreign key ...
Crash of Enterprise Manager, strange solution
mappopo -
21 Dec 2005 4:16 PM - 4 messages
Hi, Every time I try to use enterprise manager it suddenlly crashes. The server is on, I can access it in other ways but without using enterprise manager. I removed sqlserver from the system, and installed it again. I also installed the service pack 4. ...
Unable to backup SQL after log file expansion failure
CraigLending -
21 Dec 2005 4:05 PM - 12 messages
I had a log file on a SQL2000 database fill, and received several errors stating the transaction log was full, and finally several messages that 'Autogrow of the log file had timed out' with an indication to use Alter Database to grow the file. ...
SSIS - how do I do this?
Corey Bunch -
21 Dec 2005 3:54 PM - 4 messages
I'm importing a field of length 100, but in the destination it exists as a field of length 10. I want to parse the source field into 10 character lengths (10 of them), and then insert into my destination. ...
column dependency search
ChrisR -
21 Dec 2005 3:45 PM - 7 messages
I posted this yesterday with no luck. I thought Id repost but be a bit more descriptive. I want to be able to figure out where a column is explicitly being called. create proc myproc as select MyColumn from Table1 ...
Cannot install SQL 2000
lc_craze -
21 Dec 2005 2:14 PM - 3 messages
When I try to install SQL 2000 on my pc windows xp sp 2 I get previous programme installation left pending files please restart. I already restarted five times but it still doesn't work. Anybody got a clue why it's happening? ...
Workgroup edition for which kind of application ?
Joe -
21 Dec 2005 2:14 PM - 2 messages
Workgroup edition for which kind of application ? how many people support and is it used for web application ? ...
connections not closed by app
usenetjb -
21 Dec 2005 2:12 PM - 4 messages
we inherited this java web app that uses a jdbc-odbc bridge for connecting to 2 sql server 2000 instances. there are probably hundreds of places in the application where connections are not being closed (resultsets and statements not being closed as well). ...
View order by user defined function
Sylvain Nadeau -
21 Dec 2005 1:50 PM - 12 messages
I have a view that is ordered by a call to a user defined function that works fine with SQL server 2000. But with SQL Server 2005, the data is not sorted. ...
SQL Server 2000 Second Instance
Kay -
21 Dec 2005 1:40 PM - 2 messages
All, We had an instance SQL-HA-1, when it crashed, we made another instance SQL-HA-1\TempSQL and are using it. Is there any possibility of performance loss at second instance of SQL Server 2000. TIA Kay ...
CHEKING SQL AGENT IN A LAN
amejiae -
21 Dec 2005 1:40 PM - 5 messages
Hi we have a LAN of 400 stations and sometimes the agent stop in several machines, causing jobs not to run, so i have to check manually if the agent is running. The question is: There's a fast way to check if all the agents in ...
copying databases from live to backup SQL Server
Imran Aziz -
21 Dec 2005 1:21 PM - 3 messages
Hello All, I have two installations of SQL Server, one is the live SQL Server with all live databases. What I want to do is create and update all databases on this second database server which is to be used as a backup, is there a way ...
Please help - unusual warning when creating a column
almurph -
21 Dec 2005 1:06 PM - 5 messages
Hi everyone, This is weird. I create a new column programatically using the "ALTER TABLE" command (you know the one) inside SQL Query Analyzer. The column is indeed created but the following warning is thrown: WARNING: The table 'OrderRecords' has been created but its maximum row ...
DiskIO value in sp_who2
Sumanta Gayen -
21 Dec 2005 1:00 PM - 3 messages
When I run sp_who2, the result set contains a column 'DiskIO'. I want to know if this values shows total number of physical Page Read or Write by a process. Is my understanding correct? ...
detach/attach loses permissions
john clarke -
21 Dec 2005 12:44 PM - 5 messages
Hi, I was wondering if anyone had insight on this. I have traditionally always used detach/attach as a method of copying databases i.e.: I have 2 servers running SQL 2000: serverA, serverB My intention is to copy a database (call it DB1) from server1 to server2 ...
DBCC SHOWCONTIG and Extent Switches
Kay -
21 Dec 2005 12:18 PM - 3 messages
All, I executed the following statement at my production server. DBCC SHOWCONTIG WITH TABLERESULTS, ALL_INDEXES which provided me the following resultset. Besides "AveragePageDensity" and "LogicalFragmentation", I paid special attention to "Extent Swithces" which is quite high. Is there any performance gain if I reduce th Extent Switces? How can I ...
SQL 2005 - 2000 Side by side - can't connect to 2000 from remote m
k_s -
21 Dec 2005 11:41 AM - 4 messages
Hi all, I have sql 2005 and 2000 installed on same machine. both are ent editions. 2005 is default and 2000 is named instance. 2005 works fine locally and remotely. I can connect to 2000 locally using machinename\instancename, through isqlw, could register 2000 server in ent ...
good index?
Frank -
21 Dec 2005 10:55 AM - 3 messages
Hi, I have a table with smallint, smallint, smalldatetime, smallint I made a clustered primary key containg the first 3 colomns. Inserts are something like: 1,1,12:00,2 1,2,12:00,2 2,1,12:00,2 ...
SSMS and BI Studio very very slow
Pat -
21 Dec 2005 10:51 AM - 4 messages
1) It takes about 10 seconds for the in-context menu to appear when I right-click on a table. On subsequent attempts, it appears almost immediately. 2) It takes more than 10 seconds to save a new table design in SSMS (right ...
very low Cache hit ratio infact zero most of the time
bloakley -
21 Dec 2005 10:10 AM - 7 messages
we are currently experiencing a very low cache hit ratio, due to the nature of our business getting out time to allow us to reindex is very difficult - infact we haven't mange to fully reindex for 6 weeks. I'm ...
How to make a enquiry for all database instances?
Kennet Johansen -
21 Dec 2005 9:39 AM - 2 messages
In SQl2000 i were abe to run an enquiry called "DATABASE $ALL" it was used to enquiry all instance names on a SQL server for backup reasons, after upgrading to SQL2005 this enquiry doesn't work. Is there a new way to enquiry for all instance names in SQL2005? ...
Memory for a new W2K3 Server running SQL Server 2000
Robert -
21 Dec 2005 9:25 AM - 2 messages
We are currently running a SQL Server 2000 with 2GB RAM. The database is a small one but we find that SQL Server takes up much memory. I guess that it is because SQL Server will use much memory as possible to increase ...
timecol
shif -
21 Dec 2005 8:26 AM - 2 messages
Hi i am using mssql2000,i want to a time column in a table.but there is no time type how can i keep time in a seperate column. ...
What membership needed for SQL Admin
HL -
21 Dec 2005 6:45 AM - 2 messages
I have sql server std 2000 installed on Windows 2003 std server. My sql administrator request to remote desktop to the server and do sql task. w/o giving him local administrator rights, what others local memberships should I ...
edition of sql 2005 to use as testing server
Joe -
21 Dec 2005 6:18 AM - 8 messages
Dear all, if i want to install a sql 2005 into windows 2003 server for the testing purpose, what edition of sql 2005 should i use, the testing db server is used for developers and end users to test the application, which edition should i ...
MS ACCESS TO SQL SERVER
chaitanya.r.kale -
21 Dec 2005 6:13 AM - 2 messages
Initially i designed my report in crystal report 8.5 by using an ACCESS Database. Later i converted my db to SQL SERVER. Now I'm not able to pass the SQL QUERY FROM VB because it is showing error as sql server could not be opened !!! What could be the problem? ...
Error encountered while installing SQL Server Express Edition
Chris -
21 Dec 2005 4:53 AM - 9 messages
I encountered an error when attempting to install Visual Basic Express Edition RTM. During the setup, I selected MSDN Express Edition and SQL Server 2005 Express Edition. Specifically, the SQL Server 2005 EE part of the installation failed. Here's the error I received: ...
Which edition of 2005 supports Peer-To-Peer replication?
HK -
21 Dec 2005 4:13 AM - 2 messages
The chart on the Microsoft site doesn't say which version supports the new "peer to peer" replication. Anyone know if it comes with Standard? ...
convert datetime data question
Angi -
21 Dec 2005 4:03 AM - 4 messages
Hi, I get a datetime from system like this one : '2003-05-08 12:35:29.998' And I just need '200305'. Can I use Substring or any other way? Thanks for any advice! Angi ...
Expiration of SQL 7 Support
Adam -
21 Dec 2005 2:40 AM - 2 messages
Where can I go to find out when Microsoft will stop supporting SQL 7? or any product for that matter? Thanks. Adam ...
what to be cautious when adding index to a large table
Q -
21 Dec 2005 1:45 AM - 4 messages
Hello: We have a table that has millions of rows. I have added two columns recently, one is a varchar field and one is an integer field. If I want to add index to these two columns, anything I shall be aware of? Any idea as to ...
Need to register 2nd instance on remote server
Brian Kitt -
21 Dec 2005 1:11 AM - 3 messages
I have a SQL server set up by a 3rd party hosting company. They put 2 instances of SQL Server 2000 on the server. One instance is the default instance, the second instance is named 'WWW/SITE'. I need to register both ...
cpu + f(reads) = duration???
jxstern -
20 Dec 2005 11:49 PM - 4 messages
OK, I have an SP that users say runs slow. I take a look, it's taking 2.5 seconds of CPU and doing 600k reads to give a duration around 3.0. I munge around the logic and cut the reads to 90k. The CPU rises ...
Variable TOP statement within a stored procedure problem
lumazi -
20 Dec 2005 11:48 PM - 9 messages
Everyone, I'm having an issue using a variable with a TOP statement and was wondering if anyone has run across this before. My stored procedure is as follows ... -------------------------------------------------------------------- set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ...
|
|||||||||||||||||||||||