SQL Server 2008 (major build version 10.00.xxxx). Please also tag with sql-server.

learn more… | top users | synonyms (2)

-1
votes
3answers
188 views

Alternative of a query

I have a query : SELECT TOP 21 * FROM ( SELECT ROW_NUMBER() OVER ( ORDER BY contacts.id ) AS row_number, contacts.id, contacts.first_name, ...
1
vote
2answers
331 views

Found errors in table after executing DBCC CHECKTABLE command

I am trying to alter table to add primary key ALTER TABLE GeoCity ADD CONSTRAINT PK_GeoCity PRIMARY KEY(locId) and got this error message Msg 1750, Level 16, State 0, Line 1 then I run ...
0
votes
2answers
52 views

A simple Query causing high CPU in SQL Server 2008

We are noticing below SQL is causing very High CPU and its been executed 10,000 times. Is there a way we can tune this T-sql? SELECT ISNULL(max(trans_seq),0) +1 FROM inv_inventory_journal WHERE ...
0
votes
2answers
75 views

Mapping a Login to a User

On my production system I login to SQL Server with CPSDOM\mconnors. When I execute SELECT CURRENT_USER; it returns CPSDOM\mconnors. We use Windows authentication on our DBs. On my test system I ...
0
votes
2answers
45 views

Is there anything wrong with creating a very large log file?

I've been given the task of finding out why our server is slow. First of all I did not set this server up. Is there anything wrong with setting the initial log file size to 70GB? That's what ours is ...
-1
votes
2answers
76 views

Getting a total value for items obtained in the current quarter

I've been working with MS SQL Server Management Studio and have a problem I can't fix. I am currently able to get the total for a set of values (Volume and Activity) from my SQL Server database. ...
-1
votes
2answers
1k views

Update code works in manual stored procedure but not when run as SQL Server Agent Job

I have a stored procedure that deletes all records from an existing table, and then inserts new records. After the insert I have several update operations that change the value of one field. If I run ...
-1
votes
2answers
3k views

Error installing SQL Server 2008 - all componets installed successfully except database engine

Below is the error I copied, please someone help me, I have tried at least 10 times in the last 3 days. It is SQL Server 2008 R2 and I wanted to install it on Windows 7. Microsoft SQL Server 2008 ...
-1
votes
2answers
221 views

Validate every client has a valid gender

I have table CLIENT which have columns are COLUMN_NAME DATA_TYPE DESCRIPTION SOURCE TABLE ClientPK int Identity column ClientID int Client ID PARTY ...