A SQL Server have a very bad perfomance which is in cluster environment. Need to do a immediate analysis. But not familiar with the applications or...
This is a funtion to Parse values. This is working fine in sql 2000. Since FUNCTION is not supported in SQL 7, it is not working.
Please help me
I have to create a SP.
The secenario is that,
A application calls the SP with a parameter(login), and a string of datas ( Acctid...
I have been given a task to do a load test in SQL.
The test is to put a load in the SQL server (large or purposely deadlocking query on...
I tried running a Store procedure from two servers, in one server it was working fine, but while running on other server, i am getting...
ALTER TABLE table 1
ADD column1 money NUlL DEFAULT '0',
column2 int NUlL DEFAULT '0',
column3 money NUlL DEFAULT '0'
I have to find the discrepancy between two tables
I have Table 1 with columns
Table 2 with columns
I have a table with
C3-Date with time
I need to create a daily process that will remove the oldest data(data older...
while executing sp_who i got the below result
Spid Status Login Host Blk Dbname cmd
22 sleeping sa XXXX 0 User_DB Awaiting cmd
I have been given a project plan to leave only 30 days of History on 3 tables (T1, T2, T3) on SQL 7.0.
But all the historical information...
Separate names with a comma.