Using MS SQL Server

Memory limitations, 2005 Standard
Hi all, I have recently implemented a SQL 2005 cluster using SQL 2005 Standard on Windows 2003 Enterprise edition. Both nodes have 4GB of RAM and according to the datasheet, SQL 2005 Standard can support the OS maximum memory amount and Win2K3 Ent Edition can support 64GB! However, in Enterprise Manager, if... 10 Mar 2006 04:55

Divide by Zero
When I specify a formula between Computed Column Specification, I have two zero values, getting Divide by Zero error, any idea how can I avoid this? I still want SQL Server to display Zero if it is 0/0, is this possible in SQL Server database? Thanks J. ... 9 Mar 2006 04:29

itzik ben-gan
I am using the following query which I found from a fragmanet of code by itzik ben-gan to assign a common group id for group of records in my case which have similar SSN and first Name and Last Name. if the SSN is the same it should also check the first name and last name of the record. Becuase records have mor... 27 Mar 2006 13:07

Embedded Queries?
I'm looking into a problem a friend is having, and I'll say right off the bat that I work with with php and MySQL, and not MS SQL. What he is attempting to do (in MS SQL) is take two database fields from a table (string fields), multiply them together, and put them into a third field. This third column in the ta... 18 Feb 2006 16:23

limit resources per user
Is there some kind of way to limit the resources (CPU, number of sessions) per user in MS SQL 2000 database. Some kind of resorce manager thing... ... 15 Feb 2006 18:39

Read, modify table (locking) question
I am quite new to MS SQL, and I want to read rows from a todo table, and when a row has been processed, I want to delete that row. Ages ago in MySQL I would probably have locked the table, select, process a row, delete a row, unlock the table. I have been reading through the documentation from MS SQL, but it'... 3 Feb 2006 17:39

SQL Server 2005: setup problem
Hello, (sorry for my English...) Could you help me please with installing SQL Servera 2005 Express Edition. I downloaded files: SQLEXPR.EXE - Microsoft SQL Server 2005 Express Edition SSEUtilSetup.EXE - SQL Server Express Utility SqlServer2K5_BOL_Dec2005.msi - Books Online December 2005 and I tried to run th... 5 Feb 2006 03:15

update statement not to fire trigger
I have a trigger on UPDATE on a table. I'm running some maintenance UPDATE and DELETE queries which I want the trigger to ignore but at the same time I want other UPDATE queries that other users might be running to keep triggering the trigger. Is there a SET statement perhaps that I could set before my query? Or... 1 Feb 2006 18:14

Database normalization
Hi, I am using MS-SQL server to store my database. My problem is that I have around 150+ database files in DBF format. Each database file consists of fields ranging from 2 to 33 in number. Also, there are some fields which have just one entry and rest are NULL. This database will be accessed by a printing softwar... 31 Jan 2006 10:17

How to find first not null value in column
Hi, How to find first not null value in column whitout chacking whole table (if there is a not null value then show me it and stop searching, the table is quite big)? thx, Martin *** Sent via Developersdex http://www.developersdex.com *** ... 6 Feb 2006 00:35