Hi , I have table on which i have search records on differnent combinations. Select Distinct ID from table1 where (C1 = 23 OR (C1=0 AND C3='Y') OR...
Hi, In a Stored procedure , I am inserting rows in a temporary table does not having any index. If I issue Truncate Command on this temporary table ....
Hi, Here are the statistics of two queries doing the same thing. which query will give better performance: a) Table 'abc'. Scan count 1, logical...
Hi, Can CTEs be called again and again with in SP Scope. See Code Follows: Create Proc TestCTEAS Begin With DataSet(EmployeeID,RowNumber) As (Select...
Hi , We have to design an application in which front end needs to have flexiblity to design queries at runtime and execute against the database....
Hi , What will be the best approach to fetch the data from source tables : 1) Fetch data from source table into temprary tables based on some filter...
Hi, We have table or Group of related tables, data of which to be archived into other database or table on some condition like can use Status columns...
Hi All, We have SQL Server database with 200 GB and 1000 concurrent users. We want to scale this to 4000 concurrent users. What should we kept in...
Hi, I want to import records from Oracle database to SQL Server database usign integration services. After import i want to verify all the records...
Hi, I want to implement paging of my records from database stored procedure. Please advice on the best possible way. so that 1) It can handle 200...
Hi All, I want to write a trigger that caters to Insert,Update and Delete events then how in the trigger body i will see that event...
Separate names with a comma.
