1. I have 1 table "EmpTable" having 5 columns,2 indexes and 2 triggers. I want to add new column to "EmpTable" at 3 position. How I can add the new...
Hi, Please explain me the basic steps for the Tuning for SQL server 2000.
1. what will happen when .mdf and .ldf file of any database is deleted ? 2. what will happen when only .ldf file of any database is deleted ? 3....
hi, Plz explain me about the Detach and Attach . Use of Detach and Attach
I have one table as follow PlanName Category Name Payment Discount ABC Payment Discount XYZ Payment variance 123 Payment variance...
I have the following string @string = [rule("Total Covered Days",["Covered Days","Process Rule"],["",""],["Total Covered Days"]), rule("Total...
I have one string as follow [rule("Total Covered Days",["Covered Days","Process Rule"],["",""]),rule("Flat Rate",["Reimburse Amt","Flat...
i have table as follow key list seqno 1021 abc 1 1021 xyz 2 1021 pqr 3 1022 mno 1 1022 def 2 1022 jkl 3 I want to make a...
i have one string #[rule("Total Covered Days",["",""]),rule("Total Covered Charges",["","UB"],rule("Flat Rate",["Reimburse Amt","Flat Ra# i want to...
Hi, The database on which I am working, have 220 stored procedures. I have to find out the procedures those have parameter sniffing problems. How...
Hi, Is somebody will give me some idea about the parameter sniffing? What is parameter sniffing?? How to overcome with this problem??? I have one...
Which will be faster (a) Select * from (b) Select count(*) from (c) Select colm1,count(*) from and why
Separate names with a comma.
