My table has 5 columns A,B,C,D,E
i've clustered index on (A,B,C) & a non-clustered on (B,A)
Is that OK or will that degrade the performance. Is it useful.
My some queries are based on columns B , A &
some on the other combination
Shubhangi
shubhangi
Last Activity: Mar 4 '08, 08:33 AM
Joined: Sep 1 '06
Location:
-
Login failed for user 'DomainName\shhi'. [SQLSTATE 28000] (Error 18456).
Hi,
I'm trying to run a job. The script contains a code which access remote server. The job fails. The same job when pointed to local server runs successfully.
Error given when execting a job is
"Login failed for user 'DomainName\shh i'. [SQLSTATE 28000] (Error 18456). The step failed."
I've added the remote server as a linked server. Also i can access the remote server's data through... -
Hi,
Try following steps
1. change mode from FULL to Simple.
2. Right-click the DB & in shrink option, shrink only log files.
3. revert the mode to Full.
You will certainly see lot of difference in size of log files.
Shubhangi... -
shrinking a table of database
Hi,
Can I shrink a table in a database?
If yes then how?
Thanks in advance.
Shubhangi -
Hello,
Stop the sql services of a source server, copy .mdf & .ldf file to target server & then attach the db in target server as follows
1. In Enterprise manager, right click on databases & go in all tasks & then attach db
2. select .mdf file from the copied location & attach it
u will see db is copied.
ShubhangiLeave a comment:
-
backup
Hi,
Can I take a transaction log backup after executing "Backup log dbname with Truncate_only" script on db.
If I take a transaction log backup, is it guarenteed that whatever matter (changes or required logical log) what was there before executing the stmt will be there after executing the stmt.
There should not be any loss of logical log which will create problem if restored.
Please... -
import/export utility
Hi,
My m/c has a client installation of sql 2005. Now I'm connecting to sql server 2005 through vpn. But here my import/export utility is disabled. Please can u tell me "is this a feature of client m/c or some other problem?"
When by same login I connect the server through remote desktop , import/export utility is enabled.
Please tell where I'm going wrong?
Thanks
Shub... -
parameters
Hi,
What is the maximum number of input parameters used in procedures/functions.
How that will affect the query performance.
Thanks
Shubhangi -
reindex
Hi,
what are the unknown bad effects of executing "dbcc reindex" statement on a table.
Does executing it affects the performance of server.
thanks
Shubhangi -
Hi,
u can include send mail cmd after u configure sql mail on yr m/c.
yr cmd can include
EXEC master..xp_send mail
@recipients = 'mailid',
@subject = 'Data inserted through Insert Trigger'
This is not a normal pratice as everytime trigger is fired a mail will be coming. u can use this for testing purpose.
Shubhangi...Leave a comment:
-
identity
Hi,
When do I use option
"Yes (Not For Replication)" for identity column.
Is it used for bidirectional replication ?
thanks
Shubhangi -
Stored Procedure - Urgent
Hi,
What is the maximum length of output parameter in case of procedure.
In my procedure I have mentioned "@conatresu lt varchar(8000)", then too result is truncated after 256 len.
EXECUTE ATTRITION_CONCA T_TEST 'EMPLOYEE_ID',' #TEMP',@CONCATP ROFILE1 OUTPUT
print @CONCATPROFILE1
gives total result (3704)
but select @CONCATPROFILE1
gives truncated... -
execute command - urgent!!
Hi,
Please check following code.
In below code I don't want to display results of "execute (@sql)", but want @cntA to be displayed. Is there any command to stop display of execute command as per situation.
DECLARE @YEAR1 VARCHAR(10),@MO NTH1 VARCHAR(10),@SQ LJOINYR VARCHAR(50),@SQ LJOINMN VARCHAR(50),
@CS VARCHAR(1), @SQL VARCHAR(1000),@ CSTYPE VARCHAR(50),@cn tA int
SET @YEAR1 = '2004'... -
concatenation
Hi,
I have previously posted but the reply given didn't solve my purpose.
Please check & revert.
I am unable to concat 2 fields with a space between them in sql query.
I want to write my query in following fashion only as there are many conditions which I concat. Thus I am using variable @sql_st and not the direct sql statement.
Following query works perfect
DECLARE @SQL_ST VARCHAR(8000)... -
Hi,
Space doesn't appears between first & last name using the below query.
please reply....Leave a comment:
-
concatenation with space
Hi,
I am unable to concat 2 fields with a space between them in sql query.
I want to write my query in following fashion only as there are many conditions which I concat. Thus I am using variable @sql_st and not the direct sql statement.
Following query works perfect
DECLARE @SQL_ST VARCHAR(8000)
set @SQL_ST = 'SELECT EM.EMPLOYEE_ID,
(EM.FIRST_NAME + EM.LAST_NAME) as emp_name from employee_master... -
FK - urgent
Hi,
I have a Fk on table1 whose id is mapped to table2
Following FK options are enabled
1.enforce relationship for insert/update
2.cascade update
3. cascade delete
Now when I update a row in table1, data from table 2 is deleted.
This is done through query analyser & not frond end.
why deleted on updating.
Please reply.
Thanks -
Foreign Key
Hi,
Is sql server performance affected with 7 to 8 FK on a single master table.
Thanks
Shubhangi -
time stamp data type
Hi,
I want to enter only time from frontend & not date time.
Can I do this & can I store this in DB. If yes, what will be data type to store only time values. How do I retrieve the time data in case I want to find difference.
Please reply.
Thanks
Shubhangi -
trigger - v.urgent
Hi,
When will trigger fail in sql server 2000.
This I want, so that I can specific alerts in code.
thanks
shubhangi
No activity results to display
Leave a comment: